LINQ To SQL in Compact Framework

Question

I need to develop my Data Access for the new solution that I am creating. This solution, although it contains a Compact Framework Device application and libraries other than a working one. All .NET 3.5. The desktop will handle all data access in the main. I need data objects that are in CF too, Desktop will interact with SQL, and then with a mobile phone and give the corresponding data ...

I like LINQ, and I love LINQ 2 SQL more. There is a lot of hype, and I do not buy Microsoft's internal policy on the recommendation of EF. As long as the EF is too heavy and too complicated for someone to choose, in addition, it is still developing, and EF 4 will have major changes when this happens in a few months. But I can’t wait months to create a project as every developer here, I want something now! After that I want to use LINQ 2 SQL, my problem is that I cannot just copy the generated dbml and use the generated classes. I do not need the reason for the DataContext, I am not going to use CRUD or any database operations using the Mobile App. I just want objects. Has anyone ever come to such a situation? The thing is not to write all the classes,manually representing tables. Because I need them for further LINQ to manipulate objects.

Basically, CF-supporting ORM will do the job! But I do not know any incompatibilities that I would meet.

Answer 1

I was able to change SubSonic 3.0 , the db4o / Mainsoft System.Linq.Expressions port from the Mono project after adding the missing Queryable sources, and Matt Warren IQToolkit to Codeplex to provide the L2S equivalent to CF.

This is just about what is required since Linq expression trees are not supported on .Net CF 3.5.

DbEntityProvider/DbEntitySession AttributeMapping/XMLMapping, Subsonic IQToolkit, .

Answer 2

L2S . drag-and-drop. SQLMetal.exe , .

SQLMetal.exe: http://msdn.microsoft.com/en-us/library/bb386987.aspx

Northwind compact: http://blogs.msdn.com/sqlservercompact/archive/2007/08/21/linq-with-sql-server-compact-a-ka-dlinq-over-sql-ce.aspx

, : http://pietschsoft.com/post/2009/01/Using-LINQ-to-SQL-with-SQL-Server-Compact-Edition.aspx

Answer 3

DevExpress (XPO) . , , ( ).

, , , , .

, XPO.

Answer 4

, POCO dbml, LINQ 2 SQL. , , , .

http://www.codeplex.com/ULinqGen

Answer 5

Kea-Linq Sql Compact Compact Framework?

http://kea.codeplex.com/