Connection Strings for SQL Server Compact Edition

using System.Data.SqlServerCe;
SqlCeConnection myConnection = new SqlCeConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries
myConnection.Close();

Data Source=urData.sdf;Persist Security Info=False;

Data Source=urData.sdf;Encrypt Database=True;Password=urPassword;File Mode=shared read;

Persist Security Info=False;

Data Source=urData.sdf;File Mode=Shared Read;Persist Security Info=False;

Data Source=urData.sdf;File Mode=Exclusive;Persist Security Info=False;

Data Source=urData.sdf;File Mode=Read Only;Persist Security Info=False;

Data Source=urData.sdf;Temp File Max Size=345;Persist Security Info=False;

Data Source=" +(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAsse

mbly().GetName().CodeBase) + "\\urData.sdf;Persist Security Info=False;

Specification of Maximum Database Size

Data Source=uyData.sdf;Max Database Size=345;Persist Security Info=False;

Specification of Maximum Buffer Size

Data Source=urData.sdf;Max Buffer Size=1024;Persist Security Info=False;

.NET Framework Data Provider for OLE DB

.NET Framework data provider connects to a database, executes commands, and retrieves results. Those results are either processed directly, placed in a Dataset to be exposed to the user as needed, combined with data from multiple sources, or remoted between tiers. .NET Framework data providers are lightweight, creating a minimal layer between the data source and code, increasing performance without sacrificing functionality.

Sample Code

using System.Data.OleDb;
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries
myConnection.Close();

Bridging to Microsoft.SQLSERVER.CE.OLEDB.3.5

Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=urPath\urData.sdf;

Microsoft.SQLSERVER.CE.OLEDB.3.5

Standard Security

Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=urPath\urData.sdf;

Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

Standard Security

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;

Encryption Enabled

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Encrypt Database=True;

Supplying the database password

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Database Password='urPassword';

Specification of Maximum Temp file Size

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Temp File Max Size=345;

Specification of the location of the Temp File<

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Temp File Directory="\urTempDir\";

Specification of the location of the SDF File

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source="+(System.IO.Path.

GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\urData.sdf;

Specification of Maximum Database Size

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Max Database Size=345;

Specification of Maximum Buffer Size

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=urPath\urData.sdf;SSCE:Max Buffer Size=1024;

Conclusion

This article taught us about Connection Strings for SQL Server Compact Edition.