hi,
i have not found a possibility to get sqlite running with unity indie. so i want to purchase unity pro. before i do this i have a question if the things i plan to do are possible so i would like to ask you for verification or falsification of my thoughts.
if i understood the sqlite docs right there is no reader-object available but a sql query returns a string which i need to decompose manually.
am i able to use some mono built in reader object for convenience (i have worked with ado.net some time ago)?
am i able to use linq with sqlite?
i would be happy if you have a short explanation or link how to achieve these both tasks if they are possible.
many thanks for your help.
with kind regards
henry
purchasing unity pro will not change the ability to do this, as indie is the exact same when working with sqlite. If you looked at the comparison page: Real-time tools for 3D, AR, and VR development | Products , you would see that differences are mainly dealing with visuals, not anything related to scripting (other than native plugins)
Linq: yes, it’s supported, mostly. There are some functions that are not available, but if you are using visual studio, with the project as .net 3.5, whatever it lets you autocomplete should compile fine.
Like I said though, if you are incapable of getting indie working with sql lite, then you will experience the exact same thing with pro.
You can use SQLite as a Native Plugin using Pro. It’s called sqlite3.dll/.dylib
You may also be able to use SQLite in Free, using Mono.Data.SQLite, as it eventually links to a native DLL, the Unity Project is linking directly to a C# DLL. This C# DLL contains SqliteDataReader which you may be familiar with if you are looking for a Reader Object. In the Native code version you would have to do this yourself.
The C# version definitely works on all platforms in Pro, but I can’t verify free.
@cerebrate:
the problem is that free/indie does not support plugins. and from what i read it is required to put sqlite dll in the plugins folder. i have tried almost 2 days around and didnt get it working (with c#) especially because many forum posts concerning this topic seem to be old/deprecated/outdated (or i’m to stupid).
so sooner or later i would like to purchase pro anyway so this seems a good oportunity to do it when it allows me to do what i want more easily.
@ntero:
yes i read that it works with pro fluently. but i was not sure if it does also works together with linq or a reader.
so this seem to be good news. if anyone has something to add feel free.
many thanks so far for the thoughts.
It’s not quite Fluently, but with a little finnagling it’ll work.
If you plan on doing iOS and want Byte-code stripping there is another step I didn’t find anywhere else, which is you need to use Link.xml to preserve System.Globalization.CultureInfo, but that’s only an issue with a stripped iOS build.