SqlCeEngine.CreateDatabase Method

Article
10/22/2009

Creates a new database.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Sub CreateDatabase

public void CreateDatabase ()

public:
void CreateDatabase ()

public void CreateDatabase ()

public function CreateDatabase ()

Remarks

System.Data.SqlServerCe.SqlCeEngine.CreateDatabase throws an exception when Encrypt mode or PPC2003Compat is used instead of Encryption Mode or PPC2003Compatibility to specify the encryption mode of the database. The error messages are "Unknown connection option in connection string: encrypt mode" or "Unknown connection option in connection string: PPC2003Compat".

Example

The following sample demonstrates how to create a new SQL Server Compact 3.5 SP1 database.

File.Delete("Test.sdf")

Dim connString As String = "Data Source='Test.sdf'; LCID=1033; Password=""s$;2'!dS64""; Encrypt = TRUE;"
Dim engine As New SqlCeEngine(connString)
engine.CreateDatabase()

File.Delete("Test.sdf");

string connString = "Data Source='Test.sdf'; LCID=1033; Password=\"s$;2'!dS64\"; Encrypt = TRUE;";
SqlCeEngine engine = new SqlCeEngine(connString);
engine.CreateDatabase();

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0