Entity Framework connection to SQLite database not working after deployment

Answer 1

Your connection string seems correct to me. Are you sure the SQLite ADO.NET provider is properly installed on the server ? Open your machine.config file, and check if there is an entry for System.Data.SQLite in the DbProviderFactories section

A link to a good resource about how to construct EF connection strings would be very helpful too!

Basically, you have to specify : - the model metadata (the parts with "res://...") - the store provider ("System.Data.SQLite" in your case) - the store connection string, which varies depending on which provider you use

The easiest way to construct a connection string dynamically is to use the EntityConnectionStringBuilder class, along with the connection string builder of your store provider.

Answer 2

I agree with Thomas, the conn. string looks OK to me. But if you are looking for information about building connection strings, check this out:

• http://msdn.microsoft.com/en-us/library/bb738533.aspx

Answer 3

try double slashes for path ??

G:\\PMPersistence\\xPMDb.s3db

Also specifying your assembly name instead of * would help when the application is looking for ssdl,csdl,msl

res://YourAssemblyName(without the dll extn)/PM_EDM.ssdl|

Answer 4

The connection string was indeed OK. The problem was that you have to deploy both the system.data.sqlite.dll and the system.data.sqlite.linq.dll to the Bin folder of the web service that hosts the database connection.