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
  • 9569 Downloaded
  • PDF
Download This E-Book Now
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.

comments

Comment Using

techbash 2016

MOST DOWNLOADED

SPONSORED BY

File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!
techbash 2016