所以問題是我在將 SqlConnection 類傳遞給 ServerConnection 類時收到錯誤。錯誤說:
嚴重性代碼描述專案檔案行抑制狀態錯誤 CS1503 引數 1:無法從“System.Data.SqlClient.SqlConnection”轉換為“Microsoft.SqlServer.Management.Common.IRenewableToken”
但這里說它可以,并且在視覺作業室說它有這個過載,但它不會接受它并且不會構建專案。
我還應該提到,當我嘗試直接分配物件時,Visual Studio 變得無回應,其幀速率類似于 0.5/s。像這樣:
ServerConnection servConn = new ServerConnection(){SqlConnectionObject = conn};
這是整個代碼塊:
SaveFileDialog sfd = new SaveFileDialog();
string stringCon = @"DefaultConnection";
sfd.Filter = "Database backup files (*.bak)|*.bak";
sfd.Title = "Create Database Backup";
sfd.FileName = DateTime.Today.ToString("ddMMMyyyy") ".bak";
if (sfd.ShowDialog() == true)
{
SqlConnectionInfo conn = new SqlConnectionInfo(stringCon);
ServerConnection servConn = new ServerConnection();
SqlConnection.ClearAllPools();
conn.Open();
servConn.Connect();
try
{
Server serverdb = new Server(servConn);
Backup backupdb = new Backup() { Action = BackupActionType.Database, Database = "whdb" };
backupdb.Devices.AddDevice(sfd.FileName, DeviceType.File);
backupdb.Initialize = true;
backupdb.Incremental = false;
backupdb.SqlBackupAsync(serverdb);
conn.Close();
Storyboard sb = Resources["sbHideAnimation"] as Storyboard;
StatusLable.Content = @"??????? ???? ??.";
sb.Begin(StatusLable);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
uj5u.com熱心網友回復:
SqlClient 有兩組不同的類。
有兩個組成部分
System.Data.SqlClient
Microsoft.Data.SqlClient
所以你必須確保使用正確的 using 陳述句。
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/327285.html
下一篇:在開發程序中“模擬”一個類
