Skip to main content

SQL Server Compact 3.5 How-to Tutorials

Follow along with these self-paced tutorials to learn how to rapidly develop applications with SQL Server Compact 3.5 using familiar programming models and management interface.  These tutorials include step-by-step instructions and exercise scripts for performing tasks related to SQL Server Compact 3.5.


 

Tutorial 1: Application Deployment with Shared & Private Deployment

Tutorial 1: Application Deployment with Shared & Private Deployment

Learn about two different scenarios available for deploying SQL Server Compact 3.5 with your applications.  Use Visual C# .NET or Visual Basic .NET to perform this tutorial.  Includes exercise and solution scripts.

Visual C# .NET
View     Download
Visual Basic .NET
View     Download

 


Tutorial 2: Rapid Application Development Using SQL Server 2005 Compact Edition

Tutorial 2: Rapid Application Development Using SQL Server Compact 3.5

In this tutorial, you will learn how to leverage the design capabilities integrated into Visual Studio 2008 in order to rapidly develop applications that use data stored in a SQL Server Compact 3.5 database. Use Visual C# .NET or Visual Basic .NET to perform this tutorial.  Includes exercise and solution scripts.

Visual C# .NET
View     Download
Visual Basic .NET
View     Download

 


Tutorial 3: SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet

Tutorial 3: SQL Server Compact 3.5 Data Access with the SqlCeResultSet

Learn how to leverage the design capabilities integrated into Visual Studio 2008 in order to rapidly develop applications that use data stored in a SQL Server Compact 3.5 database.  Use Visual C# .NET or Visual Basic .NET to perform this tutorial.  Includes exercise and solution scripts.

Visual C# .NET
View     Download
Visual Basic .NET
View     Download

 


Tutorial 4: Remote Data Access Synchronization with SQL Server 2005 Compact Edition

Tutorial 4: Remote Data Access Synchronization with SQL Server Compact

In this tutorial, you will learn how to create a Windows Forms application that synchronizes data between a SQL Server 2005 database and a SQL Server Compact 3.5 database using SQL Server Compact 3.5 Remote Data Access (RDA).  Use Visual C# .NET or Visual Basic .NET to perform this tutorial.  Includes exercise and solution scripts.

Visual C# .NET
View     Download
Visual Basic .NET
View     Download

 


Tutorial 5: SQL Server 2005 Compact Edition Remote Data Access and Merge Replication

Tutorial 5: SQL Server Compact 3.5 Remote Data Access and Merge Replication

This tutorial covers everything that you need to do to configure a server for data synchronization using Remote Data Access.  Learn how to configure Internet Information Services (IIS) for both remote data access (RDA) and merge replication, two technologies that you can use to synchronize data between a Microsoft® SQL Server™ 2005 backend database and a local Microsoft® SQL Server™ Compact 3.5 database.

View     Download