Dynamic LINQ - Knowledge Base (KB)
447 results in tag: dynamic-linq
ADO.NET Entity Framework vs. dlinq
I am about to finalize the design of my webapplication, i am building it as an n-tier architecture and i am posed with the question of using DLinq vs EFM. I would appreciate if someone could give me some expert advice on it.
asked by Addi
Column names are provided at runtime in LINQ's dynamic where clause.
Disclaimer: I've solved the problem using Expressions from System.Linq.Expressions, but I'm still looking for a better/easier way....Consider the following situation :...var query = from c in db.Customers where (c.ContactFirstName.Contains("Black...
asked by sandesh247
Entities are being injected without using.InsertOnSubmit(...) in DLINQ?
I ran into an interesting problem while using DLINQ. When I instantiate an entity, calling .SubmitChanges() on the DataContext will insert a new row into the database - without having ever called .Insert[All]OnSubmit(...)....//Code sample: Data.NetServic...
asked by Charles
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
Authorization in ASP.NET MVC based on role membership or data relation (ownership)
I'd like to extend the AuthorizeAttribute in ASP.NET MVC so that it supports the concept of a user's authorization being based on their role membership OR "ownership" of the data in question. I'm using LINQ2SQL for data access. There is a similar question...
asked by tvanfosson
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.
Attribute-based dynamic LINQ query
I have had some success getting the MSFT Dynamic Linq stuff to work, but now I need to create a "Where" clause that includes an Attribute....The error I get is "No applicable aggregate method 'First' exists"...Here is my code:...where = "Element(XName.Get...
asked by Blaine
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
How do I conduct a DLINQ Contains() on a list of items?
I want to build a dlinq query that checks to see if a title has any number of items in it. I know you can do ....Contains()... with a list, but I need to check if the title contains any of the items, not if the items contain part of the title. For example...
asked by Matthew Kruskamp
How can I use LINQ to SQL to provide a table name at runtime?
I have to use LINQ to SQL and along with it a pure SQL classic query. And this SQL query has the Table from where my data will be generated, but I will not know this Table previously. It will be known in compile time....So how can I make LINQ understand f...
asked by AndreMiranda
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
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
LINQ Return the maximum value in a specified column using a query or stored procedure.
Table like ...datetime a1 b1 x2 ... 07-01-2009 13:10 8 9 10 07-01-2009 13:11 8 8 2 07-01-2009 13:12 9 1 1 ...1 row per second for a whole day (=86400 rows); ~40 columns; all same format... I'm looking for a ...
asked by user132322
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
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é
How can I make Lambda in LINQ filter for dynamic LINQ?
Example-I have a person class ...Public Class Person Private _fname As String Public Property Fname() As String Get Return _fname End Get Set(ByVal value As String) _fname = value End Set End Property Private _lname As Str...
asked by Eric
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
In Asp.net MVC, create a dynamic query using Linq and a drop down list chosen option.
I'm trying to accomplish this with Linq to Sql and Asp.Net MVC: ...I have a Drop Down List with options Country, City and State. And beside it, there is a textbox. So, an user will, for instance, select City and will type "new york city" in the textbox an...
asked by AndreMiranda
Page 1 of 23