Dynamic LINQ - Knowledge Base (KB)
447 results
System.LINQ.Dynamic: Select(" new (...)") into a List<T> (or any other enumerable collection of <T>)
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
Dynamic LINQ API - SQL Convert Function
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
Dynamic LINQ with other databases
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
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
Handle a Dynamic Select With Dyanmic Linq
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 possible to build dynamic LINQ queries to non-strongly type datatables?
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
How to do the following in Dynamic Linq using System.Linq.Dynamic namespace
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
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 JOIN across WCF Data Services
I am prototyping a generic data browser over WCF Data Services....The user can select the entities from a TreeView, thus I cannot hardcode the query result types and have to code the queries (URI or LINQ) dynamically....To offer joins across different Dat...
asked by Peter Meinl
Dynamic query to immediate execute?
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
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 Linq help, different errors depending on object passed as parameter?
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
How dynamic can I make my LINQ To SQL Statements?
I have the need to construct a LINQ To SQL statement at runtime based on input from a user and I can't seem to figure out how to dynamically build the WHERE clause....I have no problem with the following:...string Filters = "<value>FOO</value>"; Where("Fo...
asked by mcass20
Dynamic Linq : is it 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
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
Query File System Info Dynamically using LINQ
I need to be able to return a list of files that meet some dynamic criteria. I've tried to do this using LINQ. ...I've found that it is possible to use dynamic LINQ using the System.Linq.Dynamic namespace that it is mentioned in ...Scott Gu's Blog.......B...
asked by Martin
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
Create new Linq SelectMany extension method
I am using Linq.Dynamic. I have already added another SelectMany extension to all for creating a new anonymous object with the data. But, I have ran into another issue that I can not seem to solve. ...I want to have extension method chaining as follows, b...
asked by Dan
LINQ: Dynamic .Where() Statements
Scenario...: I have a list and three search filters. Something like:...ResultList = OriginalList.Where(filter1).Where(filter2).Where(filter3); ...Question...: Can I update filter 3, and then have the ResultList update, without having LINQ running filter1...
asked by Bodekaer
Page 2 of 23