Dynamic LINQ - Knowledge Base (KB)

ASP.NET MVC Authorization based on role membership or data relation (ownership)

I'd like to extend the AuthorizeAttribute in ASP.NET MVC so that it supports the concept of a user's authorization being based on their role membership OR "ownership" of the data in question. I'm using LINQ2SQL for data access. There is a similar question...

Can I create a LINQ-to-Entity query on non-Entity Member fields

I have an Entity class that I have extended using the ...partial class... syntax to have some derived properties. I would like to perform a query using the ...IQueryable<T>... interface that uses the information from these fields, but I currently get an ...

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...

How to get value from string expression

I have a string stored in my db:..."Users.ElementAt(1).LastName" ...I then have an object like so:... MyClass myclass = new MyClass () { Users = new List<User>() { new User() { ...

Can't get Dynamic LINQ to work -Reflection error

Trying to produce my first sample with Dynamic LINQ and I just can't seem to get it to work. Here's what I've got. NBL It's a bit rugged because I've been culling it back trying to find the problem....Dim blah = (New dcDataContext).Employees.Where("Accoun...

Dynamically Linq Select Cast To IEnumerable

I'm creating a Widget builder which Dynamically takes in Queries and returns a datatable with the results. NOTE: this uses Dynamic Linq to take in string queries the library source can be found ...here...My only issue is casting the results set to an IEnu...

Convert List to typeof UnderlyingSystemType

I am currently working on code that is using ...dynamic-linq..., I ran into a problem when using a ...List<BaseClass>..., where the list actually contains a list of the ...Person... Class....When I execute the following code I get a ...ParseException...:....

How to create e.ID == id lambda expression dynamically

I've read many great answers here on stack about dynamic creation of lambda expression, but cannot make my own....I need to select entity from DB by ...ID..., but I don't know its type beforehand. Only name of a type. So: ...var modelType = Assembly.Load(...

Dynamic linq for object collection - Target object is not an ExpandoObject

I try to dynamically read the property values based on the text naming of these properties. This simply works for nested classes. But if there is a nested collection class, I would like to be able to select an item using a dynamic linq. Unfortunately, whi...