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();

        }

sounds like a similar question -stackoverflow.com/questions/4292654/c-sharp-open-sqlite-file — Karthik
– Karthik, Commented Nov 18, 2011 at 5:36
What do you mean by "file called test.sqlite", is it a database of extension ".db3" or some other. — Sai Kalyan Kumar Akshinthala
– Sai Kalyan Kumar Akshinthala, Commented Nov 18, 2011 at 5:40
SqLite is a database. Why would you want to read its entire contents to the console? That's not normally what you do with a database... — Merlyn Morgan-Graham
– Merlyn Morgan-Graham, Commented Nov 18, 2011 at 5:42

talha2k · Accepted Answer · 2011-11-18 05:39:56Z

3

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.

answered Nov 18, 2011 at 5:39

talha2k

25.5k4 gold badges67 silver badges83 bronze badges

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

1 Comment

Glimpse Over a year ago

How is this the answer? He's already using System.Data.SQLite.

Collectives™ on Stack Overflow

Open .sqlite file with C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related