Blog
Free Book Building Standalone Data-Driven Applications using SQL Server Compact 4.0 is Available Now
My free book on SQL Server Compact 4.0 Programming is available now. Microsoft SQL Server Compact 4.0 (SQL Compact onwards) is a free SQL Server embedded database ideal for building standalone desktop, web, and mobile applications that need local data storage.
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