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)); }