E-Books
Building Standalone Data-Driven Applications using SQL Server Compact 4.0
  • Date Posted: September 07, 2011
  • Visits: 15152
  • Downloaded: 5700
  • Language: C#
  • Pages: 29
  • Platform: .NET 4.0
  • 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
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
Tags
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.