velmurugan
velmurugan

Reputation: 66

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

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?

Upvotes: 1

Views: 47

Answers (1)

Artyom
Artyom

Reputation: 3571

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.

Upvotes: 1

Related Questions