CreateDatabase Method
Creates a new database.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Syntax
'Declaration
Public Sub CreateDatabase
'Usage
Dim instance As SqlCeEngine
instance.CreateDatabase()
public void CreateDatabase()
public:
void CreateDatabase()
member CreateDatabase : unit -> unit
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".
Examples
The following sample demonstrates how to create a new 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();