public SqlConnectionString WithDatabase(string databaseName) { return new SqlConnectionString { Server = Server, Database = databaseName, IntegratedSecurity = IntegratedSecurity, UserName = UserName, Password = Password, Pooling = Pooling }; }
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; }