CODEWITHSUNDEEP
c#asp.net.netwcfwcf-data-services
ryudice
ryudice

Reputation: 37406

automatically exposing database tables through web services

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.

Upvotes: 3

Views: 1019

Answers (3)

RPM1984
RPM1984

Reputation: 73123

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

Upvotes: 2

marc_s
marc_s

Reputation: 755033

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.

Upvotes: 3

Roman
Roman

Reputation: 20256

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.

Upvotes: 1

Related Questions