Dynamic LINQ - Knowledge Base (KB)
447 results
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 ...
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...
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? ...++++++++++++++++++++++++++++++++++++++++++++...
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 ...
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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) {...
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...
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...
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);....
asked by arefinsami
Page 8 of 23