How to expose a database from a Web Service?

[MisterT]

Hello,
I have a web service that updates an SQL database thru a web service. I
would like to expose the database table so I can easily add it as a Data
Source in VS 2005 to program the web service client.

Any ideas how to do this?

Thank you,
Tom

[Francois Bonin [C# MVP]]

1) Your web service will need to have a complete set of methods for working
with your database table (retrieval, update , deletion, insertion).

2) You create a class that contains properties representing the fields in
your data table

3) You create a class that will have methods for inserting, deleting,
retrieving and updating the rows in your database table. Those methods will
accept objects of the class created in step 2 as parameters and will be
wrappers around your webservice calls.

4) Within your application, you can use a
System.Web.UI.W ebControls.Obje ctDataSource linked to your classes
(DataObjectType Name property will be the name of the class created in step
2, TypeName property will be the name of the class created in step 3)

You should have a look at ObjectDataSourc e in MSDN for specifics and further
details.

HTH,
Cois

"MisterT" <Mi*****@discus sions.microsoft .comwrote in message
news:73******** *************** ***********@mic rosoft.com...

Hello,
I have a web service that updates an SQL database thru a web service. I
would like to expose the database table so I can easily add it as a Data
Source in VS 2005 to program the web service client.

Any ideas how to do this?

Thank you,
Tom