Dynamic LINQ - Knowledge Base (KB)
306 results in tag: c#
Dynamic LINQ with direct user input, any dangers?
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 to name fields using Dynamic Linq?
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 - Setting orderby expression type 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
Dynamic LINQ on a collection?
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é
Null Reference Exception in a Dynamic LINQ Expression
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
dynamically create lambdas expressions + 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
Dynamic where clause in LINQ to Objects
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
Dynamic Linq Library Help
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
dynamic query using expression tree
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
How can I use dynamic LINQ in my asp.net project?
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
How to create 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
Dynamic LINQ GroupBy Multiple 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
Dynamic Linq: How to specify the StringComparison type?
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
Linq to SQL - Multiple where clauses at runtime
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
Filtering DataGrid, MVVM, 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
Executing DynamicExpression with unknown types
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 to use Dynamic LINQ (System.Linq.Dynamic) for 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
Dynamic LINQ - Is There A .NET 4 Version?
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
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
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
Page 1 of 16