zzz projects Dynamic LINQ
Home Getting Started Knowledge Base Online Examples  GitHub
  • Home
  • Getting Started
  • Knowledge Base
  • Online Examples
  •  GitHub
  •   Download  

Dynamic LINQ - Knowledge Base (KB)

27 results for: 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 ...
c# dynamic-data dynamic-linq linq-to-entities
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...
.net dynamic dynamic-linq linq linq-to-entities
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 ...
c# dynamic-linq expression-trees lambda linq-to-entities
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...
dynamic-linq expression-trees lambda linq linq-to-entities
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....
anonymous-types c# dynamic-linq linq-to-entities
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 ...
dynamic-linq linq-to-entities
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...
c# dynamic-linq linq linq-to-entities linq-to-sql
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...
asp.net-mvc-2 dynamic-linq jqgrid json linq-to-entities
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...
asp.net-mvc-3 dynamic-linq entity-framework-4 jqgrid linq-to-entities
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 ...
dynamic-linq entity-framework-4 iqueryable linq-to-entities reflection
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 ...
dynamic-linq linq-to-entities
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...
c# dynamic-linq linq linq-to-entities linq-to-sql
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...
dynamic-linq entity-framework linq linq-to-entities
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...
c# dynamic-linq linq linq-to-entities
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...
dynamic-linq entity-framework linq-to-entities objectquery
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...
dynamic-linq linq-to-entities
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...
.net dynamic-linq entity-framework linq linq-to-entities
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...
dynamic-linq linq linq-to-entities
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...
c# dynamic-linq linq linq-to-entities
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...
c# dynamic-linq linq linq-to-entities sql
asked by Abhinay

Page 1 of 2
  • 1
  • 2
  • ยป

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...