“Too many table names in the query.” ADO.NET Data Services

Another day, another Data Services issue. This time the error message was “Too many table names in the query. The maximum allowable is 256.” Turns out this is caused by my organization’s use of Sql Server 2005 rather than Sql Server 2008. Unfortunately, it’s not very feasible to reduce the number of tables being used [...]

Read Full Post »

Does LINQ Support Composable “OR Queries”? (NOPE!)

Seems like any direction I turn, if I try to get very clever I hit a wall with ADO.NET Data Services.
It looks like Linq to ADO.Net Data Services doesn’t support expressions/predicate builder (see comments on Cameron MacFarland’s post for details), so this wouldn’t work for this situation – might just have to wait for Linq [...]

Read Full Post »

SqlCommand Timeout Exception with ADO.Net Data Services

When my ADO.NET Data Services web service started throwing SqlCommand timeout messages I hit up Google and finally found a post in German(?) that pointed me in the right direction. The problem seems to be the Entity Framework Connection CommandTimeout, which can be easily modified overloading the OnStartProcessingRequest event.
When working with the ADO.NET Data Services [...]

Read Full Post »

How to Make Include Really Include

Find yourself just needing the darn data rather wasting time with lazy this and that? Give .Include (or .Expand I believe fora data service query) a try.
If you want to do eager loading with the Entity Framework it is generally really easy, you simply write something like this:
var results = from post in ctx.Posts.Include(“Comments”)
where post.Author.EmailAddress [...]

Read Full Post »

Querying using DataServiceContext and DataServiceQuery

Quick overview of the alternatives for querying using ado.net data services.
Use LINQ to ADO.Net Data Services to query the service. Again, since the DataServiceQuery is an IQueryable, you can use LINQ syntax to query it:
var query = (from p in svc.Posts
where p.PostID > 3
orderby p.PublishDate
select p).Skip(2).Take(2);
via Querying using DataServiceContext and DataServiceQuery – linyusen的专栏 – CSDN博客.

Read Full Post »

Debugging ADO.NET Data Services

My service is broke-a$….er I mean my friend is having issues with his code and this is the link I sent him.
By default, Data Services don’t return information on what’s wrong when you try to execute some code, for example an update, against it. This is understandable: if you open up a data service on [...]

Read Full Post »

$filter Query Option in ADO.NET Data Services

ADO.NET Data Services provides filtering options for free.
What can go in a $filter? The most basic thing to do is to test properties of the resources we’re returning, which you can access simply by name, like we have done above. Literals for things like strings and numbers use the same syntax as in the key [...]

Read Full Post »