Dynamic LINQ - Knowledge Base (KB)
447 results
OrderBy with Dynamic Linq and one to many relationship in EF
I'd like to implement a module for filtering and paging. I understand that to suceed I had to use Dynamic Linq or Reflection, so I started trying to make it work .. but since the field that contains the text to be filtered in a one to many relationship EF...
asked by Julien
Multichoice fields with dynamic linq
I'm making a SP2010 page where user can filter items by their phase (It's a multichoice field). For performance reasons and the nature of the filters I had to resort to System.Linq.Dynamic to make this query....I've tried the following (this is not real c...
asked by jpiolho
Converting Expression<T, bool> to String
I need a way to recreate dynamically generated reports at some point in the future. Long story short, I need to store a specific linq query (different for each report) into database and then execute the query with dynamic Linq later on....This is all good...
asked by user302845
Dynamic linq against entity not in dbml
I have been asked to investigate the usefulness of linq to sql for a reporting application we are building. Our reporting table is a sql server wide table with many thousands of columns of different types (String1-500, Int1-500 etc). It holds the results ...
asked by madcapnmckay
JSON results are returned in a different order than expected
I am following ...Phil Haack's example on using jQuery Grid with ASP.NET MVC.... I have it working and it works well...except for one minor problem. When I sort the columns by something other than the ID, the JSON data returned from the server is very...w...
asked by JasCav
How Do I step through an IList one field at a time?
I'm using the Dynamic LINQ library code sample to dynamically return some data. The number of columns I'm returning is variable depending on user input. I'm enumerating the IQueryable into an IList. ...What I need to do is step through the Ilist one field...
asked by Neberu
How does DynamicQueryable support the Array operator?
I have been using the DynamicQueryable Linq extensions featured in Scott Guthrie's ...blog post.......The documentation has a table of supported operators. One of the primary operators is the following:...x[…]... Array or indexer access. Multi-dimens...
asked by jedatu
How can I dynamically select my Table at runtime with Dynamic LINQ
I'm developing an application to allow engineers to conduct simple single table/view queries against our databases by selecting Database, Table, Fields....I get how to use the Dynamic LINQ Library Sample to provide for dynamically selecting the Select, Wh...
asked by Neberu
LINQ: Build a where clause at runtime to include ORs ( || )?
I need to build a where clause at runtime but i need to do an OR with the where clause. Is this possible .. Let me explain.....here my code..., basically "filter" is a enum Bitwise, son hence filter could be equal to more than 1 of the following.. Hence i...
asked by Martin
LINQ Dynamic Query Library
I am building an ASP.Net MVC 3 application with Entity Framework 4. When the two pieces of code below are executed, both variables (query1 and query2) have a return type of...System.Data.Objects.ObjectQuery<Asset.Model.Equipment> ...Query1 uses a direct i...
asked by tcode
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
Dynamic Linq Search Expression on Navigation Properties
We are building dynamic search expressions using the Dynamic Linq library. We have run into an issue with how to construct a lamba expression using the dynamic linq library for navigation properties that have a one to many relationship....We have the foll...
asked by Blane Bunderson
LINQ DynamicLibrary: How to extract count and list from IQueryable
I have started experimenting a bit with the LINQ DynamicLibrary. I am trying to replace a bunch of LINQ statements with a few or just one Dynamic LINQ query. My existing static query is as follows:...private List<TicketChartData> GenerateImpl(IList<Servic...
asked by Sudarshan chandan
Extension Method To Take A Dynamically Built Search Expression?
I think we are basically looking for a extension method that could take in an IQueryable and return an IQueryable based on an entire query statement and not just the where statement....Example of what we would like for a Search Method:...IRepository<Perso...
asked by Blane Bunderson
Dynamic LINQ GroupBy question
I am using Dyanmic LINQ from the VS2010 code samples as I am trying to create a LINQ groupby expression. I want to allow the user the possibility to select at runtime the properties to group on/by as well as the period of grouping (year, quarter, month)....
asked by Stefan Szasz
Need help with a LINQ Query using the Dynamic LINQ Library
Forgive my ignorance on this. I have this LINQ Query: Dim ngBikersDataContext As New CarBikeWalkDataContext...bikersList = (From c In ngBikersDataContext.Reg_Bikers _ Order By c.L_Name _ Select New Bikers() ...
asked by Matt Porterfield
Dynamic Linq - no property or field exists in type 'datarow'
I am using Northwind Customers Table where I fill the dataset and get the datatable....I am trying to use dynamic linq and want to select columnName dynamically...var qry = MyDataTable.AsEnumerable().AsQueryable().Select("new(Country)"); ...Right now I ha...
asked by Graci
Can I create a LINQ-to-Entity query on non-Entity Member fields
I have an Entity class that I have extended using the ...partial class... syntax to have some derived properties. I would like to perform a query using the ...IQueryable<T>... interface that uses the information from these fields, but I currently get an ...
asked by Lucas
How do I perform a distinct on a column I am selecting dynamically?
I am using dynamic linq and selecting a column dynamically. I need to do a distinct on this. How could I do this?...var qry = tbl.AsEnumerable().AsQueryable() .Select("new(it[\"" + this.UniqueName + "\"] .ToString() as " + this.U...
asked by Graci
LINQ - How to do partial searches on multiple criteria using NHibernate.LINQ
I have a search page where a user can enter multiple cities seperated by a comma and we need to get all the real estate properties where the city is one that is entered in the search criteria. For instance the user will enter something like this...cities ...
asked by user629161
Page 4 of 23