Maximum length of connectionstring for SQLite in .Net

Is there any limit for maximum length of connection string for SQLite in .Net , If my path to database file is very long.

I realized that if I provide connection string including "DataSource=" part more than 128 characters,
connection.Open() would return exception saying unable to open database file

I am using following code

DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SQLite")
DbConnection connection = dbProviderFactory.CreateConnection();
connection.ConnectionString = "DataSource=C:\<longNetworkDirectory(WithoutSpaces)Path\<databaseName>.db";
connection.Open();

0 answers