public static List <SqlColumnSchema> GetSqlColumnSchemas(this ISqlSchemaReader reader, string connectionString, SqlColumnSchema schemaRestriction)
{
using (var sqlConnection = new SqlConnection(connectionString).Then(c => c.Open()))
{
return(reader.GetSqlColumnSchemas(sqlConnection, schemaRestriction));
}
}
public void GetSqlColumnSchemas_TestingDb_ThreeColumns()
{
var columnSchemas = _sqlSchemaReader.GetSqlColumnSchemas(
connectionString: ConfigurationManager.ConnectionStrings["TestingDb"].ConnectionString,
schemaRestriction: new SqlColumnSchema
{
TableCatalog = "TestingDb",
TableSchema = "reusable_data_sqlclient"
});
Assert.AreEqual(3, columnSchemas.Count);
//var sqlTableSchema = columnSchemas.Single();
//Assert.AreEqual("SqlSchemaReaderTest", sqlTableSchema.TableName);
}
public static List <SqlColumnSchema> GetSqlColumnSchemas(this SqlConnection sqlConnection, SqlColumnSchema schemaRestriction)
{
return(SqlSchemaReader.GetSqlColumnSchemas(sqlConnection, schemaRestriction));
}