SQL Server Compact is free for both use and distribution. It is suitable for mobile devices, desktops, and web applications. It provides transactional support, referential integrity, merge replication, and ADO.NET and LINQ support, and integrates with Visual Studio and WebMatrix.