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?

In my own performance tests, sqlite-net-pcl was way faster than System.Data.SQLite. — Uwe Keim
– Uwe Keim, Commented Dec 18, 2019 at 14:37

jzeferino · Accepted Answer · 2016-08-13 00:01:47Z

5

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.

edited Aug 13, 2016 at 0:01

answered Aug 12, 2016 at 23:56

jzeferino

7,8701 gold badge42 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

TheQuestioner Over a year ago

by PCL you mean the use of Xamarin.Forms right ?. but what if, let's say the project is focused on Xamarin.Android ?. sorry for asking strange questions. interesting enough, is there any difference with sqlite-net-pcl and System.Data.SQLite packages ?. like, the way one will use them, the syntax, and the database file. is it just the same ?

jzeferino Over a year ago

PCL does't mean the use of Xamarin Forms. You can have PCL in your Android Project. It would make sense if you later on need to add the iOS application. If you don't want to use PCL, i would recomend to use the sqlite-net github.com/praeclarum/sqlite-net

TheQuestioner Over a year ago

this is interesting. maybe i'll check in more to sqlite-net-pcl and explore while i'm at it. thank you :)

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related