tags:

views:

35

answers:

3

Is there any framework or tool to generate web services (WCF) access to all the non transactional tables in my database? something like asp.net dynamic data but with web services, I need to do this for homologation with other systems.

+1  A: 

Maybe WCF RIA Services? I haven't used it, but from what I read it sounds like it'll be close. Although emphasis is on Silverlight, it will play nice with other endpoints.

R0MANARMY
+2  A: 

Check out WCF Data Services - you can easily create a model of your database (Entity Framework, Linq-to-SQL, custom) and expose all tables and their contents via a WCF REST interface to any HTTP browser.

marc_s
+1  A: 

Yep - WCF Data Services is the way to go. Also known as "OData".

Check out this MIX10 Video (free) by Pablo Castro (MS Architect) who covers it: http://live.visitmix.com/MIX10/Sessions/FT12

RPM1984