Best practices (SQLCommand and Web Services)

[GeertVerhoeven]

Hi all,

I have a database that is in a DMZ. To be able to access the DB easily I was planning to create a web service that does all the DB access so that it can be used via a WinForm app over the internet.

My intention was to pass a SQLCommand to the WebService but apparently this is not Serializable so it doesn't work. I wanted to pass the SQLCommand to avoid having to put all the business knowledge in the webservice and to make it as dynamic as possible.

What is the best practice for such a problem?

All help is welcome !

Greetz,

Gette

 

[ca8msm]

Why do you need to pass the SQLCommand? If you just passed the cammand (e.g. Stored Procedure name or SQL Statement) along with any necessary Parameters, then you can just execute the statement and return the results.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.