public void TestExecWithResultFromSql()
{
const string sql = "SELECT CustomerId FROM dbo.Customer WHERE CustomerId=1";
var result = _db.ExecWithResult(sql);
Assert.IsNotNull(result);
Assert.IsFalse(string.IsNullOrEmpty(result));
}
public void TestExecWithResultFromSql()
{
const string sql = "SELECT \"CustomerId\" FROM \"Customer\" WHERE \"CustomerId\"=8;";
var result = _db.ExecWithResult(sql);
Assert.IsNotNull(result);
Assert.IsFalse(string.IsNullOrEmpty(result));
}
/// <summary>
/// Count all rows in table Customer
/// </summary>
public int Count()
{
var result = _db.ExecWithResult("SELECT COUNT(*) FROM \"Customer\"");
return(Convert.ToInt32(result));
}