ADO.NET SQLite pcl library for Xamarin

Question

Is there available ADO.NET pcl library for sqlite? It can be also simple (not pcl) library. I am looking especially support for Windows Runtime (Windows 8.1 metro app). As I know there is mono implementation of ado.net for Android and IOS. But I cannot find any implementation for Windows Runtime.

The libraries like sqlite-net-pcl are not applicable, because I need to create dynamic set of data.

WinRT version of Microsoft.Data.SQLite : github.com/TheBlueSky/Microsoft.Data.Sqlite.WinRT — SushiHangover
Thanks, it seems to be a solution. I am wondering if I should use it because this library is very immature. — raV720
Its based on Microsoft.Data.Sqlite that is actively maintained by Microsoft and both are OSS... — SushiHangover

Jon Douglas Jon Douglas · Accepted Answer · 2017-01-03T16:33:23

Since ADO.NET is fairly old, it's more of a platform implementation rather than a PCL-available class. However you could write your own wrapper in which Windows platforms would call into Microsoft.Data.Sqlite or System.Data and Mono/Xamarin platforms would call into Mono.Data.Sqlite.

Seeing that Microsoft.Data.Sqlite is now more portable(available in netstandard1.3), you should be able to just use Microsoft.Data.Sqlite in your projects as long as you target netstandard1.3+ as a means to get a DbConnection in true ADO.NET fashion.

ADO.NET SQLite pcl library for Xamarin

1 Answers