Dynamic LINQ - Knowledge Base (KB)
447 results in tag: dynamic-linq
dlinq versus ADO.NET Entity Framework
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
Dynamic where clause in LINQ - with column names available at runtime
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
DLINQ- Entities being inserted without .InsertOnSubmit(...)?
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
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
ASP.NET MVC Authorization 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
Building Dynamic LINQ Queries based on Combobox Value
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.
Dynamic LINQ query using an Attribute
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 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
How do I do a Contains() in DLINQ with 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 supply a table name at runtime using LINQ to SQL?
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 - 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
Access Linq result contained in a dynamic class
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 Query or stored procedure to return max value in a stated column
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
LINQ Dynamic Expression API, predicate with DBNull.Value comparison
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
Strange Exception thrown using Dynamic Linq Entity Framework Query
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
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é
How to get Lambda in LINQ to actually 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
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
Is the Specification Pattern obsolete when you can use Dynamic LINQ?
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
Make a dynamic query with Linq using a drop down list selected option in Asp.net MVC
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