Is this viable method - returning DataSet

[David++]

Hello list,

I have built a project in VS2005 which includes a Web Service Web Site. On
this server there is a Database. I have used the DataSet designer to link to
this database and VS2005 has created Table Adapters which connect to the
database and return the table data. My DataSet is called DatabaseDataSet . My
WebMethod for returning data from the server database is as follows -

[WebMethod]
public DataSet GetUserJobs(str ing id)
{
DatabaseDataSet ds = new DatabaseDataSet ();

JobTableAdapter jobAdapter = new JobTableAdapter ();
jobAdapter.Fill JobsSelected(ds .Job, id);

return ds;
}

This works, but is this an OK way to do it?

Thanks for any opinions,
David

[Pablo Cibraro [MVP]]

Hi,

The right answer should be, "It depends", interop is the major issue here.
The Datasets are complex XML structures that are really hard to convert in
other platforms different from .NET. If your web service is going to be
consumed by different client platforms, for instance JAVA clients, the
datasets are not a good way to go. In that case, you should use simple XSD
types. (.NET classes decorated with XML serialization attributes).

Regards,
Pablo Cibraro.

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:F6******** *************** ***********@mic rosoft.com...

Hello list,

I have built a project in VS2005 which includes a Web Service Web Site. On
this server there is a Database. I have used the DataSet designer to link
to
this database and VS2005 has created Table Adapters which connect to the
database and return the table data. My DataSet is called DatabaseDataSet .
My
WebMethod for returning data from the server database is as follows -

[WebMethod]
public DataSet GetUserJobs(str ing id)
{
DatabaseDataSet ds = new DatabaseDataSet ();

JobTableAdapter jobAdapter = new JobTableAdapter ();
jobAdapter.Fill JobsSelected(ds .Job, id);

return ds;
}

This works, but is this an OK way to do it?

Thanks for any opinions,
David

[David++]

Hi Pablo,

Thanks for taking the time to answer. Yes I agree that the main problem I
could run into is i I want other .NET clients to use this service, I would
have to be careful to return something which 'all' clients can understand.
I'll look into the method you suggested.

Best regards,
David

"Pablo Cibraro [MVP]" wrote:

Hi,

The right answer should be, "It depends", interop is the major issue here.
The Datasets are complex XML structures that are really hard to convert in
other platforms different from .NET. If your web service is going to be
consumed by different client platforms, for instance JAVA clients, the
datasets are not a good way to go. In that case, you should use simple XSD
types. (.NET classes decorated with XML serialization attributes).

Regards,
Pablo Cibraro.

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:F6******** *************** ***********@mic rosoft.com...

Hello list,

I have built a project in VS2005 which includes a Web Service Web Site. On
this server there is a Database. I have used the DataSet designer to link
to
this database and VS2005 has created Table Adapters which connect to the
database and return the table data. My DataSet is called DatabaseDataSet .
My
WebMethod for returning data from the server database is as follows -

[WebMethod]
public DataSet GetUserJobs(str ing id)
{
DatabaseDataSet ds = new DatabaseDataSet ();

JobTableAdapter jobAdapter = new JobTableAdapter ();
jobAdapter.Fill JobsSelected(ds .Job, id);

return ds;
}

This works, but is this an OK way to do it?

Thanks for any opinions,
David