SQLite4Unity3d | SQLite made easy for Unity3d | Database library
kandi X-RAY | SQLite4Unity3d Summary
kandi X-RAY | SQLite4Unity3d Summary
SQLite made easy for Unity3d
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of SQLite4Unity3d
SQLite4Unity3d Key Features
SQLite4Unity3d Examples and Code Snippets
Community Discussions
Trending Discussions on SQLite4Unity3d
QUESTION
I am trying to use sql-lite in my Unity3D project. In fact, I used it in the past now I am trying to update it. Unity version and sql-lite version has changed since then.
Now I get an error like this;
error CS1703: Multiple assemblies with equivalent identity have been imported: 'C:\Users[username]\Documents\Unity Games[your program name]\Assets\System.Data.dll' and 'C:\Program Files\Unity\Editor\Data\NetStandard\compat\2.0.0\shims\netfx\System.Data.dll'. Remove one of the duplicate references.
As I understand from the message that, sqlite wants to use its own System.Data.dll file, but it has the same library name in .net. So this causes a conflict and unity throws an error.
I tried to delete the System.Data.dll and its meta filewhich is in Assets file, but did not work. I also tried to change the file name in Asset folder but nothing changed...
Do you have a solution for this problem? I have tried in both Unity 2018 and 2019 versions.
Additional info may help others: In the past I had a problem with sqlite in my games. I had handled the situation like putting or copying my data sqlite file (filename.sqlite as an example) into the folder:
C:\Users[username]\AppData\LocalLow\[app folder]\[app name]\filename.sqlite
Because unity looks for the folder in script and that folder exists in windows which I mentioned above;
string filepath = Application.persistentDataPath + "/" + "filename.sqlite";
This helped me to solve my problem in the past. Now I am stuck with a different problem...
Solution: Here is the solution by the guied of Алексей Кудряшов and blending my sqlite package. Thanks to him for his suggestion.
1- I deleted all all Plugins, GoogleMobileAds, PlayServicesResolver etc.
2- I first installed my admob package back
3- I installed everything manually in the link; SQLite4Unity
4- I installed sqlite package but while installing it, I select none and i installed only "Mono.Data.Sqlite" file. If you have it or if you find it you can manually add it into Asset folder of Unity3D. Also you may find it from; SQLite web page
5- Then Console said me that there is a conflict in x86 and x64 folders for sqlite3.dll file so, I clicked the x86 folder, then clicked sqlite3.dll then in the inspector panel I disabled everything.
6- Then I imported "using SQLite4Unity3d;" for my data script.
7- I also imported "using Mono.Data.Sqlite;"
8- Then everything worked well.
...ANSWER
Answered 2019-Oct-20 at 19:00Did you try to use another SQLite wrapper? e.g. SQLite for unity
You can just remove your current SQLite plugin and replace it with this one. Don't forget to re-launch unity and unity HUB, cuz unity will keep DLLs in the memory until it restarts.
QUESTION
I'm building a simple 2D sidescroller game with unity 5.0 and sqlite database for android. I had my plugins from this link https://github.com/codecoding/SQLite4Unity3d and successfully built it for android. but the problem is it is not loading any database. Any help?
...ANSWER
Answered 2017-Feb-01 at 08:44Look at CodeCoding SQLite4Unity3d Plugin. It basically contains everything you need for fast-forwarding integration of SQLite into Unity3D.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install SQLite4Unity3d
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page