Building Standalone Data-Driven Applications using SQL Server Compact 4.0

Mahesh Chand

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.

  • Published on Sep 07 2011
  • Pages 29
  • Downloaded 10.5k
  • Type PDF
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 [email protected].