diTii.com | D' Technology Weblog

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
• Microsoft SQL Server Compact 3.5 for Windows Mobile
• Microsoft SQL Server Compact 3.5 Books Online and Samples

SQL Server, ADO.NET, Windows, Desktop, Microsoft