When I started with Unity3d development I needed to use SQLite in my project and it was very hard to me to find a place with simple instructions on how to make it work. All I got were links to paid solutions on the Unity3d's Assets Store and a lot of different and complicated tutorials.

At the end, I decided that there should be a simpler way and I created SQLite4Unity3d, a library that helps you to use SQLite in your Unity3d projects in a clear and easy way and works in iOS, Android and Windows Phone projects.

Besides that, it uses the great sqlite-net library as a base so you will have Linq besides sql. For a further reference on what possibilities you have available with this library I encourage you to visit its github repository.

*Note: SQLite4Unity3d uses only the synchronous part of sqlite-net, so all the calls to the database are synchronous.

If you want to know more about why I created this plugin you can read more here.

All you have to do to start using it in your project:

1. Download this zip and copy the resulting folder to your Assets/Plugins folder. It contains the dlls that Unity3d will need to access sqlite.
2. Don’t forget to copy your SQLite database file in your Assets/StreamingAssets folder if you’re shipping one.
3. You’re done! Now you can get access to your database using sqlite-net. ;P

If you want to try it I've uploaded a small example that you will be able to find in the "Example" folder. Download the folder and open it with Unity3d to give it a try.

This project is based on the work of:

• @MvvmCross - License: developed and distributed under Ms-Pl - see http://opensource.org/licenses/ms-pl.html

• Sqlite-net - License: custom - see https://github.com/praeclarum/sqlite-net/blob/master/license.md