c# - 从 RESTORE LABELONLY 操作中检索值

Question

我想检索以下查询的结果值:

RESTORE LABELONLY FROM DISK = 'C:\folder\db-backup.bak';

在做了一些搜索之后我尝试了:

string connection = @"data source=.\SQLExpress;initial catalog=DB;persist security info=False;user id=sa;password=12356;MultipleActiveResultSets=True;App=EntityFramework";
ExecuteSQL(connection , @"RESTORE LABELONLY FROM DISK = 'C:\folder\db-backup.bak'");

而且，ExecuteSQL 是:

private void ExecuteSQL(string ConnString, string sqlText)
    {
        string result = "";
        using (SqlConnection sqlCon = new SqlConnection(ConnString))
        {
            sqlCon.Open();
            using (SqlCommand sqlCom = sqlCon.CreateCommand())
            {
                sqlCom.CommandType = CommandType.Text;
                sqlCom.CommandText = sqlText;
                sqlCom.CommandTimeout = 0;
                try
                {
                    string str = Convert.ToString(sqlCom.ExecuteScalar());
                }
                catch (Exception e)
                {
                    result = e.Message;
                }
            }
        }
    }

但是 .. str 总是空的!!

SQL Server Management Studio 中的查询结果为:

我想要的是如何检索 MediaSetID 字段？

Answer 1

MSDN说到 RESTORE LABELONLY 操作:

Result Sets

The result set from RESTORE LABELONLY consists of a single row with this information.

MediaName nvarchar(128) Name of the media.

...

所以你必须使用ExecuteReader方法并处理返回的 reader 中的列(或将其加载到 DataTable 并执行相同操作)。