In ASP.NET 4.0, troubleshoot a dynamic linq query.

dynamic-linq linq

Question

I have a regular linq query that is written as such: 

    Clients.Where (c => c.EmailReturnUndeliverable == false || 
                        c.ClientBadStanding_TF == false)

I would like to dynamically write the query as such: 

    Clients.Where ("EmailReturnUndeliverable = false Or ClientBadStanding_TF = false")

I have reviewed Scott G's article on Dynamic Linq and it looks like my syntax is correct.

However, I cannot get the 2nd query to run.

My setup:

VS 10 / ASP.NET App

Steps I have taken:

  • added the DynamicLibrary.cs file that Scott references into my 'App_Code' folder
  • attempted to use the Using statement: using System.Linq.Dynamic; (as used in Scott's 'DynamicLINQCSharp' project) but am getting a missing assembly reference error.

Anyone have any council on what I am missing or how to get the using statement to clear up?

1
2
2/23/2012 2:53:11 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

In case if your CLients is a list, can you try

 Clients.AsQueryable().Where ("EmailReturnUndeliverable = false Or ClientBadStanding_TF = false")

If I am not mistaken DynamicLibrary.cs has functions which can we applied to IQueryable

0
2/23/2012 5:11:15 AM

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

In my asp.net project, how can I utilize dynamic LINQ?

Well, I'll first say that dynamic LINQ is ...usually... overkill, but sometimes useful. But you should just be able to reference the dll and away you go. If no intellisense is appearing, but it ...compiles..., then check where (physically) the dynamic linq dll is located. Ensure the "foo.dll.xml" file is located next to "foo.dll" (where "foo" is th...
.net c# dynamic-linq linq visual-studio
asked by Marc Gravell

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

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

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

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...
c# dynamic-linq expression-trees lambda
asked by afrischke

Dynamic Linq/ Dynamic Query: cannot get data for jqGrid

OK, found the solution here:...Strange Exception thrown using Dynamic Linq Entity Framework Query...This works:...var s = context.testdata.OrderBy("it.id asc");
asp.net-mvc dynamic-linq entity-framework jqgrid linq
asked by Oliver Kötter

Linq to NHibernate and Dynamic LINQ - query caching not working

Ok, I know what is the reason....Dynamic Linq doesn't use Parameter Names in Linq Expressions. E.g. if I want to sort using lambda statemant, I write:...query.OrderBy(item => item.Name) ...Above we see an ...item... lambda parameter name....When I use Dynamic linq:...query.OrderBy("Name") ...in the result Queryable the lambda parameter in OrderBy m...
dynamic-linq linq linq-to-nhibernate nhibernate
asked by cryss

Querying dynamic in asp.NET with SQL server

Here is an example for dynamic query. Also you can combine with your query linqkit is good predicate builder....http://www.albahari.com/nutshell/linqkit.aspx...https://github.com/scottksmith95/LINQKit...public List<CustomerPointsDetail> GetCustomerPointsDetails( int customerId, int? catalogRewardId = null, long? ...
asp.net-mvc dynamic-linq json linq
asked by Sercan Timoçin

How to construct dynamic LINQ query string be for a query that looks like *abc*def*

It looks like what you need is ...IndexOf.... This returns the starting index of the substring, if it exists, otherwise -1....var.Contains("abc") && var.Contains("def") && var.IndexOf("abc") > var.IndexOf("def") ...For example, if we use the string ...XabcXdefXabc..., ...var.IndexOf("abc")... will yield ...1... and ...var.IndexOf("def")... will...
c# dynamic-linq linq regex
asked by gnalck

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