Hi All, I have an issue with my first use of SQLite. In summary, I have an Entity Framework model based on a SQL Server database (Database-First implementation) and I want to use those models in an application, but with SQLite as the back end.
Our data is stored in SQL Server. We're developing a desktop application which we will distribute to clients along with a snapshot of our data, and I want to use SQLite as the client DB, to avoid extra installer overheads with LocalDB. We're all new to SQLite. The application will be a .NET windows Forms application, so we're using System.Data.SQLite. I want to use Entity Framework to query the data. Because this data will also be used in other applications, primarily on the web using SQL Server as the back end, I want to use a class library so we don't have to maintain different versions of the models, as our data structure is quite changeable. SQLite is working quite happily with Entity Framework and models in the same project, but when I try to use it with my class library models, I get an error: Unable to cast object of type 'System.Data.SQLite.SQLiteConnection' to type 'System.Data.Entity.Core.EntityClient.EntityConnection'. Would anyone be able to point me in the right direction to get things moving? Really appreciate the help! Simon Dunne New Product Development, Design & Marketing Support Manager (IT) Focal Research Ltd Tel: 01297 22626 Fax: 01297 625828 www.focalresearch.co.uk<http://www.focalresearch.co.uk> +++++++++++++++++++++++++++++++++++++++++++++++++++ This message is confidential and intended for the addressee(s) only. If you have received this e-mail in error, please contact us immediately and delete the message from your system. Any views or opinions expressed in this message are those of the individual and do not necessarily represent those of Focal Research Ltd. [email protected]<mailto:[email protected]> +++++++++++++++++++++++++++++++++++++++++++++++++++ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
