public void TestGetDataTableFromCommandWithGetCommand()
{
const string sql = "SELECT * FROM \"Customer\"";
var cmd = _db.GetCommand();
cmd.CommandText = sql;
// Add parameters here if required
var erg = _db.GetDataTable(cmd);
Assert.IsTrue(erg.Rows.Count > 0);
}
public void TestGetDataTableFromCommandWidthGetCommandWithParameter()
{
const string sql = "SELECT * FROM dbo.Customer WHERE CustomerId=@ID";
var cmd = _db.GetCommand();
cmd.CommandText = sql;
var p = _db.GetParameter(cmd, "@ID", GeneralDbType.Int);
p.Value = 1;
// Add parameters here if required
var erg = _db.GetDataTable(cmd);
Assert.IsTrue(erg.Rows.Count > 0);
Assert.IsTrue(erg.Rows.Count == 1);
}