A good way to send the results from a MySQL query over a Web Service?

I've been trying to figure out a good and easy way to send the results of a MySQL Query over my Web Service.

There is a lot of good methods that I've looked into, like Data Transfer Object, but I would like to keep it as simple as possible. At this point simply getting this to work has a higher priority. :)

Any help or documentation is welcome, even on more difficult topics, but as mentioned above the simpler the better at this point.

Answers


when you say expose your results, do you also mean dynamic querying? such as Wcf Data Services

However be careful on what and how you expose information. It is a pain to go back and fix it.

for SOA or a 3 physical Tier I would consider using

  • Service Layer
  • Data transfer objects, they are great, exposing data directly can cause issues with maintainability/Changeability

to help with DTO's look at AutoMapper, it was designed for it.

if I have missed a point, add a comment

ps here is a great list of helpful patterns PoEAA Catalogue


Need Your Help

Writing to .dat-file, incrementing number

java output increment

I'm writing to a .dat-file. This is the code:

Mercurial: Build script creates 2nd line when tagging the tip

mercurial build-automation versioning

I've hunted SO for other Mercurial posts relating to tags and build scripts but I didn't find the particular issue I'm seeing.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.