Introduction
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.
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
Author Information
This free book is provided by courtesy of C# Corner and Mindcracker Network and its authors. Feel free to share this book with your friends and co-workers. Please do not reproduce, republish, edit or copy this book.
Contact C# Corner Authors Team at authors@c-sharpcorner.com.