public void DataReaderGetByName() { using (var dr = NorthwindAdoRepository.ExecuteReaderBySqlString("SELECT * FROM Employees")) { while (dr.Read()) { Assert.IsNotEmpty(DataReaderTool.AsString(dr, "Title")); Assert.IsNotNull(DataReaderTool.AsDateTimeNullable(dr, "BirthDate")); } } }
public void DataReaderGetByIndex() { using (var dr = NorthwindAdoRepository.ExecuteReaderBySqlString("SELECT * FROM [Order Details]")) { while (dr.Read()) { var orderId = DataReaderTool.AsInt32(dr, 0, () => 10000); Assert.AreNotEqual(10000, orderId); var productId = DataReaderTool.AsInt32(dr, 1); Assert.AreNotEqual(0, productId); var unitPrice = DataReaderTool.AsDecimal(dr, 2); Assert.AreNotEqual(0M, unitPrice); } } }
public void CanGetNullableFromProducts() { using (var dr = NorthwindAdoRepository.ExecuteReaderBySqlString("SELECT * FROM Products")) { while (dr.Read()) { var unitPrice = DataReaderTool.AsDecimalNullable(dr, "UnitPrice"); Assert.IsTrue(unitPrice.HasValue); //Console.WriteLine("UnitPrice = " + unitPrice); Assert.Greater(unitPrice.Value, 0m); var reorderLevel = DataReaderTool.AsInt16Nullable(dr, "ReorderLevel"); Assert.IsTrue(reorderLevel.HasValue); Assert.GreaterOrEqual(reorderLevel.Value, 0); } } }
public void CanGetNullableFromOrderDetails() { using (var dr = NorthwindAdoRepository.ExecuteReaderBySqlString("SELECT * FROM [Order Details]")) { while (dr.Read()) { var orderId = DataReaderTool.AsInt32Nullable(dr, 0); Assert.IsTrue(orderId.HasValue); Assert.AreEqual(orderId, dr.GetInt32(0)); var productId = DataReaderTool.AsInt32Nullable(dr, 1); Assert.IsTrue(productId.HasValue); Assert.AreEqual(productId, dr.GetInt32(1)); var unitPrice = DataReaderTool.AsDecimalNullable(dr, 2); Assert.IsTrue(unitPrice.HasValue); Assert.AreEqual(unitPrice, dr.GetDecimal(2)); var discount = DataReaderTool.AsFloatNullable(dr, "Discount"); Assert.IsNotNull(discount); } } }