Set Based Operations in Ado.net Data Services

» Set Based Operations in Ado.net Data Services

» Set Based Operations in Ado.net Data Services — Thu, 17 Jul 2008 14:20:42 GMT

PingBack from http://net.blogfeedsworld.com/?p=22343

Building LINQ Expressions for ADO.NET Data Services

Marcelo's WebLog — Fri, 18 Jul 2008 01:49:32 GMT

While the 'LINQ Ninja' moniker is something that Phani completely made up on the spot and I actively

re: Set Based Operations in Ado.net Data Services

Joe — Thu, 02 Oct 2008 10:32:53 GMT

Shouldn't it be possible to pass in the property to be filtered as an expression rather than a string, so that you retain intellisense support and compile-time validation? As in:

nwContext.Customers.IsIn<Customers>(citiesIWillVisit, (c) => c.City);

The extension method signature would become:

public static IQueryable<T> IsIn<T>(this IQueryable<T> query, IEnumerable Set, Expression<Func<T, object>> Left)

(Probably better to use IQueryable rather than DataServiceQuery, just in case you wanted to re-use this with another Linq provider that doesn't support Set-based 'In' clauses)

And in the method you'd do:

ParameterExpression param = Left.Parameters.Single();

to bind your outer filter parameter with the inner property selector.

re: Set Based Operations in Ado.net Data Services

PhaniRajuYN — Thu, 02 Oct 2008 19:29:43 GMT

Hi Joe,

That sounds like a neat idea.

I shall try your suggestion and update the code snippet later

Reporting with ADO.NET Data Services and Telerik Report Viewer

With Great Power comes Great Response.write("Ability") — Mon, 04 May 2009 08:00:12 GMT

Telerik has a range of controls that work with ADO.NET Data Services as the data source . Take a look

re: Set Based Operations in Ado.net Data Services

ibebbs — Sun, 24 May 2009 17:51:29 GMT

Hi,

Is there any way to extend the above method to use a Contains expression (ultimately translating to a 'substringof' query) instead of an Equals?

I am able to generate the expression I want by manually building the query string - enumerate around the enumerable set or'ing together 'substringof('{0}', property)' - but can't seem to generate the expression that equates to this query.

Cheers,

Ian

Set Based Operations in Ado.net Data Services Part II

With Great Power comes Great Response.write("Ability") — Wed, 27 May 2009 08:59:13 GMT

As an extension to explained in the last blog post dealing with Set based filter operations in our client

re: Set Based Operations in Ado.net Data Services

Scott Burkhalter — Sat, 08 Aug 2009 09:19:40 GMT

Very cool extension method, thanks for sharing!

Noticed a small typo:

ParameterExpression param = propertyExpression.Paramters.Single();

should read:

ParameterExpression param = propertyExpression.Parameters.Single();

re: Set Based Operations in Ado.net Data Services

PhaniRajuYN — Sat, 08 Aug 2009 19:54:56 GMT

Fixed, thanks for correcting this Scott!