String based Dynamic Linq - Nested Where clause

c# dynamic-linq

Question

I'm doing string based Dynamic Linq and need to apply a nested where clause.

The answer here gets me half way there. However, the columns in two tables have matching ids. I need to be able to reference via an alias or other, like below:

rolesCollection
.Where("AssignedUsers.Where(AssignedUsers.TypId == rolesCollection.TypId).Any()");

Any idea how to accomplish this? I don't have the ability to pass in an object, this has to be purely a string based solution in the context of a genericized API search method. This is just an example of what I need ... I don't have the ability to join or anything via code. I'm looking for the solution in the string based portion of the example code.

1
2
11/20/2017 7:52:02 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The AssignedUsers object should, in this theoretical example, have an AssignedUsers_Typ collection, and you can simply reference below, without having to reference the Typ columns from both tables. 

   rolesCollection.Where("AssignedUsers_Typ.Any()");

I was able to resolve my issue using this solution.

0
11/21/2017 9:34:34 PM

Popular Answer

Do you want something like that;

rolesCollection = rolesCollection.Where(x => assignedUsers.Any(t => t.TypId == x.TypId)).ToList();
lucky

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

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

The solution to my particular query was to do this:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals new {pla.Pro...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

How can I utilize System.Linq.Dynamic for the LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

Generic method for constructing a string Dynamic Linq query. includes strings that have been tokenized

Here's what I use to do this:...using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Linq.Expressions; using System.Collections.ObjectModel; namespace MyLibrary.Extensions { /// <summary>Defines extension methods for building and working with Expressions.</summary> public static class Expressio...
dynamic-linq linq
asked by Josh M.

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

Converting a LINQ clause to a dynamic LINQ clause

var selectData = (from i in data select i).Where(datum => datum.Name == "Bob1"); ...The ...Where... method takes a delegate, not a string, so you need to pass in a delegate or lambda....Edit: based upon your comment to one of the other answers, you will need to use Reflection to make the property value lookup dynamic....Edit: look...
c# dynamic-linq
asked by Paul Ruane

In C#, how do you make a dynamic lambda-based Linq expression from a string?

A similar question was asked here:...Is there an easy way to parse a (lambda expression) string into an Action delegate?...As I understand it, this 'Dynamic Query' is actually a framework for passing in restrictions for a Where clause without using a lambda expression. ...The significance of that is that lambda expressions are not dynamic methods, ...
c# dynamic-linq expression-trees lambda linq
asked by Sprague

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

It seems what I was trying to do is not possible with the current DynamicLINQ library. The reason it didn't work was well outlined below by Tilak....My solution was to modify the DynamicLINQ library to allow the query to be written as a string and passed to the where clause for Date/Time datatypes. The modification was found here by Paul Hatcher: ....
c# dynamic-linq entity-framework linq string
asked by Ricketts

Linq Dynamic Error with Dynamic Where clause

The error points to the place where the LINQ query is evaluated and, as the message says, the problem is that a character is expected but several characters were provided....Check whenever ...ddl_AreaFilter.SelectedValue..., ...ddl_SubAreaFilter.SelectedValue... or ...ddl_AllocFilter.SelectedValue... actually contain a character or a string. If the...
dynamic-linq linq vb.net
asked by jnovo

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow