Sqlite Database : System.Data.SQLite or Microsoft.Data.Sqlite;

[techasuran]

Hi Team,

I am completely new to sqlite , very much eager to use the sqlite, since we have lot of file read/write operations, we can replace it with sqlite db which is light weight.

we are using .net with c# (winforms and console) and asp.net core webapi

but I am confused with lot of simple steps like below.


1, System.Data.SQLite or Microsoft.Data.Sqlite? which is better and good for long term ? which is continuously updated and adding features ? we are moving lot apps to Azure and .net core

2, I am facing some issue in Microsoft.Data.Sqlite while doing multiple inserts, but its working fine with the System.Data.SQLite

3, If we need to create a database is just to create a file with .db extension, is there any other way.

4, Do we need to install anything specifically for sqlite, I can create db with out that at the moment.


Thanks & have a nice day ahead

Continue reading...