通过

如何使用 Engine 对象创建数据库（以编程方式）

  • 项目

本主题将介绍如何以编程方式使用 SqlServerCe.Engine 对象的 CreateDatabase 方法创建 SQL Server Compact 数据库。有关使用 SqlServerCe 命名空间的详细信息，请参阅 SqlServerCe 命名空间参考文档。

SQL Server Compact 4.0 的过程

使用 Engine 对象创建数据库

  1. 初始化新的 Engine 对象。

    SqlCeEngine engine = new SqlCeEngine();

  2. 设置 Engine 对象的 LocalConnectionString 属性。LocalConnectionString 属性指定将要创建的数据库的名称和位置，还可能会指定其他数据库选项，包括加密。

    eng.LocalConnectionString= "Data Source='Test.sdf'; LCID=1033;" +
   "Password='<enterStrongPasswordHere>';";

  3. 调用 CreateDatabase 方法创建数据库。

    engine.CreateDatabase();

使用 Engine 对象创建区分大小写的数据库

  1. 初始化新的 Engine 对象。

    SqlCeEngine engine = new SqlCeEngine();

  2. 设置 Engine 对象的 LocalConnectionString 属性。LocalConnectionString 属性指定将创建的数据库的名称和位置，并可能指定其他数据库选项，包括区分大小写。

    eng.LocalConnectionString= "Data Source='Test.sdf'; LCID=1033;" +
   "Password='<enterStrongPasswordHere>'; Case Sensitive = TRUE;";

  3. 调用 CreateDatabase 方法创建数据库。

    engine.CreateDatabase();

示例

第一个示例创建一个名为 Test.sdf 的新数据库。

System.IO.File.Delete("Test.sdf");
string connString = "Data Source = 'Test.sdf'; LCID=1033; Password = <enterStrongPasswordHere>;";
SqlCeEngine engine = new SqlCeEngine(connString);
engine.CreateDatabase();

System.IO.File.Delete("Test.sdf")
Dim connString As String = "Data Source='Test.sdf'; LCID=1033; Password=<enterStrongPasswordHere>; Encrypt = TRUE;"
Dim engine As New SqlCeEngine(connString)
engine.CreateDatabase()

第二个示例使用 LocalConnectionString 属性（它支持名为“Case Sensitive”或“CaseSensitive”的其他 Boolean 属性）。此属性可以具有 true 或 false 值。其默认值始终是 false。从 SQL Server Compact 3.5 SP1 版本开始引入了此属性。有关详细信息，请参阅使用排序规则 (SQL Server Compact)。

该示例演示如何使用 LocalConnectionString 属性在连接字符串中设置区分大小写的属性。然后，代码示例使用 GetDatabaseInfo 方法检索数据库的区域设置、加密模式和区分大小写设置：

// First approach: 
// Create a case-sensitive database by using the SqlCeEngine 
// constructor.
if (File.Exists("Test.sdf"))
    File.Delete("Test.sdf");

// 1033: specifies the English locale with collation 
// SQL_Latin1_General_CP1_CI_AS
string connStr = 
   "Data Source='Test.sdf'; LCID=1033; Case Sensitive = TRUE";

SqlCeEngine engine = new SqlCeEngine(connStr);
engine.CreateDatabase();
engine.Dispose();

// Second approach: 
// Create a case-sensitive database by using the LocalConnectionString 
// property.
if (File.Exists("Test.sdf"))
   File.Delete("Test.sdf");

SqlCeEngine engine2 = new SqlCeEngine();

engine2.LocalConnectionString = 
   "Data Source='Test.sdf'; LCID=1033; Case Sensitive = TRUE";
// 1033: specifies the English locale with collation 
// SQL_Latin1_General_CP1_CI_AS
engine2.CreateDatabase();
engine2.Dispose();

SqlCeConnection conn = null;

try
{
   conn = new SqlCeConnection(connStr);
   conn.Open();

   //Retrieve the connection string information - 
   // notice the 'Case Sensitive' value
   List<KeyValuePair<string, string>> dbinfo = conn.GetDatabaseInfo();

   Console.WriteLine("\nGetDatabaseInfo() results:");

   foreach (KeyValuePair<string, string> kvp in dbinfo)
   {
      Console.WriteLine(kvp);
   }
   }
   catch (Exception ex)
   {
      Console.WriteLine(ex.Message);
   }
   finally
   {
      conn.Close();
      Console.WriteLine("\n\n\nPress any key to continue...");
      Console.Read();
   }

' First approach: 
' Create a case sensitive database by using the SqlCeEngine 
' constructor.
If File.Exists("Test.sdf") Then
    File.Delete("Test.sdf")
End If

' 1033: specifies the English locale with collation 
' SQL_Latin1_General_CP1_CI_AS
Dim connStr As String = "Data Source='Test.sdf'; LCID=1033; Case Sensitive = TRUE"

Dim engine As New SqlCeEngine(connStr)
engine.CreateDatabase()
engine.Dispose()

' Second approach: 
' Create a case-sensitive database by using the LocalConnectionString 
' property.
If File.Exists("Test.sdf") Then
    File.Delete("Test.sdf")
End If

Dim engine2 As New SqlCeEngine
engine2.LocalConnectionString = _
    "Data Source='Test.sdf'; LCID=1033; Case Sensitive = TRUE"
    ' 1033: specifies the English locale with collation 
    ' SQL_Latin1_General_CP1_CI_AS
engine2.CreateDatabase()
engine2.Dispose()

Dim conn As SqlCeConnection = Nothing

Try
    conn = New SqlCeConnection(connStr)
    conn.Open()

    'Retrieve the connection string information - 
    ' notice the 'Case Sensitive' value
    Dim dbinfo As List(Of KeyValuePair(Of String, String)) = conn.GetDatabaseInfo

    Console.WriteLine(ChrW(10) & "GetDatabaseInfo() results:")

    Dim kvp As KeyValuePair(Of String, String)

    For Each kvp In dbinfo
        Console.WriteLine(kvp)
    Next
Catch ex As Exception
    Console.WriteLine(ex.Message)
Finally
    conn.Close()
    Console.WriteLine(vbNewLine & vbNewLine & vbNewLine & "Press any key to continue...")
    Console.Read()
End Try

请参阅

概念

数据库引擎概述 (SQL Server Compact)