.NET Compact Framework Data Provider for SQL Server Mobile
This .NET Framework Class Library is provided by Microsoft.
The class library is contained in the file system.data.sqlserverce.dll.
The class library is contained in the file system.data.sqlserverce.dll.
Coding
Add a reference to the assembly System.Data.SqlServerCe and include the System.Data.SqlServerCe namespace. Instantiate a new SqlCeConnection connection object. Set the connection string and open the connection.
VB.NET code sample
C# code sample
VB.NET code sample
Imports System.Data.SqlServerCe
Dim myConnection As SqlCeConnection = New SqlCeConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
Dim myConnection As SqlCeConnection = New SqlCeConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
C# code sample
using System.Data.SqlServerCe;
SqlCeConnection myConnection = new SqlCeConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
SqlCeConnection myConnection = new SqlCeConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
Description
The System.Data.SqlServerCe namespace is the .NET Compact Framework Data Provider for SQL Server Mobile. The .NET Compact Framework Data Provider for SQL Server Mobile is a collection of classes that is used in the managed development environment to provide smart devices access to SQL Server Mobile databases. With System.Data.SqlServerCe, you can create and manage SQL Server Mobile databases on a smart device and also establish connections to SQL Server databases.
More info about this class library can be found at the Microsoft product page.
Download link missing
The .NET Compact Framework Data Provider for SQL Server Mobile installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this class library? Want to submit content?