Webservice fake SQL server

[Jaco Vosloo]

Hi

Is it possible to create a web service in such a way that
a consumer can use a SQLDataAdapter to connect to the web
service? The web service will be connecting to a SQL
server using its own DataAdapter. It can return a dataset.
The purpose of this is to function as some kind of
advanced stored procedure.

I have been searching the net for some months now, and
can't find anything like that.

Thanks for any advice

[Tom Vande Stouwe MCSD.net]

You could do that, but the 'protocol' will not be a standard dataconnection.
you could hack an XML reader on the client end since all data returned by
the webservice is XML. Just post the request, and read the XML stream result
and parse it.

Tom

==========================================
= Tom Vande Stouwe MCSD.net, MCAD.net, MCP
= 45Wallstreet.com (www.45wallstreet.com)
= (803)-345-5001
==========================================
= If you are not making any mistakes
.= ..you are not trying hard enough.
==========================================
"Jaco Vosloo" <jpvo...@webmail.co.za> wrote in message
news:096301c35028$15dced60$a101...@phx.gbl...

[Jaco Vosloo]

The purpose of this question is for design time
development.

I am trying to build backend webservices that will allow
the GUI developers to have a simple way of formatting
their Datagrids.
As far as I understand, a DataGrid requires a typed
Dataset to display the columns during design time.
The only way I know of easily & automatically creating a
typed Dataset is to have it generated using a DataAdapter.
So my conclusion is that I need to find a way to connect a
DataAdapter to the webservice.

I suppose I could go write my own webservice data provider.
But that seems like a lot of unnecessary work.

Thanks a lot for any advice.

Jacobus Vosloo
Application integrator for .Net
Daimlerchrysler South Africa
Cell: +2783 361 3203

>.
>

[Dino Chiesa [MSFT]]

see comments inline (below)

"Jaco Vosloo" <jpvo...@webmail.co.za> wrote in message

news:0ac801c35107$39e25120$a401...@phx.gbl...

> The purpose of this question is for design time
> development.
>
> I am trying to build backend webservices that will allow
> the GUI developers to have a simple way of formatting
> their Datagrids.
> As far as I understand, a DataGrid requires a typed
> Dataset to display the columns during design time.

hmm, ok.

> The only way I know of easily & automatically creating a
> typed Dataset is to have it generated using a DataAdapter.

I don't think so. It should be pretty simple to instantiate a typed dataset
and fill it with data from an array of objects.

> So my conclusion is that I need to find a way to connect a
> DataAdapter to the webservice.
>

Why couldn't you just return a typed dataset over the wire from a standard
webservice?

[Jaco Vosloo]

Thanks for the reply.

You said:
>Why couldn't you just return a typed dataset over the
wire from a standard
>webservice?

I can do that, but will that help me in design time?
e.g. how do I get the design time grid to display the
columns?

Thanks again

>.
>

[Darren Mombourquette]

I "think" in order to bind to a typed dataset at design time you
acually need the .xsd, .xsx, as .cs files in the current project. Just
having the type information in your webservice proxy or another
assembly won't allow you to do it.

So your only solution really is to create a project that contains
nothing but data types in it that would be used by your client apps
and webservices ... put it in a common Source Control repository. Then
have the developers use the "link file" capability of vs.net to add
the three files to their projects.
To do this just right click on your project and select add existing
item... then browse to your files... highlight the files but rather
than selecting open click on the drop down on the open button and you
will see "link files".. this will just reference the files on disk
rather than copying them into your project.
Just be carefull becuase if you are using VSS integration in the IDE
it will NOT do a get latest on these files automatically. You have to
get latest from the VSS IDE directly (or whatever source control
provider you are using).

Or you could create some really groovy VS.NET addin that would call a
webservice... get the return type and create the required files on the
fly and add them to the project.. but that sounds like alot of work
now doesn't it :)

Cheers
Darren Mombourquette

"Jaco Vosloo" <jpvo...@webmail.co.za> wrote in message news:<0b8501c351eb$5dd59a30$a501...@phx.gbl>...