public void ExecuteScalar()
{
var count = NorthwindAdoRepository.ExecuteScalarBySqlString("SELECT COUNT(*) FROM dbo.Orders").AsInt();
Assert.Greater(count, 0);
var filterCount
= NorthwindAdoRepository
.ExecuteScalarBySqlString("SELECT COUNT(*) FROM Orders where OrderDate < @OrderDate and Freight < @Freight",
new AdoParameter("OrderDate", DateTime.Today),
new AdoParameter("Freight", 2))
.AsInt();
Assert.Greater(filterCount, 0);
var orderId =
NorthwindAdoRepository
.ExecuteScalarBySqlString("SELECT TOP 1 ISNULL(OrderID, 0) FROM Orders ORDER BY ShippedDate")
.AsInt(0);
Assert.AreNotEqual(0, orderId);
orderId =
NorthwindAdoRepository
.ExecuteScalarBySqlString("SELECT TOP 1 ISNULL(OrderID, 0) FROM Orders Where ShipVia=0 ORDER BY ShippedDate")
.AsInt(0);
Assert.AreEqual(0, orderId);
}
public static int TotalRows()
{
var result = NorthwindAdoRepository.ExecuteScalarBySqlString(SQL_REGION_COUNT);
return(Convert.ToInt32(result));
}