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));
}
}
public void GetSqlTableSchemas_TestingDb_OneTable()
{
var tableSchemas = _sqlSchemaReader.GetSqlTableSchemas(
connectionString: ConfigurationManager.ConnectionStrings["TestingDb"].ConnectionString,
schemaRestriction: new SqlTableSchema
{
TableCatalog = "TestingDb",
TableSchema = "reusable_data_sqlclient"
});
Assert.AreEqual(1, tableSchemas.Count);
var sqlTableSchema = tableSchemas.Single();
Assert.AreEqual("SqlSchemaReaderTest", sqlTableSchema.TableName);
}
public static List <SqlTableSchema> GetSqlTableSchemas(this SqlConnection sqlConnection, SqlTableSchema schemaRestriction)
{
return(SqlSchemaReader.GetSqlTableSchemas(sqlConnection, schemaRestriction));
}