Dynamic LINQ - Knowledge Base (KB)
64 results in tag: entity-framework
Using Dynamic Linq Entity Framework Query, an unusual exception was thrown.
I have a gallery entity framework class,and I'm attempting to use the Dynamic Linq Library posted on ScottGu's blog to query the entity set. The failing line of code reads:...return context.Galleries.OrderBy(sidx + " " + sord).Skip(page * rows).Take(rows...
asked by midas06
On a collection, dynamic LINQ?
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...
asked by Simon Dugré
Which of these evolved from DLinq: Linq to SQL or 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
LINQ Dynamic Group Using Several 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
Using the OrElse and AndAlso expression methods, throw an exception.
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
In Entity Framework, how do I pick non nullables from a nullable relation?
I am making a reporting tool that is based off Entity Framework and Scott Guthrie's Dynamic Linq library....I have run into a snag when trying to select a non nullable field from a related table when the related record isnt always there. For example, I ha...
asked by Mr Bell
How to design a query when the table name is a parameter in Linq To Entities
Dynamic queries are not dynamic enough. I have seen solutions like ...this... but still I have to indicate which table to use as the basis:...var query = db.Customers.Where("...").OrderBy("...").Select("..."); ...I want to create a simple query tool where...
asked by Bolt Thunder
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/ Dynamic Query: cannot get data for jqGrid
I'm using jqGrid and I have a problem getting Dynamic Linq to work. I used NuGet to install Dynamic and added "using System.Linq.Dynamic;"....Using VS 2010 Pro, MVC 3.0...This works:...var s = context.testdata; var c = s.Count(); ...c shows 5136 items....
asked by Oliver Kötter
Dyamic Linq .Net 4 error 'userid' could not be resolved in the current scope or contex
I am trying to use Dynamic Linq library in my code, but it gives this error...'UserId' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are r...
asked by Waqas
Dynamic linq expression for EF
I'm trying to write some dynamic linq expression for my EF app....I have an enum that represents a type:...public class MyEntity { public int? One { get; set; } public int? Two { get; set; } public int? Three { get; set; } // other fields.. } pub...
asked by Mohamed Nuur
Dynamic LINQ DateTime Comparison String Building - Linq To Entities
I'm using the dynamic LINQ library by Scott Guthrie together with Entity Framework and C#....I have to build my where string into a variable based on several factors and then pass the string variable to the where clause. For some reason, this will work:..
asked by Ricketts
Dynamic linq unable to parse ordering
Say I have a query that selects into a defined type like so:...public class SomeObject { public DateTime CreatedDate { get; set; } } private class MyType { internal SomeObject Object1 { get; set; } internal SomeThing Object2 { get; set; } ...
asked by Oxymoron
Datetime comparison before and after
I'm using dynamic linq to build a where clause for a moderately complex search, and I've run into a problem with dates....I want the user to be able to filter on the "date created" searching for anything either before that date, on that date, or after tha...
asked by Mansfield
Call linqkit expression in a dynamic linq query
How I can call this LinqKit expression... public static Expression<Func<Transaction, string>> ExpressionOfStatusName { get { Expression<Func<Transaction, string>> status = (transaction) => transaction.Tr...
asked by user1756338
How to Type Cast dynamically to string while using Contains in Dynamic LINQ?
I want to use Dynamic LINQ Query to Search with some text in all Properties in a class. i am using following function to create expression. I am passing property name and search text to the method. In that method if the property type is String then it is...
asked by Kartheek
Predicate or Dynamic Linq that can return from different object sets?
Let's say I have two Entity Sets in my Entity Framework backed project, Cars and Trucks. Both Car and Truck implement IDriveable...Is it possible to have either a Predicate or Dynamic Linq to return a specific IDriveable, without the calling function hav...
asked by Neil N
Dynamic Linq gives error in combination with EntityFramework
We use Entity Framework, and we need some runtime build queries on our objects. Building expression trees from scratch seems like a lot of work, so we want to use "System.Linq.Dynamic"...Working through the samples I got this to work:...dbModel.As.Where("...
asked by k.c.
Safe dynamic column name in dynamic LINQ
I'm trying to create a dynamic WHERE clause with LINQ. I have a working example but I'm worried that it's not safe from SQL injection....The following LINQ code:...var oQuery = _db.People.Where("FirstName.Contains(@0)", "kev"); ...produces the following S...
asked by Kevin Cloet
Dynamic Linq to add LIKE to where clause
I'm trying to perform a LIKE clause in an entity query. The ...examples... I've seen use dynamic linq to do this kind of thing, but my code......var query = context.StudySet .Where("it.PatientName LIKE @patientName", new ObjectParameter("patientName",...
asked by nopskazoid