Dynamic LINQ - Knowledge Base (KB)
312 results in tag: linq
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
Using Combobox Values to Create Dynamic LINQ Queries
I have a combo box in Silverlight. It has a collection of values built out of the properties of one of my LINQ-to-SQL objects (ie Name, Address, Age, etc...). I would like to filter my results based off the value selected in a combo box. ...Example: Say...
asked by Steve G.
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
Use a dynamic class to access a Linq result.
I'm using DbLinq which should be the equivalent of Linq2SQL for this question. I'm need to generate a Linq2SQL query where I specify the columns I want returned at runtime. I can achieve that using the Dynamic Linq extension methods but I can't work out h...
asked by sipwiz
Predicate with DBNull.Value comparison in LINQ Dynamic Expression API
I have an issue using the Dynamic Expression API. I cannot seem to compare a DataTable field against DBNull.Value. The API is supposed to be able to "support static field or static property access. Any public field or property can be accessed.". Howeve...
asked by Richard Anthony Hein
Using Dynamic Linq Entity Framework Query, an unusual exception was thrown.
I have a gallery entity framework class,and I'm attempting to use the Dynamic Linq Library posted on ScottGu's blog to query the entity set. The failing line of code reads:...return context.Galleries.OrderBy(sidx + " " + sord).Skip(page * rows).Take(rows...
asked by midas06
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
Is the Specification Pattern outdated now that Dynamic LINQ is available?
Wikipedia... states that the Specification Pattern is where business logic can be recombined by chaining the business logic together using boolean logic. With respect to selecting filtering objects from lists or collections it seems to me that Dynamic LI...
asked by David Robbins
Select(" new (...)") into a ListT> (or any other enumerable collection of T>) using System.LINQ.Dynamic.
Say I have a DataTable with four columns, Company (string), Fund (string), State (string), Value(double):... table1.Rows.Add("Company 1","Fund 1","NY",100)); table1.Rows.Add("Company 2","Fund 1","CA",200)); table1.Rows.Add("Company 3","Fund 1",...
asked by Brad
SQL Convert Function in the Dynamic LINQ API
I'm trying to use a Dynamic LINQ Query to query a SQL database, and in the Where clause I need to evaluate an '=' condition with a field that is of type TEXT....Right now, I've got this:...var result = DBCon.PcInValue .Where(String.Format("InputName = ...
asked by Overhed
Other databases using dynamic LINQ
Are there any free (gratis) providers for databases other MS SQL (e.g. MySQL or SQLite) that work with LINQ and support dynamic SQL query generation? E.g. ...table.Count()... generates something like ...SELECT COUNT(*) FROM table... and doesn't first load...
asked by svick
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
With Dyanmic Linq, you can handle a dynamic select.
I am using the Dynamic Linq Library that Scott Guthrie describes ...here.... ...Scott Guthrie's examples are great and I have used the dynamic Where statements quite a bit. ...Now, however, I am faced with a situation where I need to use the dynamic se...
asked by CleverPatrick
Is it feasible to create dynamic LINQ queries for datatables that aren't strongly typed?
Using ...LINQ..., I've been trying to use the System.Linq.Dynamic library in order to query a datatable dynamically. The problem is that it's not strongly typed, and the extension method for select is expecting an IEnumerable as the source....Is there a ...
asked by Raúl Roa
Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq
I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, ...
asked by emem
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
Instant execution of a dynamic query?
I am using the MSDN Dynamic linq to sql package. It allows using strings for queries....But, the returned type is an ...IQueryable... and not an ...IQueryable<T>.... I do not have the ...ToList()... method....How can I this immediate execute without manua...
asked by Curtis White
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
Different failures based on the object supplied as a parameter when using Dynamic Linq?
I have an entityDao that is inherbited by everyone of my objectDaos. I am using Dynamic Linq and trying to get some generic queries to work....I have the following code in my generic method in my EntityDao :...public abstract class EntityDao<Implementatio...
asked by SventoryMang
Is Dynamic Linq stable?
Dynamic Linq... is provided as a sample for VS2008, not as a "real" project (no official site, no support, no issue tracking, no new releases...)....So I was wondering, how reliable is it ? Is it suitable for production use ?
asked by Thomas Levesque
Page 1 of 16