.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.
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
Imports System.Data.SqlServerCe
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();


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
The .NET Compact Framework Data Provider for SQL Server Mobile class library can be used to connect to the following data sources:

SQL Server Compact
To see available connection options, navigate connection strings reference by the above data source links.
Additional info or comments on this class library? Want to submit content?

Popular

Copyright © 2013 30c.org   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.