Dynamic LINQ - Knowledge Base (KB)

How to extend this LINQ List<>.Contains to work with any Property using Reflection?

I have the following snippet that I currently use to run a .Contains() with a list of Ids passed as a comma separated list from users. This code works perfectly and the data is filtered exactly as I want it to be:...// Handle id in() statements explicitly...

Linq to NHibernate and Dynamic LINQ - query caching not working

I have problem with the NHibernate's second level cache. When I use query:... var items1 = Session.Query<Row>() .Cacheable(); .Fetch(x => x.Field) .OrderBy(x => x.Field.Value) .ToList(); ...Everything...

Using Nihibernate with system dynamic linq for Query<T>

I am trying to use system.dynamic.linq to create dynamic sorting....this, is the query that I use:...var query = dalSession.Query<T>().AsQueryable(); var res = (from x in query orderby "x.FirstName" select x) ...this is the mysql output:...select aff...

Dynamic LINQ cast to nullable

I'm using Dynamic LINQ with NHibernate. Simple example demonstrates my problem:...var q = sess.Query<User>().Select("new (Id, Login, Person.Id as PersonId)"); ...throws NullReferenceException when where are Users in database with User.Person == null....Th...

Dynamic Linq to OrderBy Object Nested in IEnumerable

I am trying to write some dynamic linq to order by a property of a list item, for use with NHibernate...public class Company { public string Name { get; set; } public List<Employee> Employees { get; set; } } public class Employee { public str...

Dynamic linq Binary and/or operator (Nhibernate linq)

I want to create an expression that as a result is a binary and or a binary or operation. Something like ...int a = 1; int b = 2; int c = 3; int d = a & b; // d = 0 int e = a & c; // e = 1 ...I hav not found anything in dynamic linq! But in linq this is a...