My free book on SQL Server Compact 4.0 Programming is available now. Microsoft SQL Server Compact 4.0 is a free SQL Server embedded database ideal for building standalone desktop, web, and mobile applications that need local data storage.

This book covers the following topics:
  • Need of a Compact Database
  • SQL Server Compact 4. Features
  • Installing SQL Server Compact 4.0
  • SQL Server Compact Toolbox
  • SQL Server Compact Toolbox UI
  • Create a Database
  • Create a Table
  • Add Data
  • Execute Queries
  • Programming SQL Server Compact 4.0
  • ADO.NET Data Provider for SQL Server Compact 4.0
  • Establishing a Connection
  • Fetching and Displaying Data
  • Add, Update, and Delete Data
  • Using ADO.NET Entity Framework Model
Download Book Here