Click here to Skip to main content
15,885,757 members
Articles / Programming Languages / C# 4.0

Dynamically evaluated SQL LINQ queries

Rate me:
Please Sign up or sign in to vote.
4.95/5 (35 votes)
30 Nov 2013CPOL8 min read 192.1K   2.6K   116  
Extension methods to evaluate plain text SQL queries against IEnumerable collections.
using System;
using System.Linq;
using System.Reflection;

namespace SqlLinq.UnitTests
{
    /// <summary>
    /// The SequenceEquals extension method will use Equals by default
    /// This base class just provides a boilerplate equals operator that does
    /// some type checking and then compares hash codes
    /// </summary>
    abstract class EquatableObject
    {
        public override int GetHashCode()
        {
            var values = from p in this.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance)
                         where p.CanRead
                         select p.GetValue(this, null)
                             into value
                             where value != null
                             select value;
            unchecked
            {
                return values.Aggregate(0, (total, next) => total ^= next.GetHashCode());
            }
        }

        public override bool Equals(object o)
        {
            if (object.ReferenceEquals(o, null) || o.GetType() != this.GetType())
                return false;

            return object.ReferenceEquals(o, this) || this.GetHashCode() == o.GetHashCode();
        }
    }

    class BasicPerson : EquatableObject
    {
        public string Name { get; set; }
        public string Address { get; set; }
    }

    class Person : BasicPerson
    {
        public int Age
        {
            get
            {
                return (int)((DateTime.Now - Birthdate).TotalDays / 365.25);
            }
        }

        public int Weight { get; set; }
        public DateTime Birthdate { get; set; }
    }

    class Family : EquatableObject
    {
        public string Name { get; set; }
        public string Address { get; set; }
        public double AverageAge { get; set; }
        public int TotalAge { get; set; }
    }

    class FamilyMember : EquatableObject
    {
        public string Name { get; set; }
        public string LastName { get; set; }
        public string Location { get; set; }
        public int FamilySize { get; set; }
    }

    class Pet : EquatableObject
    {
        public string Name { get; set; }
        public BasicPerson Owner { get; set; }
    }

    class Pair : EquatableObject
    {
        public string OwnerName { get; set; }
        public string PetName { get; set; }
    }
}

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 Code Project Open License (CPOL)


Written By
Team Leader Starkey Laboratories
United States United States
The first computer program I ever wrote was in BASIC on a TRS-80 Model I and it looked something like:
10 PRINT "Don is cool"
20 GOTO 10

It only went downhill from there.

Hey look, I've got a blog

Comments and Discussions