This documentation is archived and is not being maintained.

Data Access Overview (Managed Device Projects) 

This topic has been updated for Visual Studio 2005 SP1.

The Visual Studio environment for developing device projects that manipulate data is similar to the environment for developing desktop data applications. Managed data applications for devices rely on ADO.NET namespaces supported by the .NET Compact Framework. This combination lends itself to applications where the data store on the device is typically disconnected from data on a server, and is only periodically synchronized.

Data for Devices: What's New in Visual Studio 2005

The following section has been updated for Visual Studio 2005 SP1.

  • You can create SQL Server Mobile or Microsoft SQL Server 2005 Compact Edition databases, assign passwords, alter schemas, and perform other fundamental database management tasks using the Visual Studio IDE.

  • You can use Typed Datasets, ResultSets, business objects, SQL Server databases, SQL Mobile databases, SQL Server Compact Edition databases, or Web services as data sources. 

  • You can drag and drop these data sources from the Data Sources window onto a Windows Form to generate data-bound controls of your choice.

    NoteNote

    The Data Source Configuration Wizard is not available for projects that target version 1.0 of the .NET Compact Framework.

SQL Server Mobile Edition and SQL Server Compact Edition Architectures

The following section has been updated for Visual Studio 2005 SP1.

The installed database varies according to which release of Visual Studio you have installed:

  • Microsoft SQL Server Mobile Edition (Visual Studio 2005)

  • Microsoft SQL Server 2005 Compact Edition (Visual Studio 2005 SP1)

SQL Server Mobile and SQL Server Compact Edition represent the best local data engine for devices that are only occasionally connected. You can program using the .NET Compact Framework for managed applications or Microsoft Visual C++ for Devices for native applications. For more information, see SQL Server Mobile Architecture.

Typical Uses of SQL Server Mobile Edition and SQL Server Compact Edition

The following section has been updated for Visual Studio 2005 SP1.

SQL Server Mobile and SQL Server Compact Edition offer a solution for occasionally connected data access scenarios on mobile devices. Mobile enterprise scenarios are frequently required to work with data when connectivity is not available. SQL Server Mobile and SQL Server Compact Edition address these scenarios by providing rich relational stores that can be synchronized to SQL Server when a connection is available. For more information, see Typical Uses of SQL Server Mobile.

NoteNote

You can use SQL Server Mobile and SQL Server Compact Edition as data stores for Tablet PC applications as well as for device applications. You can also run them on laptops and desktops provided either Visual Studio 2005 or SQL Server 2005 is installed. For more information, see Building a SQL Server Mobile Application for Tablet PCs.

Features of SQL Server Mobile and SQL Server Compact Edition

The following section has been updated for Visual Studio 2005 SP1.

SQL Server Mobile and SQL Server Compact Edition provide a wealth of features, either as part of a .NET Compact Framework application or as an independent installation on a smart device. Data can be manipulated offline and synchronized later to a server. For more information, see SQL Server Mobile Features.

Designing and Managing SQL Server Databases

To develop effective data applications for devices, you need an understanding of good database design and of the SQL Server database engine. You should master how to maintain databases, how to make them secure, how to access and modify the data in them, how to efficiently query them, and how to maximize their performance. For more information, see Working with Databases (SQL Server Mobile) and Enhancing Performance.

Connections With a Server

The following section has been updated for Visual Studio 2005 SP1.

SQL Server Mobile and SQL Server Compact Edition support merge replication, Remote Data Access, and security planning and implementation at the server. For more information, see Managing Connectivity (SQL Server Mobile).

Implementing Common Tasks Programmatically

For steps to implement common tasks programmatically, see How To (SQL Server Mobile).

Local security

The SQL Server Mobile and SQL Server Compact Edition Database engines provide password protection and encryption for securing local databases on devices. They also provide connectivity security options. For more information, see Securing Databases (SQL Server Mobile).

See Also

Show: