Dynamic LINQ - Knowledge Base (KB)
306 results in tag: c#
Any risks with dynamic LINQ with direct user input?
I have a table in a ASP.NET MVC application that I want to be sortable (serverside) and filterable using AJAX. I wanted it to be fairly easy to use in other places and didn't feel like hardcoding the sorting and filtering into query expressions so I looke...
asked by JulianR
How can I use Dynamic Linq to name fields?
I have a huge query that is being made dynamically, but I want the select statement to not output the column names, buut custom values. FOr example, if I am doing a normal Linq query, I can do something like this:...var v = from p in db.items select new ...
asked by naspinski
Dynamic Linq allows you to change the order of expressions at runtime.
I'm using dynamic Linq and have the where clauses working. Now I'm looking to add orderby clauses but am having a problem being able to set the type of the dynamic expression. Below is working code that I have:...class MyClass { public string Owner; ...
asked by sipwiz
On a collection, dynamic LINQ?
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...
asked by Simon Dugré
In a dynamic LINQ expression, a Null Reference Exception occurs.
I am using the Dynamic Linq Library / Sample from Microsoft to do ordering on a list. So for example I have the following C# code:... myGrid.DataSource=repository.GetWidgetList() .OrderBy(sortField + " " + sortDirection).ToList(); ...I have a c...
asked by JoshBerke
lambdas expressions generated dynamically + linq + OrderByDescending
how can I create a dynamic lambda expression to pass to use in my orderby function inside linq?...I basically want transform ...queryResults.OrderByDescending();... in ...queryResults.OrderByDescending(myCustomGeneratedLambdaExp);... where ...myCustomGene...
asked by byte_slave
LINQ to Objects has a dynamic where clause.
I know there are a lot of examples of this on the web, but I can't seem to get this to work....Let me try to set this up, I have a list of custom objects that I need to have limited on a range of values. ...I have a sort variable that changes based on so...
asked by Clarence Klopfstein
Help with the Dynamic Linq Library
I have the following class:...public class Item { public Dictionary<string, string> Data { get; set; } } ...and a list of it:...List<Item> items; ...I need to filter and order this list dynamically using SQL-Like strings. The c...
asked by Alon Gubkin
expressive tree-based dynamic query
I have a form in which the user will choose the following from dropdown lists:... table_name columnName_to_sort_by columnName_to_search_in ...The user shall enter ...Search_text... in a text box...The form shall draw data from many tables. I want to ...
asked by user375492
In my asp.net project, how can I utilize dynamic LINQ?
How can I use dynamic LINQ in Visual Studio 2008?...I'm trying to use ...using System.linq.Dynamic ...but there is no intellisense. How can I use it?
asked by Penguen
What is the best way to make a dynamic linq to entities query?
Now this is probably really easy but being the tool that I am, I'm not sure the best way to attack this problem....I have a DAL and a load of methods using EF that populate drop down lists in a UI. i.e. material, source....From these, I want the user to ...
asked by Ricardo Deano
LINQ Dynamic Group Using Several 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...
asked by Daniel Coffman
How can I define the StringComparison type in Dynamic Linq?
I'm working on doing some custom filtering and sorting of a dataset, based on a collection of sort fields sent from the client browser, and am using Dynamic Linq to achieve (most of) the desired effect. Where I'm running into a problem is when I try to s...
asked by rswafford
Multiple where clauses at runtime with Linq to SQL
I am trying to accomplish this but only my first where clause is getting used when the query runs....This needs to for for .Net 3.5 so the WhereIf in 4.0 is not usable....var query = from tb in dataContext.TableOne where tb.DateTimeCreated >= from...
asked by SetiSeeker
DataGrid Filtering, MVVM, and Dynamic LINQ
How can I filter my DataGrid items like MS Access filter works (just select by mouse some part of cell and press "Filter" button)?...I have ViewModel MyViewModel with 2 Commands (Filter and ClearFilter) and ObservableCollection I have Model with method G...
asked by Lari13
Using unknown types in DynamicExpression
If anyone is very familar with the Linq.Dynamic namespace I could use some help -- couldn't find any indepth resources on the internet....Basically I'm using DynamicExpression.ParseLambda to create an expression where the type is not known at compile time...
asked by sean
How can I utilize System.Linq.Dynamic for the LIKE operation?
Can any body tell me how can I use a LIKE operator using ...System.Linq.Dynamic...?...I need to add more than one ...LIKE... expression in my dynamic ...where query.../* var query = db.Customers. Where("CityName Like @0 or CityName Like @1", "London", "US...
asked by Kiarash
Is There A.NET 4 Version Of Dynamic LINQ?
I'm looking to use LINQ for some searching routines and wanted to have some dynamic where clauses. So, for example, if a user wants to search by city or search by state, I would have a dynamic LINQ Where<> call instead of creating two strongly typed LINQ...
asked by David Hoerster
Select and change a column value in a LINQ resultset dynamically.
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
allow the user to create dynamic expressions using the 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
Page 1 of 16