All geek questions in one place

SQL Server CE 3.5 SP1 Stored Procedures

I have been instructed to accept an existing WinForms application and modify it to work in "accidentally connected" mode. This was to be achieved using SQL Server CE 3.5 on a user laptop and synchronizing the server and client, either using SQL Server merge replication or using the Microsoft Sync Framework.

Currently, the application connects to our SQL Server and retrieves, inserts, updates data using stored procedures. I read that SQL Server CE does not support stored procedures.

Does this mean that all my stored procedures should be converted to direct SQL statements, both in my code and as a query inside a table?

If true, what are my alternatives?

+3
source share
5 answers

Since SQL Server CE is considered the “application data warehouse”, it is assumed that any complex logic that you can usually implement in the SQL Server stored procedure will be implemented in the application itself. Many traditional database concepts are not supported in SQL CE, such as restrictions covering indexes stored by procs, UDF ... you name it, SQLCE does not have this!

SQL CE , ; concurrency , , . SQL CE ; - SQLite MS Access.

:

  • , - (, ) "";

  • , "";

  • SQL Express, , SQL Server.

+3

, , - . , , , .

sql compact ( ), SqlCeResult Seek. , . http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceresultset(VS.80).aspx

0

- Linq . "" , , . , ( - ).

0

VistaDB. T-SQL Procs , SQL Server ( , SQL CE).

SO VistaDB .

0

, . DAL, . , SQL .

After generating the Script, it will return a query that can then pass SQL CE to retrieve the results.

0
source

Source: https://habr.com/ru/post/1733088/

More articles:


All Articles