Building Standalone Data-Driven Applications using SQL Server Compact 4.0

By Mahesh Chand on Sep 07, 2011
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.
  • 29 Pages
  • 8245 Downloaded
  • PDF
Download This E-Book Now
Intoduction:

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.


COMMENT USING

Download Free eBooks

MOST DOWNLOADED

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.