Signum Framework Tutorials Part 2 – Southwind Logic

using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Signum.Engine;
using Signum.Entities;
using System.Diagnostics;
using System.IO;
using Signum.Utilities;

namespace Signum.Test.LinqProvider
{
    [TestClass]
    public class TakeSkipTest
    {
        [ClassInitialize()]
        public static void MyClassInitialize(TestContext testContext)
        {
            Starter.StartAndLoad();
        }

        [TestInitialize]
        public void Initialize()
        {
            Connection.CurrentLog = new DebugTextWriter();
        }

        [TestMethod]
        public void Take()
        {
            var takeArtist = Database.Query<ArtistDN>().Take(2).ToList();
            Assert.AreEqual(takeArtist.Count, 2);
        }

        [TestMethod]
        public void TakeOrder()
        {
            var takeArtist = Database.Query<ArtistDN>().OrderBy(a => a.Name).Take(2).ToList();
            Assert.AreEqual(takeArtist.Count, 2);
        }

        [TestMethod]
        public void TakeSql()
        {
            var takeAlbum = Database.Query<AlbumDN>().Select(a => new { a.Name, TwoSongs = a.Songs.Take(2) }).ToList();
            Assert.IsTrue(takeAlbum.All(a => a.TwoSongs.Count() <= 2));
        }

        [TestMethod]
        public void Skip()
        {
            var skipArtist = Database.Query<ArtistDN>().Skip(2).ToList();
        }

        [TestMethod]
        public void SkipOrder()
        {
            var skipArtist = Database.Query<ArtistDN>().OrderBy(a => a.Name).Skip(2).ToList();
        }

        [TestMethod]
        public void SkipSql()
        {
            var takeAlbum = Database.Query<AlbumDN>().Select(a => new { a.Name, TwoSongs = a.Songs.Skip(2) }).ToList();
        }

        [TestMethod]
        public void SkipTake()
        {
            var skipArtist = Database.Query<ArtistDN>().Skip(2).Take(1).ToList();
        }

        [TestMethod]
        public void SkipTakeOrder()
        {
            var skipArtist = Database.Query<ArtistDN>().OrderBy(a => a.Name).Skip(2).Take(1).ToList();
        }
    }
}