// https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-schema-collections?view=netframework-4.8

        public List <string> GetDatabases(SqlServerConnectorConfig connectionInfo)
        {
            using (SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = connectionInfo.ToConnectionString();
                sqlConnection.Open();
                var databasesNames = sqlConnection.GetSchema("Databases").Select().Select(s => s[0].ToString()).ToList();
                return(databasesNames);
            }
        }
Exemple #2
0
 public SqlServerConnector(SqlServerConnectorConfig config)
 {
     base.Config = config;
 }