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 »

$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 »

InitializeService in ADO.NET Data Services

Need to debug an ADO.NET Data Service?
Another interesting point has to do with error handling. The option for error handling is set during InitializeService. If an exception is thrown while InitializeService is being called, we don’t trust whatever was set on the configuration, and instead of the ADO.NET Data Service error handling kicking in, we’ll [...]

Read Full Post »