SQL Server Compact 4.0 Programming Book is Ready

One more book free book is added to C# Corner E-books list. Last night, I finished book titled Building Standalone Data-Driven Applications using SQL Server Compact 4.0 and Visual Studio 2010.

Here is a list of book content. Book will be available for download tomorrow.

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