SQL Server compact edition 3.5 and linqtosql

Linqtosql is a good ORM framework, especially for integration in vs2008. SQL ce 3.5 is a lightweight standalone database that comes with vs2008. The tragedy is that vs2008 does not support importing SQL ce tables directly into dbml, so it is hard to understand why Microsoft does this. However, linqtosql in. NET Framework 3.5 states that SQL ce 3.5 is supported. That is, there are methods to achieve this.

After querying msdn, I learned that. Net framework.exe is a tool called sqlmeta.exe (usually the progream files \ microsoft sdks \ windows \ v6.0a \ bin on the system disk). This tool can be used to directly generate the dbml of linqtosql. Then you can reference this file in the project.

Simple sqlmeta usage example

Sqlmetal.exe dbsample. SDF / Dbml: dbsample. dbml (Sqlmeta.exe complete syntax can be seen here http://msdn.microsoft.com/en-us/library/bb386987.aspx)

 

Digress: I suddenly think of it here. People who liked to attack Microsoft technology a long time ago often say, "Microsoft has mixed IDE and compiler together, as a result, many people cannot develop without Visual Studio.Program", In reality, more and more underlying technologies have been packaged by Microsoft and become easy to use and developed quickly. However, programmers have to pay a high price for this, but they do not know the result. As a result, many times we can only passively follow Microsoft. In the release note of SQL ce 4.0, it has been indicated that linqtosql is not supported, but the Entity Framework ~~ Hoho, change again ~