Dynamic LINQ - Knowledge Base (KB)

Dynamic Linq help, different errors depending on object passed as parameter?

I have an entityDao that is inherbited by everyone of my objectDaos. I am using Dynamic Linq and trying to get some generic queries to work....I have the following code in my generic method in my EntityDao :...public abstract class EntityDao<Implementatio...

Linq to SQL - Multiple where clauses at runtime

I am trying to accomplish this but only my first where clause is getting used when the query runs....This needs to for for .Net 3.5 so the WhereIf in 4.0 is not usable....var query = from tb in dataContext.TableOne where tb.DateTimeCreated >= from...

Dynamic Or Clause Linq

Today we currently have a statement like this:...var Query = (from dp in db.Patients select dp); var UserID = User.Identity.GetUserId(); if (User.IsInRole("Administrator")) { Query = Query.Where(x => x.AdministratorID == UserID); } if (U...

Where condition with linq dynamic built at runtime to read xml

I've a problem with a query in linq (lambda expression) to read a complex and large xml file embedded in my software. At bottom of post can find the structure of single field "PRODOTTO", but there's about 2800 entries like this in the xml....The problem i...

C# Dynamic Linq Ternary Operator

I want to make a dynamic check for a null value. I want to make a where clause which will compare only the date part of the date field....It will work for non nullable date fields, but for nullable date fields we need to check for value as using .Date on ...