How do I connect to SQLite db file from c#?

Question

I am trying to connect to a sqllite db from with a c# application. I have never worked with SQLLite before.

var connectionString = @"data source='C:\TestData\StressData.s3db'";
            connection = new SQLiteConnection(connectionString);
            connection.Open();

When i attempt to open the connection I get the following exception:

System.NotSupportedException: The given path's format is not supported.
   at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)
   at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)

What am I doing wrong?

Thanks..

Nick

Update:

I changed 'data source' to 'DataSource' as suggested to me. Now I receive a new error:

After changing this I get a new error: System.ArgumentException: Data Source cannot be empty. Use :memory: to open an in-memory database at System.Data.SQLite.SQLiteConnection.Open()

Any more suggestions?

Try removing the apostrophes within your connection string DataSource parameter: @"DataSource=c:\TestData\StressData.s3db". — Will Marcouiller
– Will Marcouiller, Commented Jun 14, 2010 at 17:07

Nick · Accepted Answer · 2010-06-14 17:15:23Z

13

Got it..

"data source=c:\TestData\StressData.s3db; Version=3;"

Looks like the 'Version' attribute is not optional. Interesting that the .NET provider does not show this in the designer property window.

answered Jun 14, 2010 at 17:15

Nick

19.7k53 gold badges191 silver badges313 bronze badges

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

1 Comment

Tim Taurit Over a year ago

Using SQLiteConnectionStringBuilder object to build a connection string (instead of hardcoding it as a string) elliminates most of the problems like this (ambiguous parameter names, typos). When it comes to Version attribute, at least my SQLite doesn't need it.

Brendan Long · Accepted Answer · 2010-06-14 16:47:29Z

1

According to this, data source should be DataSource

answered Jun 14, 2010 at 16:47

Brendan Long

54.6k21 gold badges154 silver badges194 bronze badges

3 Comments

Nick Over a year ago

Doh! I think you are right. After changing this I get a new error: System.ArgumentException: Data Source cannot be empty. Use :memory: to open an in-memory database at System.Data.SQLite.SQLiteConnection.Open() I must have to provide an argument?

Brendan Long Over a year ago

@Nick, I've never used this, but from the docs it sounds like the argument should be new SQLiteConnection("DataSource=C:\TestData\StressData.s3db"). I don't know why it's not working :\

Nick Over a year ago

Actually it looks like it should 'data source'

Collectives™ on Stack Overflow

How do I connect to SQLite db file from c#?

2 Answers 2

1 Comment

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Related