Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

enter image description here

SYSTEM.DATA.SQLITE NuGet Package

enter image description here

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?

like image 400
TheQuestioner Avatar asked Aug 12 '16 23:08

TheQuestioner


People also ask

What is SQLite net PCL?

SQLite-net is an open source and light weight library providing easy SQLite database storage for . NET, Mono, and Xamarin applications. This version uses SQLitePCLRaw to provide platform independent versions of SQLite. Product.

What is Microsoft Data SQLite?

Microsoft. Data. Sqlite is a lightweight ADO.NET provider for SQLite. The Entity Framework Core provider for SQLite is built on top of this library. However, it can also be used independently or with other data access libraries.

What is SQLite c#?

SQLite is a small, fast, and embeddable open source file system-based SQL database. It doesn't have a separate server component like traditional databases. Rather, it reads and writes data directly in disk files. A SQLite database is integrated with the application that accesses the database.


1 Answers

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.

like image 178
jzeferino Avatar answered Oct 11 '22 10:10

jzeferino