public List <SqlTableSchema> GetSqlTableSchemas(SqlConnection sqlConnection, SqlTableSchema schemaRestriction)
{
if (sqlConnection == null)
{
throw new ArgumentNullException(nameof(sqlConnection));
}
if (schemaRestriction == null)
{
throw new ArgumentNullException(nameof(schemaRestriction));
}
using (var schema = sqlConnection.GetSchema(SqlSchemaCollection.Tables, schemaRestriction))
{
return(schema.AsEnumerable().Select(SqlSchemaFactory.Create <SqlTableSchema>).ToList());
}
}
public static List <SqlTableSchema> GetSqlTableSchemas(this SqlConnection sqlConnection, SqlTableSchema schemaRestriction)
{
return(SqlSchemaReader.GetSqlTableSchemas(sqlConnection, schemaRestriction));
}
public static List <SqlTableSchema> GetSqlTableSchemas(this ISqlSchemaReader reader, string connectionString, SqlTableSchema schemaRestriction)
{
using (var sqlConnection = new SqlConnection(connectionString).Then(c => c.Open()))
{
return(reader.GetSqlTableSchemas(sqlConnection, schemaRestriction));
}
}