Dynamic LINQ - Knowledge Base (KB)
27 results in tag: linq-to-entities
How to create a dynamic linq to entities query
Now this is probably really easy but being the tool that I am, I'm not sure the best way to attack this problem....I have a DAL and a load of methods using EF that populate drop down lists in a UI. i.e. material, source....From these, I want the user to ...
asked by Ricardo Deano
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
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
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 .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
OrderBy with Dynamic Linq and one to many relationship in EF
I'd like to implement a module for filtering and paging. I understand that to suceed I had to use Dynamic Linq or Reflection, so I started trying to make it work .. but since the field that contains the text to be filtered in a one to many relationship EF...
asked by Julien
JSON results are returned in a different order than expected
I am following ...Phil Haack's example on using jQuery Grid with ASP.NET MVC.... I have it working and it works well...except for one minor problem. When I sort the columns by something other than the ID, the JSON data returned from the server is very...w...
asked by JasCav
LINQ Dynamic Query Library
I am building an ASP.Net MVC 3 application with Entity Framework 4. When the two pieces of code below are executed, both variables (query1 and query2) have a return type of...System.Data.Objects.ObjectQuery<Asset.Model.Equipment> ...Query1 uses a direct i...
asked by tcode
Can I create a LINQ-to-Entity query on non-Entity Member fields
I have an Entity class that I have extended using the ...partial class... syntax to have some derived properties. I would like to perform a query using the ...IQueryable<T>... interface that uses the information from these fields, but I currently get an ...
asked by Lucas
Dynamic Linq Doesn't work with Linq to Entities
I am working on small project which Linq To entities. There is a requirement to filter the data based on the search criteria/filter which is set by the user. Since the filter/search criteria can be for any of the fields which are displayed in the view, I ...
asked by Madhusudhanan Padmanabhan
Is Injection Possible through Dynamic LINQ?
Using the Dynamic LINQ library (...link...), is it vulnerable to injection? and (if so) how can this be protected against?...Some background from ...Security Considerations (Entity Framework)...:...LINQ to Entities injection attacks:...Although query comp...
asked by Seph
Exception using OrElse and AndAlso expression methods
I am trying to build an expression tree programmatically....I have in my input, a list of condition classes which have the following form:...public class Filter { public string field { get; set; } public string operator { get; set; } public st...
asked by Lorenzo
Dynamic LINQ (to entities) Where with nullable DateTime column
I have been banging my head on this problem for sometime. There are some similar cases, but the solutions weren't applicable on my case....I have a method that returns filter query in string format. The method has logic for different data types, sets corr...
asked by Tx3
DbSet<T>.Include() causes SELECT N+1 when used in extension method
I have an extension on IQueryable that allows passing in delimited string of property names which, when used causes query not to construct JOINs and effectively causes SELECT N+1 issue....What I noticed is that if I call native EF extension .Include("prop...
asked by zam6ak
Dynamic Linq .Select() - How to handle certain null values
I am using System.Linq.Dynamic for a project that requires the user to choose which properties will be selected/projected at runtime....So, I have a query like this:...var query = db.Users.Select("New(UserId, Username, Groups.Max(DateInserted) AS DateInse...
asked by Fred Wilson
Dynamic LINQ Compare Dates in Entity Framework
I am using the dynamic linq library with entity framework and want to compare dates. I have succesfully extended the library based on the following SO article ...here... However what I can not seem to do is to get the library to compare just the date port...
asked by Cragly
How do I merge objects back together after a SelectMany in System.Linq.Dynamic or maybe different solution all together?
I'm trying to select out a couple of fields in a collection inside of collection. Roles->Users (name and ID) I was able to get flattened data using select many, but now I need to merge it back to a collection objects so my json is formatted correctly. I...
asked by Nick Tullos
How to do "let" in dynamic LINQ?
How would I write this query in dynamic linq? I know how to do the select, but how do I do the "let"?...var qry = from sr in data.Addresses let AddressType_Desc = sr.AddressType.AddressType_Desc let Country_Desc = sr.Co...
asked by Jonathan
Aggregate function Count() using dynamic linq query
I am trying to use ...Aggregate function...Count()... on some column using dynamic linq query but I am not able to achieve, what I am exactly looking is...Select Count(Id),Id from Table1 Group By Id Having Count(Id) > 1 ...I want to convert the same q...
asked by Abhinay
Page 1 of 2