knowledge Base | 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.

ado.net dynamic-linq web-applications

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...

.net dynamic-linq linq-to-sql

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...

dynamic-linq insertonsubmit linq-to-sql submitchanges

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...

c# dynamic-linq linq sql-injection

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...

asp.net-mvc attributes dynamic-linq linq-to-sql reflection

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...

dynamic-linq linq linq-to-sql silverlight

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...

dynamic-linq

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 ...

asp.net c# dynamic dynamic-linq linq

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...

c# dynamic-linq

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...

dynamic-linq linq-to-sql

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; ...

c# dynamic-linq

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...

c# dynamic-linq linq linq-to-sql

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 ...

dynamic-linq linq-to-sql stored-procedures

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...

datatable dynamic dynamic-linq expression linq

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...

dynamic-linq entity-framework linq

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...

asp.net c# dynamic-linq entity-framework

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...

dynamic-linq linq-to-objects vb.net

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...

c# dynamic-linq linq

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...

dynamic-linq linq specification-pattern

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...

asp.net-mvc dynamic-linq linq-to-sql