I'm trying to figure out the best way to have my android app pull data from my ms sql server 2008 database. I understand that there's two parts to this that the android app (written in java) has to call the web service (written in .net) and then that will call the database and pull the data, but all the examples I've found are rather piecemeal. Does anyone have any good examples?
Some examples I've seen use a ksoap design that doesn't seem the best because it doesn't look like it's really supported that well. http://ksoap2.sourceforge.net/
Another one I've seen is a Jersey based design http://jersey.java.net/, which looks like it would be easier but I have no idea how to interface it with a .net web service.