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)

English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

64 results for: in tag: entity-framework

Strange Exception thrown using Dynamic Linq Entity Framework Query

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...
dynamic-linq entity-framework linq
asked by midas06

Dynamic LINQ on a collection?

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...
asp.net c# dynamic-linq entity-framework
asked by Simon Dugré

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?...
ado.net-entity-data-model dynamic-linq entity-framework entity-framework-4 linq-to-sql
asked by Water Cooler v2

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...
.net c# dynamic-linq entity-framework linq
asked by Daniel Coffman

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

How to select non nullables from nullable relation in Entity Framework

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...
c# dynamic-linq entity-framework
asked by Mr Bell

Linq To Entities - How to create a query where the table name is a parameter

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...
dynamic-linq dynamic-sql entity-framework
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...
dynamic-linq entity-framework linq-to-entities objectquery
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....
asp.net-mvc dynamic-linq entity-framework jqgrid linq
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...
.net-4.0 dynamic-linq entity-framework linq
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...
c# dynamic-linq entity-framework linq
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:..
c# dynamic-linq entity-framework linq string
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; } ...
dynamic-linq entity-framework linq
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...
c# dynamic-linq entity-framework entity-framework-5 sql-server-2005
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...
c# dynamic-linq entity-framework linq linqkit
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...
c# dynamic-linq entity-framework linq linq-to-entities
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...
c# dynamic-linq entity-framework linq predicate
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("...
c# dynamic-linq entity-framework linq linq-to-entities
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...
dynamic-linq entity-framework linq-to-entities sql-injection
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",...
dynamic-linq entity-framework linq
asked by nopskazoid

Page 1 of 4
  • 1
  • 2
  • 3
  • 4
  • »

Prime Library

Performance

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

Expression Evaluator

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