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

Posted by Nick on Stack Overflow See other posts from Stack Overflow or by Nick
Published on 2010-06-14T16:44:28Z Indexed on 2010/06/14 16:52 UTC
Read the original article Hit count: 274

Filed under:
|
|
|

Hey all...

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

© Stack Overflow or respective owner

Related posts about c#

Related posts about ADO.NET