SqlCeEngine.Upgrade 方法 (String)
将 SQL Server Compact 数据库从版本 3.5 升级到 4.0。如果在目标连接字符串中指定了加密模式，则目标数据库将被加密。如果将连接字符串中的 case-sensitive 属性设置为 true，则数据库的排序规则为区分大小写。
命名空间： System.Data.SqlServerCe
程序集： System.Data.SqlServerCe（在 System.Data.SqlServerCe.dll 中）
语法
声明
Public Sub Upgrade ( _
destConnectionString As String _
)
用法
Dim instance As SqlCeEngine
Dim destConnectionString As String
instance.Upgrade(destConnectionString)
public void Upgrade(
string destConnectionString
)
public:
void Upgrade(
String^ destConnectionString
)
member Upgrade :
destConnectionString:string -> unit
public function Upgrade(
destConnectionString : String
)
参数
- destConnectionString
类型：System.String
到目标数据库的连接字符串。
示例
下面的示例说明如何将以前创建的 SQL Server Compact 数据库升级到区分大小写的 SQL Server Compact 数据库。
/// <summary>
/// Demonstrates how to upgrade a database with case sensitivity.
/// </summary>
public static void UpgradeDatabasewithCaseSensitive()
{
// <Snippet2>
// Default case-insentive connection string.
// Note that Northwind.sdf is an old 3.1 version database.
string connStringCI = "Data Source= Northwind.sdf; LCID= 1033";
// Set "Case Sensitive" to true to change the collation from CI to CS.
string connStringCS = "Data Source= Northwind.sdf; LCID= 1033; Case Sensitive=true";
SqlCeEngine engine = new SqlCeEngine(connStringCI);
// The collation of the database will be case sensitive because of
// the new connection string used by the Upgrade method.
engine.Upgrade(connStringCS);
SqlCeConnection conn = null;
conn = new SqlCeConnection(connStringCI);
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);
}
// </Snippet2>
}