How to migrate a c# SQL Server project to SQL Server Compact Edition?

Y

Yuri Denisov2014-05-31 08:44:10

C++ / C#

Yuri Denisov, 2014-05-31 08:44:10

Actually the question is in the title. Is it possible to automate this somehow or redo everything from scratch?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sumor, 2014-05-31
@denissov

The main problem is type compatibility and the use of stored procedures.
SQL Compact Edition only supports tables and does not support procedures, functions, or triggers. The full list of differences is presented in tables from Microsoft.
In the code, it is enough to change System.Data.SqlClient to System.Data.SqlServerCe.
Classes from Sql* to SqlCe*, for example, SqlConnection to SqlCeConnection.
System.Data.SqlServerCe must be additionally included in the project in references.