System.Data.SQLite

Hi All, I'm trying to use System.Data.SQLite with Entity Framework 4 and SQLite3 in a POCO scenario. The EDMX model was successfully created from the SQLite database with the wizard. Then I used the MS POCO Entity Generator. At query execution I get the following NotSupportedException while casting the retrieved properties (here with System.Int64 but also happening with System.String ): "Unable to cast the type 'System.Int64' to type 'System.Object'. LINQ to Entities only supports casting Entity Data Model primitive types." Any idea of what is going on here and how to work around this? This is critical and I'll have to consider alternative technologies if can't get it to work quickly. Any help here would be *very* appreciated! Thanks in advance. Olivier

 Check out my post here http://sqlite.phxsoftware.com/forums/p/2040/9190.aspx#9190.

It may be the same problem I had while using "Model First" in VS2010.

Jacques

 

Thank you Jacques for your reply. I am sorry I did not answer my own question as I've figured out the problem was actually that I was using a wrong Linq expression... Shame on me. It was a port from a Linq2SQL and operations support is different. Thanks for pointing me to the model first approach: we had considered it at first. And I am happy to hear that you guys have managed to leverage it successfully. Olivier

Glad you find your answer :)

 Jacques