how a website can get data from sql azure

Question

Hi,

      please help me if anybody knows the answer for the following question

     I want to create a website using asp.net

but here I want to get data from azure(sql azure)

then which template I have to select

means asp.net empty website template

                    or

asp.net MVC3 webrole

what are the major differences between these two templates

---

srujana

Answer 1

either of these can get data from a SQL Azure database. SQL Azure appears just like any other SQL database to your application.
The templates just set up a visual studio project for you to complete the implementation.
So, the MVC3 template sets up a bunch of stuff to get MVC3 to work. You can start with a blank website too and implement everything yourself.

Answer 2

If I use asp.net empty website  template can I host it on windows azure

which is the better option for creating website either asp.net empty website template or asp.net mvc3 webrole

---

srujana

Answer 3

HI chandana30,

Websites are not supported by default. I advise you to start with a webrole (depending on your experience this can be an ASP.NET Web Role or an ASP.NET MVC 3 Web Role). And if your goal is to build a website, you might want to take a look at Orchard (a CMS with native support for Azure): http://www.orchardproject.net/

Sandrino

---

Sandrino Di Mattia | Twitter: http://twitter.com/sandrinodm | Azure Blog: http://fabriccontroller.net/blog | Blog: http://sandrinodimattia.net/blog