如何通过C#代码恢复SQL Server数据库

using System;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

namespace RestoreDatabase
{
    class Program
    {
        static void Main(string[] args)
        {
            // 设置数据库连接
            var serverConnection = new ServerConnection("localhost", "username", "password");
            var server = new Server(serverConnection);

            // 设置要恢复的数据库名称和备份文件路径
            var databaseName = "YourDatabaseName";
            var backupFilePath = @"C:\Path\To\Your\Backup\File.bak";

            // 恢复数据库
            try
            {
                var restore = new Restore();
                restore.Database = databaseName;
                restore.Action = RestoreActionType.Database;
                restore.Devices.AddDevice(backupFilePath, DeviceType.File);
                restore.ReplaceDatabase = true;
                restore.PercentCompleteNotification = 10;
                restore.Complete += Restore_Complete;
                restore.SqlRestore(server);
                Console.WriteLine("Database restored successfully.");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"Error restoring database: {ex.Message}");
            }
        }

        private static void Restore_Complete(object sender, PercentCompleteEventArgs e)
        {
            Console.WriteLine($"Restore progress: {e.Percent} %");
        }
    }
}