Using SQL Server Express instead of Compact Edition as a local database cache?

Question

By default, when you create a local database cache using the wizard provided by Visual Studio 2008, it will create a SQL Server Compact Edition database for you and provide you with synchronization capabilities between the cache and the remote SQL Server using Sync Framework (1.0). This allows us to provide autonomous capabilities in our client server.

My question is: instead of using the SQL Server Compact edition, can I use the version of SQL Server Express so we can use stored procedures? All customers are promising laptops running on Core 2 Duo, so computing power is not a problem. However, for our user, an autonomous function is the most valuable.

Plus, we’ll need a reissue to convert all stored procedure code to mid-level C # using LINQ. Finally, and most importantly, our boss wants the business logic to be in stored procedures. SQL Server CE just won't cut it.

Answer 1

Is it possible to use SQL Server EXPRESS so that we can use the stored procedure?

Yes.

You can simplify installation and deployment with Click Once.

If necessary, you can limit the amount of memory used by SQL Express by issuing the appropriate configuration commands.

, SQL Express , , .

P.S. SP, LINQ. ADO.NET , , , , .., LINQ.

Answer 2

, . SQL Server Express .

, , , SQL Server RAM (200 - 500 ), , . , , -, , .

SQL Server Express. SQL Server Express , , , .

Answer 3

, Sync Framework 1.0 SQL Server Express . Sync Framework 2.0 Express .

Sync Framework 1.0 -

2 , : SqlCeClientSyncProvider DbServerSyncProvider. ( --) - , SQL Server Compact Edition, SQL Server , ADO.net.

Sync Framework 2.0 -

3 , SqlSyncProvider, SqlCeSyncProvider, DbSyncProvider. Collaboration , ADO.net .

Answer 4

. , . Sync Framework, , SQL Server .. .

, , ():

№ 13 , SQL Compact , SF 1.0. , ASP.NET SF 1.0, Mary SQL Compact ASP.NET( ). SQL CE v4?

"SQL Server Compact ASP.NET".

:

http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/b8763568-c7b0-4e4a-bdf3-14969a0f67a0/

№ 3 SF 1.0 SQL Server 2008 SQL Server Express 2008. , , Express.

, : , /?

, #, , : SF 1.0 SQL Express 2008, , . . . , , . . , SQL Express, Sync Framework 2.0. . , , Sync Framework 2.0 ( , RFC - ). ( , , -/IIS), Sync Framework . ?

. FAQ, , , , 2.0; -)

,

Zyxy

Answer 5

LocalDataCache SQLCE, . SQL2008 Express SQLServer, , , , SQLCE VS2008.