public void OrdersExtract()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.ServerName = "NEON-64";
storage.DatabaseName = "Northwind";
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
OrdersVerticalBar[] res = null;
try
{
res = storage.ExtractRecords() as OrdersVerticalBar[];
}
catch(SqlException ex)
{
if (ex.Number == 208)
Assert.Ignore("You dont have this tables in your SqlServer");
if (ex.Number == 6)
Assert.Ignore("SqlServer not found, skipping this test.");
Assert.Ignore(ex.ToString());
}
Assert.AreEqual(830, res.Length);
Assert.AreEqual("VINET", res[0].CustomerID);
Assert.AreEqual("TOMSP", res[1].CustomerID);
Assert.AreEqual("HANAR", res[2].CustomerID);
}
public void OrdersExtractBad5()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar), "WhereIsThisServer", "Northwind");
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
storage.ExtractRecords();
}
public void OrdersExtractBad4()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar), "NEON-64", "SureThatThisDontExist");
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
storage.ExtractRecords();
}
public void OrdersExtractBad3()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar), "NEON-64", "Northwind");
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
try
{
storage.ExtractRecords();
}
catch(SqlException ex)
{
if (ex.Number == 208)
Assert.Ignore("You dont have this tables in your SqlServer");
if (ex.Number == 6)
Assert.Ignore("SqlServer not found, skipping this test.");
Assert.Ignore(ex.ToString());
}
}
public void OrdersExtractBad2()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar));
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
storage.ExtractRecords();
}
public void OrdersExtractBad1()
{
SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar), "NEON-64", "Northwind");
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
storage.ExtractRecords();
}
public void OrdersExtractBad5()
{
var storage = new SqlServerStorage(typeof (OrdersVerticalBar), "WhereIsThisServer", "Northwind");
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
Assert.Throws<SqlException>(()
=> storage.ExtractRecords());
}
public void OrdersExtractBad4()
{
var storage = new SqlServerStorage(typeof (OrdersVerticalBar), "NEON-64", "SureThatThisDontExist");
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
Assert.Throws<SqlException>(()
=> storage.ExtractRecords());
}
public void OrdersExtractBad2()
{
var storage = new SqlServerStorage(typeof (OrdersVerticalBar));
storage.SelectSql = "SELECT TOP 100 * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
Assert.Throws<BadUsageException>(()
=> storage.ExtractRecords());
}
public void OrdersExtractBad1()
{
var storage = new SqlServerStorage(typeof (OrdersVerticalBar), "NEON-64", "Northwind");
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder);
Assert.Throws<BadUsageException>(()
=> storage.ExtractRecords());
}
