DAT284

DAT284
Originally uploaded by newellrichards

DAT284
SQL Server Compact Edition
Demo Sdf when you install it - Northwind
Copy local on the project for project dlls
Have to include the Native dlls
Create x86 folder
Include AMD64 folder
Copy dlls from Compact edition install
Now you have a one file db.

Can support multiple Connections but not designed for multi-user or networking

New features in 3.5
Updated encryption @ the data fle
Native 64 bit
Nested queries in from

Synchronisation
Encouraged to use sync services
Remote data access (boo!)
Merge Replication (db focussed)
Ado.Net Sync Services (developer focussed) works best with SQL Server 2008.

Sync Services
Do it all with Visual Studio
Has integration with Change tracking
Creates the classes and scripts
Sync designer
Synchronise tables in one transaction

SQLCEResultSet
Cursor to ce file whiCh Means the data isn't held in memory

McsF - encrypt the Config file?

Core technology for Software plus Services

No Java drivers