SqlCeEngine Class
Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.
Represents the properties, methods, and other objects of the SQL Server CE Engine. This class cannot be inherited.
For a list of all members of this type, see SqlCeEngine Members.
System.Object
System.MarshalByRefObject
System.Data.SqlServerCe.SqlCeEngine
NotInheritable Public Class SqlCeEngine
Inherits MarshalByRefObject
Implements IDisposable
[C#]
public sealed class SqlCeEngine : MarshalByRefObject, IDisposable
[C++]
public __gc __sealed class SqlCeEngine : public MarshalByRefObject,
IDisposable
[JScript]
public class SqlCeEngine extends MarshalByRefObject implements
IDisposable
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Example
[Visual Basic, C#] The following sample demonstrates how to create a new SQL Server CE database.
If File.Exists("Test.sdf") Then
File.Delete("Test.sdf")
End If
Dim connStr As String = "Data Source = Test.sdf; Password = <password>"
Dim engine As New SqlCeEngine(connStr)
engine.CreateDatabase()
engine.Dispose()
Dim conn As SqlCeConnection = Nothing
Try
conn = New SqlCeConnection(connStr)
conn.Open()
Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "CREATE TABLE myTable (col1 int, col2 ntext)"
cmd.ExecuteNonQuery()
Catch
Finally
conn.Close()
End Try
[C#]
if (File.Exists("Test.sdf"))
File.Delete("Test.sdf");
string connStr = "Data Source = Test.sdf; Password = <password>";
SqlCeEngine engine = new SqlCeEngine(connStr);
engine.CreateDatabase();
engine.Dispose();
SqlCeConnection conn = null;
try {
conn = new SqlCeConnection(connStr);
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE myTable (col1 int, col2 ntext)";
cmd.ExecuteNonQuery();
}
catch {}
finally {
conn.Close();
}
[C++, JScript] No example is available for C++ or JScript. To view a Visual Basic or C# example, click the Language Filter button in the upper-left corner of the page.
Requirements
Namespace: System.Data.SqlServerCe
Platforms: .NET Compact Framework
Assembly: System.Data.Sqlserverce (in System.Data.Sqlserverce.dll)