找不到 Microsoft.SqlServer.ConnectionInfo.dll 程序集文件？

发布于 2024-09-15 09:53:17 字数 642 浏览 2 评论 0原文

我正在尝试仅使用 C# 代码动态获取数据库表结构，如下所示：

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

public class LoadStuff
{
    ...
    public void LoadDatabase(string vDatabaseName)
    {
        using (var vSqlConnection = new SqlConnection(DatabaseConnectionString))
        {
            var vConnection = new ServerConnection(vSqlConnection);
            var vServer = new Server(vConnection);
            var vDatabase = vServer.Databases[vDatabaseName];
            var vTables = vDatabase.Tables;
        }
    }
}

但是，我也找不到 .dll 文件来添加引用。我使用的是 Visual Studio 2010 专业版。有什么建议吗？

原文

I'm trying to dynamically get a databases Table structure using only C# code as follows:

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

public class LoadStuff
{
    ...
    public void LoadDatabase(string vDatabaseName)
    {
        using (var vSqlConnection = new SqlConnection(DatabaseConnectionString))
        {
            var vConnection = new ServerConnection(vSqlConnection);
            var vServer = new Server(vConnection);
            var vDatabase = vServer.Databases[vDatabaseName];
            var vTables = vDatabase.Tables;
        }
    }
}

However, I cannot find the .dll file to add a reference too. I'm using Visual Studio 2010 Professional. Any suggestions?

分享到QQ

分享到微博