C# (CSharp) NorthwindAdoRepository.CountBySqlString Examples

Example #1

File: AdoRepositoryFixture.cs Project: 15831944/NFramework

        public void CountOfDataReader()
        {
            Assert.AreEqual(5, NorthwindAdoRepository.CountBySqlString("SELECT TOP 5 * FROM [Order Details]"));

            Assert.AreEqual(1, NorthwindAdoRepository.CountBySqlString("SELECT TOP 1 * FROM Customers"));

            Assert.AreEqual(0, NorthwindAdoRepository.CountBySqlString("SELECT TOP 0 * FROM Customers"));

            var count = NorthwindAdoRepository.CountByProcedure(GetCustomerOrderHistorySql, CustomerTestParameter);

            Assert.IsTrue(count > 0);
        }