SQL Server Compact 3.5 includes a host of new features including the following:
- LINQ to SQL enabling developers to integrate data access directly into their code
- Side-by-side installation together with SQL Server 2005 Compact Edition (version 3.1)
- Support for newer and more secure encryption algorithms
- Additional timestamp (rowversion) data type
- Enhanced support for Transact-SQL statements including:
- Nested query in FROM clause
- CROSS APPLY and OUTER APPLY
- CAST and DECIMAL
- SET IDENTITY INSERT
- TOP
- Synchronization Services for ADO.NET providing the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures
- Support for System.Transactions
|