Click here to Skip to main content
15,886,362 members
Articles / Web Development / HTML

Signum Framework Tutorials Part 2 – Southwind Logic

Rate me:
Please Sign up or sign in to vote.
4.45/5 (6 votes)
15 Nov 2012LGPL325 min read 31.3K   1K   22  
In this part, we will focus on writing business logic, LINQ queries and explain inheritance
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.Engine.Linq;
using Signum.Utilities;
using System.Linq.Expressions;
using System.Data.SqlTypes;
using System.Reflection;

namespace Signum.Test.LinqProvider
{
    /// <summary>
    /// Summary description for LinqProvider
    /// </summary>
    [TestClass]
    public class SelectSortCircuitTest
    {
        [ClassInitialize()]
        public static void MyClassInitialize(TestContext testContext)
        {
            Starter.StartAndLoad();
        }

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

        [TestMethod]
        public void SortCircuitCoallesce()
        {
            var list = Database.Query<AlbumDN>().Where(a => ("Hola" ?? Throw<string>()) == null).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortCircuitCoallesceNullable()
        {
            var list = Database.Query<AlbumDN>().Where(a => (((DateTime?)DateTime.Now) ?? Throw<DateTime>()) == DateTime.Today).Select(a => a.Year).ToList();
        }


        [TestMethod]
        public void SortCircuitConditionalIf()
        {
            var list = Database.Query<AlbumDN>().Where(a => "Hola" == "Hola" ? true : Throw<bool>()).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortCircuitOr()
        {
            var list = Database.Query<AlbumDN>().Where(a => true | Throw<bool>()).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortCircuitOrElse()
        {
            var list = Database.Query<AlbumDN>().Where(a => true || Throw<bool>() ).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortCircuitAnd()
        {
            var list = Database.Query<AlbumDN>().Where(a => false & Throw<bool>()).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortCircuitAndAlso()
        {
            var list = Database.Query<AlbumDN>().Where(a => false && Throw<bool>()).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortEqualsTrue()
        {
            var list = Database.Query<AlbumDN>().Where(a => true == (a.Year == 1900)).Select(a => a.Year).ToList();
        }

        [TestMethod]
        public void SortEqualsFalse()
        {
            var list = Database.Query<AlbumDN>().Where(a => false == (a.Year == 1900)).Select(a => a.Year).ToList();
        }

        public T Throw<T>()
        {
            throw new InvalidOperationException("This {0} should not be evaluated".Formato(typeof(T).Name));
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The GNU Lesser General Public License (LGPLv3)


Written By
Software Developer (Senior) Signum Software
Spain Spain
I'm Computer Scientist, one of the founders of Signum Software, and the lead developer behind Signum Framework.

www.signumframework.com

I love programming in C#, Linq, Compilers, Algorithms, Functional Programming, Computer Graphics, Maths...

Comments and Discussions