Difference between System.Data.SQLite and sqlite-net-pcl

Question

I am just curious about this, given that I've already read Xamarin's Documentation regarding Local Databases.

is it that sqlite-net-pcl is designed for use with XAMARIN?. I mean, if they both run SQLite Database Engine, then, would it be safe to assume that i can use System.Data.SQLite NuGet Package if I wanted to too?

SQLITE-NET-PCL NuGet Package

SYSTEM.DATA.SQLITE NuGet Package

Would it cause harm? Or it is really, and only recommended to use this sqlite-net-pcl plugin?

Hoping someone can clarify me with this one.

Also, I am thinking of implementing the use of Dapper ORM on my Xamarin.Android Project with respect to SQLite Database Engine. I've already made this approach work with standard WinForm Apps. So it is also possible with Xamarin.Android?

Answer 1

As the name says, sqlite-net-pcl is for use in PCL (Portable class library).

When using Xamarin you want to share code between platforms and the best way to do it is via PCL.

Using sqlite-net-pcl o can have you database login in PCL and with that you get cross platform database access.

Regarding the Dapper ORM, it seems you can use it in Xamarin.Android more info here and here.