SQL Server compact and LINQ to SQL?

SQL Server compact and LINQ to SQL?

By default, SQL Server compact 3.5 is installed in all Visual Studio versions. Therefore, it can be used with LINQ to SQL on the development computer. However, applications using SQL Server compact 3.5 and LINQ to SQLProgramDeployment is different from the deployment of SQL server applications. SQL Server compact 3.5 is not part of the. NET Framework. Therefore, it must be packaged with the application or downloaded separately from the Microsoft website.

Note the following features:

• SQL Server compact 3.5 is packaged into a DLL that can be directly used for database files (with the extension. SDF.
• SQL Server compact 3.5 runs in the same process as the client application. Therefore, the communication efficiency with SQL Server compact 3.5 is much higher than that with SQL Server. On the other hand, SQL Server compact 3.5 must be hostedCodeInteraction between non-hosted code, which consumes a certain amount of money.
• The size of SQL Server compact 3.5 DLL is small. This feature reduces the total size of the application.
• The SQL Server compact 3.5 is supported by the SQL to SQL runtime and sqlmetal command line tools.
• The object link designer does not support SQL Server compact 3.5.

 

Sqlmetal.exe northwind. SDF/dbml: Northwind. Dbml/namespace: Linqcoding. Linqtosql