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);
}
public void TestGetDataReaderFromCommandWidthGetCommandAndParameter()
{
const string sql = "SELECT * FROM \"Customer\" WHERE \"CustomerId\"=@ID;";
var cmd = _db.GetCommand();
cmd.CommandText = sql;
var p = _db.GetParameter(cmd, "@ID", GeneralDbType.Int);
p.Value = 8;
// Add parameters here if required
var erg = _db.GetDataReader(cmd);
Assert.IsTrue(erg.FieldCount > 0);
Assert.IsTrue(erg.HasRows);
}