Dynamic LINQ - Knowledge Base (KB)

How to name fields using Dynamic Linq?

I have a huge query that is being made dynamically, but I want the select statement to not output the column names, buut custom values. FOr example, if I am doing a normal Linq query, I can do something like this:...var v = from p in db.items select new ...

Dynamic LINQ on a collection?

I've a project which ask me to do such a BIG search engine but which is all dynamic. I mean I can have about 0 to 9 main "group" which have inside something like an infinite possibility of "where" with "OR" or "AND". First thing we think was to use Dynami...

How to use Dynamic LINQ (System.Linq.Dynamic) for LIKE operation?

Can any body tell me how can I use a LIKE operator using ...System.Linq.Dynamic...?...I need to add more than one ...LIKE... expression in my dynamic ...where query.../* var query = db.Customers. Where("CityName Like @0 or CityName Like @1", "London", "US...

Dynamically select and update a column value in LINQ resultset

I have a scenario in which there exists a LINQ resultset; I used the following query...var stockDetails = from d in db.BloodBanks where d.bbUserName == Session["username"].ToString() select d; ...Now I want to use thi...

Use Any() and Count() in Dynamic Linq

I am trying to write dynamic Linq Library query to fetch record on condition, Customers who has order count is greater than 3 and ShipVia field equal 2....Below is my syntax what i have tried....object[] objArr = new object[10]; objArr[0] = 1; IQueryable<...

Dynamic Linq for dates

I want to build dynamic Linq. Following is my code which works fine for one date. But user can select many dates from calendar. And I need to make Linq for all those selected dates....saleDate = calendarSales.SelectedDate; List<SaleDetails> saleDetials = ...

LINQ Dynamic query nullable field

Suppose an SQL table 'employees' (containing a nullable datetime field called 'endDate')...static LINQ:...dim result = db.employees.where(function(c) not(c.endDate.hasValue)) ...Works perfectly!...dynamic LINQ:...dim result = db.employees.where("it.endD...

Scott Gu Dynamic Linq Convert Datetime to ShortDatetime

I am using the Scott Gu Dynamic ...Linq... class and I am trying to convert a datetime to return a short datetime before databinding the result set to a gridview in ...ASP.net.... Now, I know that I can go through the gridview row databound event and che...

can I use a dynamic entity context in my method?

I have a method for gridview sorting and paging which I am trying to make reusable for generic types but I am struggling to figure out how to make the entity context (MyContext) and table (tblReports) dynamic variables - can anyone help me out please?...p...

Dynamic Linq queries with sorting, nulls at end

I am trying to build an ASP.NET page that sorts on nullable fields. What I want to do is, if there are null values in the sortable field, always throw those rows to the end of the list. Otherwise, they show up at the beginning of the list, and I can imagi...

Dynamic Linq Library can't handling one on many relationship in select clause

I would like to get records from the database using Dynamic Linq Library ...NuGet.... How can I write query for select parent records along with list of child records. For example there is One-on-Many relationship between Question and Answers table. Quest...

Using Radgrid filter expression to query collection gives exception 'Expression Expected'

I am trying to query a collection using the filter expression from my radgrid. On the RadGrid I have the property of ...EnableLinqExpressions = "false"...However I get the exception ...Expression Expected... when using the code:...results = results.Where(...

Dynamic Linq 'contains' clause without using placeholder

The syntax given for contains clause is...ids = new int[] {1,2,3,4}; dataContext.Table.Where("@0.Contains(id)", ids); ...But what I want is ...dataContext.Table.Where("{1,2,3,4}.Contains(id)"); //getting exception here ...[ERROR] Expression expected (at i...