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
o SQL Server Compact Toolbox UI
o Create a Database
o Create a Table
o Add Data
o Execute Queries
· Programming SQL Server Compact 4.0
o ADO.NET Data Provider for SQL Server Compact 4.0
o Establishing a Connection
o Fetching and Displaying Data
o Add, Update, and Delete Data
· Using ADO.NET Entity Framework Model