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:

how I can get insert method more flexible using dynamic linq?

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

How to build a nested query with the dynamic LINQ library

How can I build the following LINQ query with the Dynamic Linq library (System.Linq.Dynamic)?...var roles = rolesCollection.Where(r => r.AssignedUsers.Where(u => u.Name.FirstName == "Patrick").Count() > 0); ...rolesCollection and AssignedUsers are collect...
.net-3.5 c# dynamic-linq linq
asked by Patrick Koorevaar

using variables in a dynamic linq query

I am using Linq to Entities and have added the using stmt of ...using System.Linq.Dynamic;... My goal is to pass in the ...whereClause... variable into the emailList query (see screen shot). ...Any thoughts? ...++++++++++++++++++++++++++++++++++++++++++++...
c# dynamic-linq linq
asked by blub

What has happened to Dynamic LINQ?

I have a need to use dynamic LINQ where I can use variables in place of field names. Now I have done some googling and found that there is a sample for VS2008 where we can get this functionality. My question is what has happened to this DLINQ ? It's been ...
dynamic-linq
asked by kurry

C# Dynamic LINQ: Select with Sum on dictionary indexer

I'm using dynamic LINQ to create a groupby and select on the fly. My items are key/value collections (dictionaries) so they contain no properties (it's a design requirement and can't be changed). I was able to solve the groupby part in ...another question...
c# dynamic-linq linq select
asked by sean.net

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

How to find the source property based on the name of a flattened property with ValueInjecter

This is a counterpart to ...same question (but with AutoMapper).... I use ...ValueInjecter... and am interested if there is a solution....Simplified code example:...// get a list of viewModels for the grid. // NOTE: sort parameter is flattened property of...
c# dynamic-linq valueinjecter
asked by zam6ak

How to extend this LINQ List<>.Contains to work with any Property using Reflection?

I have the following snippet that I currently use to run a .Contains() with a list of Ids passed as a comma separated list from users. This code works perfectly and the data is filtered exactly as I want it to be:...// Handle id in() statements explicitly...
dynamic-linq linq nhibernate reflection
asked by mikeschuld

dynamic linq expression using select in .NET

I want to dynamically add .Select statements, but the compiler will only allow me to build these statements inside the current scope. I am aware of linqkit, which could be a solution, but i dont want to add any external functionallity. How do i avoid this...
.net c# dynamic-linq lambda linq
asked by Zeezer

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

Dynamic Linq Order By user defined sequence

I have dynamic linq query with OrderBy. ... .AsQueryable().OrderBy("FullName", asc) ...After sorting by FullName, I need to sort by status (something like ThenBy()). Status may have vales e.g. "A", "B", "C", "D" But I need to sort in following sequence "B...
dynamic-linq linq sorting sql-order-by
asked by Roman

Dynamic Linq .Select() - How to handle certain null values

I am using System.Linq.Dynamic for a project that requires the user to choose which properties will be selected/projected at runtime....So, I have a query like this:...var query = db.Users.Select("New(UserId, Username, Groups.Max(DateInserted) AS DateInse...
dynamic-linq linq-to-entities
asked by Fred Wilson

Dynamic Linq searching multiple columns of multiple types including nullable types

I need select my columns dynamically and I do not know the types of the columns ahead of time. I've got a string and I want to search all the columns if they contain that string, converting non-string into string for the comparison....string format = "Con...
c# dynamic-linq expression-trees linq
asked by Kyle

LINQ Dynamic query nullable field

Suppose an SQL table 'employees' (containing a nullable datetime field called 'endDate')...static LINQ:...dim result = db.employees.where(function(c) not(c.endDate.hasValue)) ...Works perfectly!...dynamic LINQ:...dim result = db.employees.where("it.endD...
asp.net dynamic-linq vb.net
asked by zeSkunk

Linq to NHibernate and Dynamic LINQ - query caching not working

I have problem with the NHibernate's second level cache. When I use query:... var items1 = Session.Query<Row>() .Cacheable(); .Fetch(x => x.Field) .OrderBy(x => x.Field.Value) .ToList(); ...Everything...
dynamic-linq linq linq-to-nhibernate nhibernate
asked by cryss

Issue with dynamic LINQ queries containing brackets

I'm using the Dynamic Linq Library (...this one...) in my .NET MVC application to query a SQL Server database. It's all working fine so far....However, the Dynamic Linq Library gives an "Expression expected" error whenever I use square brackets to designa...
.net dynamic-linq linq sql sql-server
asked by Chris

Using Linq DynamicQuerable for a Not IN sql type operation

I am using the Linq DynamicQuerable code. I have an array of integers and a string representing the field I want to use as the excluding filter....For example...IQuerable GetItemsWithoutExcluded(IQuerable qry, string primaryKey, List<int> excludedItems) {...
c# dynamic-linq linq
asked by Kenoyer130

Scott Gu Dynamic Linq Convert Datetime to ShortDatetime

I am using the Scott Gu Dynamic ...Linq... class and I am trying to convert a datetime to return a short datetime before databinding the result set to a gridview in ...ASP.net.... Now, I know that I can go through the gridview row databound event and che...
asp.net c# dynamic-linq linq tsql
asked by EvanGWatkins

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...
.net dynamic-linq entity-framework linq linq-to-entities
asked by Cragly

Join multiple table and bind into a single Listview using C# .net

I got three tables to join named Books, Borrowers and Transactions. The database scheme is as below:...Books(BookID,BookName,ISBN);...Borrowers(BorrowerID,BorrowerName,BorrowerLevel);...Transactions(TransactionID,BorrowerID,BookID,BorrowDate,ReturnDate);....
.net c# dynamic-linq linq xaml
asked by arefinsami

Page 8 of 23
  • ««
  • «
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • …
  • »
  • »»

Prime Library

Performance

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

Expression Evaluator

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