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)

447 results for:

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...
dynamic-linq linq
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...
asp.net c# dynamic-linq linq-to-sql
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
dynamic dynamic-linq grouping linq
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...
c# dynamic-linq expression-trees linq
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...
c# dynamic-linq linq
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 ...
c# dynamic-linq expression-trees linq wcf
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<...
asp.net c# dynamic-linq linq linq-to-sql
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...
datacontext dynamic-linq linq linq-to-sql vb.net
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 ...
c# dynamic-linq entity-framework linq predicatebuilder
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 ...
dynamic-linq linq-to-entities
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...
c# dynamic-linq lambda repository specification-pattern
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...
c# dynamic-linq linq
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...
.net dynamic-linq namespaces vb.net
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 { ...
.net c# dynamic-linq linq
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...
.net dynamic-linq lambda
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...
.net dynamic-linq expression
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...
.net c# dynamic-linq linq linq-to-sql
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...
dynamic-linq
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...
c# dynamic-linq
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...
c# compiler-errors dynamic-linq linq linq-to-objects
asked by Martin

Page 5 of 23
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

Prime Library

Performance

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

Expression Evaluator

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