public void QueryWithMapper()
{
IDbProvider dbProvider = DbProviderFactory.GetDbProvider("SybaseAse-15");
dbProvider.ConnectionString = "Data Source='MARKT60';Port='5000';UID='sa';PWD='';Database='pubs2';";
PubDao pubDao = new PubDao(dbProvider);
IList <Sale> sales = pubDao.GetSales("5023");
Assert.AreEqual(50, sales.Count);
}
public void QueryWithMapperODBC()
{
IDbProvider dbProvider = DbProviderFactory.GetDbProvider("Odbc-2.0");
dbProvider.ConnectionString =
"Driver={Adaptive Server Enterprise};server=MARKT60;port=5000;Database=pubs2;uid=sa;pwd=;";
PubDao pubDao = new PubDao(dbProvider);
IList <Sale> sales = pubDao.GetSales("5023");
Assert.AreEqual(50, sales.Count);
}
public void QueryWithMapperODBC()
{
IDbProvider dbProvider = DbProviderFactory.GetDbProvider("Odbc-2.0");
dbProvider.ConnectionString =
"Driver={Adaptive Server Enterprise};server=MARKT60;port=5000;Database=pubs2;uid=sa;pwd=;";
PubDao pubDao = new PubDao(dbProvider);
IList<Sale> sales = pubDao.GetSales("5023");
Assert.AreEqual(50, sales.Count);
}
public void QueryWithMapper()
{
IDbProvider dbProvider = DbProviderFactory.GetDbProvider("SybaseAse-15");
dbProvider.ConnectionString = "Data Source='MARKT60';Port='5000';UID='sa';PWD='';Database='pubs2';";
PubDao pubDao = new PubDao(dbProvider);
IList<Sale> sales = pubDao.GetSales("5023");
Assert.AreEqual(50, sales.Count);
}