Dynamic LINQ - Knowledge Base (KB)
447 results
How to do Linq on ITypedList?
So far, I find Linq can be used on existing fields and properties of a class, not on virtual properties. In other words, ITypedList can not work with Linq, even by dynamic Linq....I tried the following code:... IQueryable contact ; ... dynamic l =...
asked by Ying
Does dynamic GroupBy work together with dynamic Where in dynamic LINQ?
I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.Field...
asked by alpav
Linq.Dyanmic GroupJoin implementation
I am working on creating an Extension Method in the Linq.Dynamic project for GroupJoin. But, for some reason it will not run. The signatures seem to match....public static IQueryable GroupJoin(this IQueryable outer, IEnumerable inner, string outerSelector...
asked by Dan
Querying Entity with LINQ using Dyanmic Field Name
I have created a dynamic search screen in ASP.NET MVC. I retrieved the field names from the entity through reflection so that I could allow the user to choose which fields they wanted to search on instead of displaying all fields in the view....When the ...
asked by Scott Lance
How to refer to a field in a dynamic linq query?
I have a query that needs to be dynamic, I think most of my syntax is right but I do not know how to give it the name of the column I want to group by. I have tried a few different approaches and I always get an error - "No property or field 'name' exists...
asked by Ronan
DLinq morphed into which one -- Linq to SQL or the Entity Framework?
What happened to Dlinq? I heard a few years ago that it was abandoned....Was some of its code used to create Linq to SQL or the ADO.NET Entity Framework? Which one? In other words, which of the two latter technologies are a new avatar of the old DLinq?...
asked by Water Cooler v2
Dynamic table name linq-to-sql dynamic LINQ
I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be ...
asked by Muhammad Adeel Zahid
Linq: Dynamic Query Contruction: query moves to client-side
I've been following with great interest the converstaion here:...Construct Query with Linq rather than SQL strings...with regards to constructing expression trees where even the table name is dynamic....Toward that end, I've created a Extension method, ad...
asked by donundeen
Entity Data Model, Dynamic Linq, multiple table dynamic Where clause, strongly typed return types
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....
asked by rposbo
Dynamic LINQ GroupBy Multiple Columns
I need to translate the following LINQ query to Dynamic LINQ that accepts several grouping columns based on user input. Basically I have a bunch of dropdownlists that apply groupings and I don't want to enumerate every combination of groupings. If Dynamic...
asked by Daniel Coffman
Sortable JqGrid using LINQ to MySQL (DbLinq) and Dynamic LINQ - Orderby doesn't work
I've got problem with sorting entries in JqGrid. Orderby seem to not work. I set breakpoint in code and I noticed, that orderby doesn't change order of elements. Any idea what could be wrong?...I'm using LINQ to SQL with MySQL (DbLinq project)....My actio...
asked by mlusiak
dynamic linq query
I have query to perform where the user will enter at runtime one of the columns to be included in the result set. And, I won't know until runtime how many columns he could choose from (he uploads a file that can contain a varying number of columns). I'd l...
asked by user471807
Sort using dynamic LINQ on a complex object
I have a list of Objects on which I use dynamic LINQ to perform sorting. ...The object is like this, ...public class SampleDTO { public string Vendor { get; set;} public string Invoice { get; set; } .. .. } ...And I ...
asked by Illuminati
Dynamic LINQ on a generic object (without any hard-coded properties)
I have a generic object which uses a dictionary to store the properties:...class MyObject { Dictionary<string, object> Properties = new Dictionary<string, object>(); internal GetValue(string name) { return Properties[name]; } internal SetValu...
asked by Andrew White
Dynamic Linq: How to specify the StringComparison type?
I'm working on doing some custom filtering and sorting of a dataset, based on a collection of sort fields sent from the client browser, and am using Dynamic Linq to achieve (most of) the desired effect. Where I'm running into a problem is when I try to s...
asked by rswafford
Linq to SQL - Multiple where clauses at runtime
I am trying to accomplish this but only my first where clause is getting used when the query runs....This needs to for for .Net 3.5 so the WhereIf in 4.0 is not usable....var query = from tb in dataContext.TableOne where tb.DateTimeCreated >= from...
asked by SetiSeeker
Dynamic LINQ .Contains() Throws Timeout expired. Error
Hey Guys, ...I'm working on this query to export some data from a sql 2008 database on vb.net 3.5 website. I'm using dynamic linq after the inital query to filter down the results based on date, state, country, specialty, and hospital affiliation....Each ...
asked by Rob Carroll
Filtering DataGrid, MVVM, Dynamic LINQ
How can I filter my DataGrid items like MS Access filter works (just select by mouse some part of cell and press "Filter" button)?...I have ViewModel MyViewModel with 2 Commands (Filter and ClearFilter) and ObservableCollection I have Model with method G...
asked by Lari13
Executing DynamicExpression with unknown types
If anyone is very familar with the Linq.Dynamic namespace I could use some help -- couldn't find any indepth resources on the internet....Basically I'm using DynamicExpression.ParseLambda to create an expression where the type is not known at compile time...
asked by sean
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...
asked by Kiarash
Page 3 of 23