Cast BindingList of interface to filter by dynamic linq query knowing the type

How can I make Lambda in LINQ filter for dynamic LINQ?

The problem is that Where doesn't ...change... the collection. It returns the newly filtered collection....Try this:... Dim filteredPerson = people.Where(Function(fp) fp.Fname = "Bob") ...(By the way, I don't see anything dynamic in here... where are you using dynamic LINQ?)...To add multiple ...Where... clauses, you'll want something like this:...

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

When writing a method for an oData service I have the below linq, for which I need to have a dynamic "where" clause to filter the results (the "new"s in the joins are for composite PKs in the Entity Data Model):...var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute ...

Dynamic Linq query on a base type collection to retrieve type-specific characteristics

How can I run a dynamic LINQ query on a collection of a base type (like the IPerson interface) but access implementation specific properties (like Age)....I can be sure that all items in the collection are the same, i.e. looking at the first type I can assume that the others are the same....I need this for a UI that can apply filters to different c...

How to use Dynamic LINQ to simultaneously query expressions on several object types

You could give your ...FileMetabaseObject... an abstract read-only string property called ...Value..., then override it in all child classes:...public abstract class FileMetabaseObject { public abstract string Value { get; } } public class FileTag : FileMetabaseObject { public string Tag { get; set; } public override string Value { get...

Perform a query on an object having members of type "dynamic" using Dynamic Linq.

Are ...dynamic... members incompatible with Dynamic Linq queries?, or is there another way of constructing expressions that would evaluate properly when dealing with members of type ...dynamic...?...Both can work together. Just do a conversion to Int32 before doing the comparison like so:...IEnumerable<DataItem> result = repository.AsQu...

Dynamic Linq searching multiple columns of multiple types including nullable types

I need select my columns dynamically and I do not know the types of the columns ahead of time. I've got a string and I want to search all the columns if they contain that string, converting non-string into string for the comparison....string format = "Convert.ToString({0}).Contains(@0)"; Model.Where(String.Format(format, columnName), searchString);...

How to filter dynamic linq query on the initial data when there is self-join

I have a query that I generate by dynamic linq. The problem is when I self-join the initial data set, all other filters are on the latest table. I want it to be on the initial. How can I do that? Here is an example: ...var result = dataContext.Person; var initialData = result; .... var subQuery = initialData.Where(String.Format(predicateEntityIn, e...

How to Type Cast dynamically to string while using Contains in Dynamic LINQ?

Well, you probably know that's it's not possible to use ...ToString()... in linq to entities. ...So the following question is : how can I convert other types to string....For ...numeric values..., you have ...SqlFunctions.StringConvert..., but it has only overloads for ...double?... and ...decimal?...For ...DateTime..., you may find something using...

Cast ITable to IEnuerable<object> - Dynamic LINQ to SQL Query with no DataTable information

I need to write dynamic LINQ where I know nothing about the input table - data provider (which is why I'm using LINQ to SQL), no table name, nothing. I want to be able to query the data given user-selected fields and given values, something like the following:...Having a ...String...TheTableName..., and ...System.Data.Linq.DataContext...TheContex...

Linq Dynamic Query Issue - Operator 'OR' incompatible with operand types 'Boolean' and 'String'

I am currently trying to define a dynamic query in Linq but I am receiving the following error: ...My Query is the following:...valuesList = valuesList.Where("(position=1 OR value LIKE '%3%')") ...What am I doing wrong?