public void TestGetPrimaryKeyColumns()
{
SqlServerSchemaProvider provider = new SqlServerSchemaProvider();
provider.ConnectionString = connectionString;
var table = provider.GetPrimaryKeyColumns("examples", string.Empty, "tb_News");
}
private ISchemaProvider GetProvider()
{
var provider = new SqlServerSchemaProvider();
provider.SetConnectionString("Data Source=.;Initial Catalog=Northwind;Integrated Security=true;");
return(provider);
}
public void TestGetTable()
{
SqlServerSchemaProvider provider = new SqlServerSchemaProvider();
provider.ConnectionString = connectionString;
var table = provider.GetTable("examples", string.Empty, "tb_News");
Assert.AreEqual("Id", table.Columns[0].Name);
Assert.AreEqual(DbType.String, table.Columns[0].Type);
}
