SQL Server Compact Edition 3.5
This is pretty slick. The Database file sizes are small (Northwind = about 2MB), the assemblies to add to an application are small. It supports replication and a lot of other features. No stored procs, but it supports Views and full relational integrity. You can deploy it in a regular MSI project by simply adding the seven dll's and your database file. Best of all, your System.Data.SqlCe namespace works exactly like the System.Data.SqlClient one. For example in a small Windows Forms test app: private void Form1_Load(object sender, EventArgs e) { string cnstr=@"Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf"; System.Data.SqlServerCe.SqlCeConnection cn = new SqlCeConnection(cnstr); SqlC...