iframe-proxy | Sunbelt Computer Software

69 lines (64 loc) · 2.13 KB

﻿using System.IO;
using System.Reflection;
using NUnit.Framework;
namespace Simple.Data.SqlCe40Test
    [TestFixture]
    public class QueryTest
        private static readonly string DatabasePath = Path.Combine(
            Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase.Substring(8)),
            "TestDatabase.sdf");
        [Test]
        public void ShouldSelectFromOneToTen()
            var db = Database.Opener.OpenFile(DatabasePath);
            var query = db.PagingTest.QueryById(1.to(100)).Take(10);
            int index = 1;
            foreach (var row in query)
                Assert.AreEqual(index, row.Id);
                index++;
        [Test]
        public void ShouldSelectFromOneToTenWithCount()
            var db = Database.Opener.OpenFile(DatabasePath);
            Promise<int> count;
            var query = db.PagingTest.QueryById(1.to(100)).WithTotalCount(out count).Take(10);
            int index = 1;
            foreach (var row in query)
                Assert.AreEqual(index, row.Id);
                index++;
            Assert.IsTrue(count.HasValue);
            Assert.AreEqual(100, count.Value);
        [Test]
        public void ShouldSelectFromElevenToTwenty()
            var db = Database.Opener.OpenFile(DatabasePath);
            var query = db.PagingTest.QueryById(1.to(100)).Skip(10).Take(10);
            int index = 11;
            foreach (var row in query)
                Assert.AreEqual(index, row.Id);
                index++;
        [Test]
        public void ShouldSelectFromOneHundredToNinetyOne()
            var db = Database.Opener.OpenFile(DatabasePath);
            var query = db.PagingTest.QueryById(1.to(100)).OrderByDescending(db.PagingTest.Id).Skip(0).Take(10);
            int index = 100;
            foreach (var row in query)
                Assert.AreEqual(index, row.Id);
                index--;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

QueryTest.cs

Latest commit

History

QueryTest.cs

File metadata and controls