Tag Archives: WCF Data Services

Refreshing Entities in WCF Data Services–Handling Database Triggers

Posted on August 7, 2011 by KJRB

WCF Data Service Context is very smart when it comes to loading entities the data source. It attempts to do it just once. This is to avoid problems related to requesting the same data multiple times, which is bad in … Continue reading →

Posted in .NET, Database, Triggers, WCF Data Services | Tagged , , , | Comments Off

Reusable WCF Service Data Access Layer for WP7, MonoTouch and Mono for Android

Posted on June 4, 2011 by KJRB

This is a quick overview of experimentation with creating a reusable WCF Service Data Access Layer for Cross-Platform Mobile Development effort. For more details see my article here. The Challenge Build WCF Data Services based data access layer that can … Continue reading →

Posted in Mono, Mono for Android, MonoTouch, WCF Data Services, WP7 | Tagged , , , , | Comments Off

oData and Stored Procedures aka Service Operations

Posted on May 5, 2011 by KJRB

If you work with WCF Data Services, at some point, you will probably need to call a stored procedure to return result of a complex query. If you wonder how to wrap a call to stored procedure into a WCF … Continue reading →

Posted in .NET, WCF Data Services | Tagged , | Comments Off

WCF Data Services Cheat Sheet

Posted on April 26, 2011 by KJRB

This is the result of my tiny research about translating LINQ to REST into oData URI Conventions and finally into T-SQL. Event though I knew what I needed on the T-SQL side,  I was not sure which LINQ statement would … Continue reading →

Posted in .NET, WCF Data Services | Tagged , | 2 Comments

DTO from Stored Procedure – Code Snippet

Posted on February 28, 2011 by KJRB

One of my current projects uses data retrieved from a linked server via a stored procedure. I can look at the queries being executed but I cannot see the underlying storage tables. I wrote this little piece of code to … Continue reading →

Posted in WCF Data Services | Tagged | Comments Off

WCF Data Services, POCOs and pitfalls of “DataServiceKey”.

Posted on February 21, 2011 by KJRB

WCF Data Services, POCOs and pitfalls of “DataServiceKey”.
Be mindful when choosing and populating “DataServiceKey” attribute adorned field on your POCOs. Continue reading →

Posted in WCF Data Services | Tagged | Comments Off

Error when deleting WCF Services entity when WebDAV enabled on the server.

Posted on February 6, 2011 by KJRB

WCF Data Services in IIS 7.5 (Server 2008 R2) – Error when deleting entity when WebDAV enabled on the server.

Continue reading →

Posted in WCF Data Services | Tagged , | 1 Comment