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
during runtime, dynamically add numerous linq expressions
I have two similar methods that take a criteria object (dumb object with a list of properties), call a "CreateExpression" method on that criteria object, and then use the returned expression to filter results....One of my examples has an argument of only ...
asked by Amanda Kitson
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
Is it feasible to make changes to a DataServiceQuery after it has been built?
I am building a pager in my UI that reuses a ...DataServiceQuery<MyEntityType>... built in another window when it comes to the end of its cached results. My current implementation attempts to do something like:...query = query.Skip(index*page_size).Take(...
asked by jordanpg
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
How can I use dynamic linq to make the insert technique more flexible?
I want to write some entity into database but there are a lot of entities I like to write something generally for them now I know this :...using(var dbContext = new myEntity()) { db.EntityName.AddToObject(newEntity); db.SubmitChanges(); } ...I dont ...
asked by kamiar3001
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
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
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
Page 1 of 4