C# Open SQLite file

Question

i would like to open SQLite DB file in C#.

I have this code rewrited from Visual Basic source code.

SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = "Data Source=C:\\web.db;";
myConnection.Open();

but i can't open the file 'web.db' on local computer in C# Console Application.

Jon Skeet · Accepted Answer · 2017-12-30 21:59:06Z

3

You'll need the SQLite ADO.NET driver for .NET or something similar.

edited Dec 30, 2017 at 21:59

answered Nov 27, 2010 at 16:40

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

2 Comments

Jon Skeet Over a year ago

@dESource: I've updated it to a SQLite ADO.NET driver; I don't know whether it's the same one that I referred to 7 years ago though...

Sracanis Over a year ago

thanks for the prompt response. Yeah that's the same I've tried couple of time but no luck, don't understand this issue is with the binary or VS. I have the following error: 'Could not load file or assembly 'SQLitePCLRaw.core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1488e028ca7ab535'. The system cannot find the file specified.' I installed SQLitePCLRaw.core, Version=1.0.0.0 then I came across with this error:You need to call SQLitePCL.raw.SetProvider(). If you are using a bundle package, this is done by calling SQLitePCL.Batteries.Init().'. Long back it use to work fine though.

Hashim Akhtar · Accepted Answer · 2015-12-28 16:17:49Z

0

You can use NuGet in Visual Studio to install the offical System.Data.SQLite drivers created by the SQLite development team.

answered Dec 28, 2015 at 16:17

Hashim Akhtar

8912 gold badges11 silver badges17 bronze badges

Collectives™ on Stack Overflow

C# Open SQLite file

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related