E-Books
Building Standalone Data-Driven Applications using SQL Server Compact 4.0
  • Date Posted: September 07, 2011
  • Visits: 16774
  • Downloaded: 6056
  • Pages: 29
  • Book Type: PDF
  • Author: Mahesh Chand
Summary:

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.


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

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

MOST DOWNLOADED

SPONSORED BY

  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.