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