How to create a SQL database in Windows Azure and tables in that data base?

Question

How to create a SQL database in Windows Azure and tables ? What is the difference between SQL database and Data Storage in Windows Azure? How to connect the SQL database tables in MVC5 application?

Artyom · Accepted Answer · 2015-05-25 17:53:30Z

1

In short it can be done from Visual Studio. There are free Community RC edition, 2015. A model created in C# (Code First Entity Framework). Then it is published through a wizard to Azure.

Azure Table Storage is used for non relational data kept in tables. It allows basic queries. Also there are in Azure Storage a Queue and Blob. For messages and for big data like videos.

Here is a starting guide for all of this at http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application . Also there're a lot of starter and useful info.

answered May 25, 2015 at 17:53

Artyom

3,6113 gold badges38 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a SQL database in Windows Azure and tables in that data base?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related