开发者

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

开发者 https://www.devze.com 2023-01-03 05:09 出处:网络
I am trying to connect to a sqllite db from with a c# application. I have never worked with SQLLite before.

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. Us开发者_JAVA技巧e :memory: to open an in-memory database at System.Data.SQLite.SQLiteConnection.Open()

Any more suggestions?


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.


According to this, data source should be DataSource

0

精彩评论

暂无评论...
验证码 换一张
取 消