Open .sqlite file with C#

Question

Hi i have a file called test.sqlite. How do i go about reading all contents from this file to the console? I already have System.Data.Sqlite

static void Main(string[] args)
        {
           SQLiteConnection _SQL = new SQLiteConnection("Data Source=C:\\test.sqlite");

           _SQL.Open();

           SQLiteCommand cmd = new SQLiteCommand();

        }

Answer 1

To use SQLite in your C# application, you need to download a third party free ADO.NET data provider SQLite.NET.0.21_x68_dll.

You can download it from here: Sql Lite Driver for C#

and here is another usefull video tutorial which you must watch: System.Data.Sqlite

Hope this helps.