Dynamic LINQ - Knowledge Base (KB)
447 results
Generic function for building Dynamic Linq query of string.contains against tokenized string
I am using ...Expression.And... and ...Expression.Or... to build dynamic linq queries. When the property/field being queried is a string, and the string contains spaces I would like to tokenize the string on the spaces and create an "And'd" sub query on t...
asked by Simon Fox
Dynamically select and update a column value in LINQ resultset
I have a scenario in which there exists a LINQ resultset; I used the following query...var stockDetails = from d in db.BloodBanks where d.bbUserName == Session["username"].ToString() select d; ...Now I want to use thi...
asked by Piyush
Counting percent of rows with category out of total number of rows using Dynamic Linq
How to achieve ...this... using ...Dynamic Linq Join... and ...Dynamic Linq SelectMany
asked by alpav
let the user build dynamic expressions from gui wizard
I want to build a gui panel/wizard where my application's users could build custom conditions/expressions using the properties of a strongly typed object model. ...Basically something like this....The structure could be nested (LHS/RHS might consist of ot...
asked by wilsonlarg
Building a common set of methods that can operate on any linq table
Problem:... We make extensive use of a repository pattern to facilitate read/write operations on our datastore (MS SQL using LINQ) across multiple applications and subsections of functionality. We have series of methods that all do something similar to ea...
asked by amber
Dynamically created class as DataContract in WCF
Is there any way to return an array of objects of type ...DynamicClass... from WCF method?...I'm using ...Dynamic Linq Library... in my WCF service, so as to ...select... columns of database table , as per the request from clients. The client code should ...
asked by Nawaz
Use Any() and Count() in Dynamic Linq
I am trying to write dynamic Linq Library query to fetch record on condition, Customers who has order count is greater than 3 and ShipVia field equal 2....Below is my syntax what i have tried....object[] objArr = new object[10]; objArr[0] = 1; IQueryable<...
asked by ArpanDesai
LINQ. Reducing the code by using dynamic queries
I use the following code to fill the Table1 dictionary with the information found within the LINQ query.... Dim DB As New DatabaseDataContext Dim Table1 As New Dictionary(Of String, Integer) Dim Table2 As New Dictionary(Of String, Integer) Priv...
asked by OrElse
dynamically append multiple linq expressions at run-time
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
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
Dynamic Expression API: I can do a predicate, how to code an OrderBy Specification?
I figured out how to do a predicate from a string supplied by a client based on ...Dynamic Linq... (this is wrapped in a Specification object):...return System.Linq.Dynamic.DynamicExpression.ParseLambda<TE, bool> (filter.ToString(), arguments.ToAr...
asked by Zachary Scott
Dynamic Linq query on a collection of a base type while accessing type specific properties
How can I run a dynamic LINQ query on a collection of a base type (like the IPerson interface) but access implementation specific properties (like Age)....I can be sure that all items in the collection are the same, i.e. looking at the first type I can as...
asked by lukebuehler
VB.NET and the System.Linq.Dynamic namespace
I would use the ...System.Linq.Dynamic.......I added the specified ...Dynamic.vb... file, that starts like this :...Option Strict On Option Explicit On Imports System.Collections.Generic Imports System.Text Imports System.Linq Imports System.Linq.Express...
asked by serhio
How to use Enums with Dynamic Linq?
I would like to use enumerations in my dynamic LINQ queries. ...Is it possible, and if, how?...Consider the code bellow: ...using System; using System.Collections.Generic; using System.Linq; using System.Linq.Dynamic; namespace ConsoleApplication2 { ...
asked by serhio
Lambda Expression "Contains"
I use a dynamic filter, that filters a collection using object properties, operators and values. Now, if the property is a string, the operator is "contains" and the value is "word", the filtered objects containing the "world" should be filtered according...
asked by serhio
Linq Expressions does not find a public method... :-/
I write a expression that will test if a property(enum) of a object have, or have not some flags set. ...The code bellow test if the validity of an object "contains" or not Monday, using the HasFlag function of an Enum....Actually, the Call method seems d...
asked by serhio
How do I do a left outer join with Dynamic Linq?
I am trying to mimick the left outer join ...here... but using dynamic linq extension methods. What i have:...public static IQueryable SelectMany(this IQueryable source, string selector, string resultsSelector, params object[] values) { if (sourc...
asked by jaywayco
EntitySqlException: The command parameter syntax '@0' is not valid
I'm getting this error when I issue this:...DataContext.DBProjectEntities.Projects.Where(xWhere, parameterList.ToArray) ...The command parameter syntax '@0' is not valid. Near line 6, column 37....xWhere... is a string containing value ..."(ProjectStatuse...
asked by Lukasz
C# System.Linq.Dynamic: How to pass in the object [] params to SqlQuery
Why does:...IEnumerable<MyEntity> MyFunction(string sql, object [] params) { // EG: // "SELECT * FROM MyTable WHERE MyField0 = @0 AND MyField1 = @1" // params = { 1, "UK" } return Context.Database.SqlQuery<TEntity>(sql, params); } ......g...
asked by awrigley
Type arguments cannot be inferred from usage, Can anyone help please?
I am trying to use Dynamic Linq (the one published by ScottGu) to do a GroupBy (lambda expression). I have an object. And i am doing AsQueryable. THis is what i have.....var result = Items.AsQueryable().GroupBy("DeliveryDate"); ...but it gives me an error...
asked by Martin
Page 5 of 23