title: Can't find Microsoft.SqlServer.ConnectionInfo.dll assembly file?
body: <p>I'm trying to dynamically get a databases Table structure using only C# code as follows:</p>
  
  <pre><code>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;
          }
      }
  }
  </code></pre>
  
  <p>However, I cannot find the .dll file to add a reference too. I'm using Visual Studio 2010 Professional. Any suggestions?</p>