Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

iOS

Jonas Moltumyr
Jonas Moltumyr
1,939 Points
Posted by Jonas Moltumyr
Jonas Moltumyr
1,939 Points

Web service for IOS to communicate with MSSQL/MySQL

Hi

Im going through the course of IOS, and I have found my first project to begin with after the course.

Im going to make a app for a bar im working at. Displaying basic information, drink meny and a drink finder. I want a MSSQL/MySQL to store data, to make it dynamical as the drink menu often changes quite a bit.

I work as a technical consultant at a software company, so I know that making a webservice is considered best practice (not really sure if its another way to communicate with SQL databases with IOS).

So for the question, what web services should I use, what is the difference? (REST, SOAP etc.?)

Need some pointers to where I should start looking.

2 Answers

Behrang Saeedzadeh
Behrang Saeedzadeh
1,644 Points

Would this help: http://www.exgonline.com/microsoft-asp-net-4-5-web-api-vb-net?

Looks like VB.NET resources for Web API is scarce on the net.

Jonas Moltumyr
Jonas Moltumyr
1,939 Points
Jonas Moltumyr
Jonas Moltumyr
1,939 Points

Thank you!

This will help me get going! I´ll give it a try :D

Behrang Saeedzadeh
Behrang Saeedzadeh
1,644 Points
Behrang Saeedzadeh
Behrang Saeedzadeh
1,644 Points

Don't use SOAP. It is an overly complex enterprise technology that even enterprises are avoiding it.

Do you know JavaScript? If so you can build a web service using Hapi.js or other similar frameworks.

There are a huge number of options but I am not going to confuse you by listening all of them...

For deployment I recommend one of DigitalOcean or Heroku platforms but there are others too (eg AWS).

Jonas Moltumyr
Jonas Moltumyr
1,939 Points
Jonas Moltumyr
Jonas Moltumyr
1,939 Points

Thank you, I dont know JavaScript, but I do know some vb.net.. I have read a little bit and see that REST with json is much more compact and better for mobile applications.

But cant find any tutorials on making a REST (json) web service in vb.net.. only in c#. You dont happen to know anyone where they retrieve data from MSSQL or MySQL?

Behrang Saeedzadeh
Behrang Saeedzadeh
1,644 Points

I don't have .NET experience, but looks like there are plenty of resources available here: http://www.asp.net/web-api

Jonas Moltumyr
Jonas Moltumyr
1,939 Points
Jonas Moltumyr
Jonas Moltumyr
1,939 Points

Yeah, I´ve seen that. But it´s all c#..

I´ll take a look at it, was just hoping for a video tutorial or something covering REST (json) in vb.net, would make it a bit easier for me to get started with web services with SQL back end.