public List<string> GetDatabases(SqlConnectionString connectionString)
{
var databases = new List<string>();
using (var conn = new SqlConnection(connectionString.WithDatabase("master")))
{
conn.Open();
var serverConnection = new ServerConnection(conn);
var server = new Server(serverConnection);
databases.AddRange(from Database database in server.Databases select database.Name);
}
return databases;
}
public List <string> GetDatabases(SqlConnectionString connectionString)
{
var databases = new List <string>();
using (var conn = new SqlConnection(connectionString.WithDatabase("master")))
{
conn.Open();
var serverConnection = new ServerConnection(conn);
var server = new Server(serverConnection);
databases.AddRange(from Database database in server.Databases select database.Name);
}
return(databases);
}
public List<DatabaseTable> GetTables(SqlConnectionString connectionString)
{
using (var conn = new SqlConnection(connectionString.WithDatabase("master")))
{
conn.Open();
var serverConnection = new ServerConnection(conn);
var server = new Server(serverConnection);
return
server
.Databases[connectionString.Database]
.Tables
.Cast<Table>()
.Select(t => new DatabaseTable
{
Name = t.Name,
RowCount = t.RowCount
})
.ToList();
}
}
public List <DatabaseTable> GetTables(SqlConnectionString connectionString)
{
using (var conn = new SqlConnection(connectionString.WithDatabase("master")))
{
conn.Open();
var serverConnection = new ServerConnection(conn);
var server = new Server(serverConnection);
return
(server
.Databases[connectionString.Database]
.Tables
.Cast <Table>()
.Select(t => new DatabaseTable
{
Name = t.Name,
RowCount = t.RowCount
})
.ToList());
}
}
