After deployment, the Entity Framework connection to the SQLite database is not functioning.

.net connection entity-framework web-config

Accepted Answer

The connection string worked just fine. The issue was that the system.data.sqlite.dll and system.data.sqlite.linq.dll needed to be deployed to the Bin folder of the web service hosting the database connection.

6
2/8/2010 9:50:45 PM

Popular Answer

I believe your connection string to be accurate. Are you certain the server has the SQLite ADO.NET provider loaded correctly? Examine your machine.config file to see whether System.Data is listed anywhere. In the DbProviderFactories section, SQLite

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

You must essentially specify: - the model metadata (the sections beginning with "res:/...") the vendor of the shop ("System.Data.SQLite" in your case) - the store connection string, which differs based on the service provider you select.

Using the EntityConnectionStringBuilder class with the connection string builder of your store provider is the simplest approach to create a connection string dynamically.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow