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.
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.
EntityConnectionStringBuilder class with the connection string builder of your store provider is the simplest approach to create a connection string dynamically.