In my last post I went for a warts n all approach to set up a web role on Azure. In this post I’ll describe how to add an SQL Azure database to the project. This will be described with an as minimal as possible amount of code
and screen dumps. All
questions are welcome in the comments area. Please don’t email since
questions answered in the comments field is made available to other visitors. As an example we will add a comments section to the site we used in the previous post (Länk här). Steps: 1. Create a Comments entity
and then use Scaffolding to set up controller
and view,
and add ConnectionString to web.config. 2. Create SQL Azure database in Management Portal
and link the new database 3. Test it online! 1. Right click Models folder, choose add, choose “class…” . Name the Class Comment. 1.1 Replace the Code in the class with the following: using System.Data.Entity; namespace MvcWebRole1.Models { public class Comment { public int CommentId { get; set; } public string Name { get; set; } public string Content { get; set; } } public class CommentsDb : DbContext { public DbSet<Comment> CommentEntries { get; set; } } } Now Entity Framework can create a database
and a table named Comment. Build your project to assert there are no build errors. 1.2 Right click Controllers folder, choose add, choose “class…” . Name the Class CommentController
and fill out the values as in the example below. 1.3 Click Add. Visual Studio now creates default View for CRUD operations
and a Controller adhering to these
and opens them. 1.3 Open Web.config
and add the following connectionstring in <connectionStrings> node. <add name="CommentsDb” connectionString="data source=(LocalDB)\v11.0;Integrated Security=SSPI;AttachDbFileName=|DataDirectory|\CommentsDb.mdf;Initial Catalog=CommentsDb;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" /> 1.4 Save All
and press F5 to start the application. 1.5 Go to http://127.0.0.1:81/Comments which will redirect you through CommentsController to the Index View which looks like this: Click Create new. In the Create-view, add name
and content
and press Create. 1: //
2: // POST: /Comments/Create
3:
4: [HttpPost]
5: public ActionResult Create(Comment comment)
6: {
7: if (ModelState.IsValid)
8: {
9: db.CommentEntries.Add(comment);
10: db.SaveChanges();
11: return RedirectToAction("Index");
12: }
13:
14: return View(comment);
15: }
16:
The default View() is Index so that is the View you will come to. Looking like this:
1: //
2: // GET: /Comments/
3:
4: public ActionResult Index()
5: {
6: return View(db.CommentEntries.ToList());
7: }
Resulting in the following screen dump(success!):
2. Now, go to the Management portal
and Create a new db.
2.1 With the new database created. Click the DB icon in the left most menu. Then click the newly created database. Click DASHBOARD in the top menu. Finally click Connections strings in the right menu to get the connection string we need to add in our web.debug.config file.
2.2 Now, take a copy of the connection String earlier added to the web.config
and paste in web.debug.conifg in the connectionstrings node.
Replace everything within “ “ in the copied connectionstring with that you got from SQL Azure. You will have something like this:
2.3 Rebuild the application, right click the cloud project
and choose “Package…” (if you haven’t set up publishing profile which we will do in our next blog post).
Remember to choose the right config file, use debug for staging
and release for production so your databases won’t collide.
You should see something like this:
2.4 Go to Management Portal
and click the Web Services menu, choose your service
and click update in the bottom menu.
2.5 Link the newly created database to your application. Click the LINKED RESOURCES in the top menu
and then click “Link” in the bottom menu. You should get something like this.
3. Alright then. Under the Dashboard you can find the link to your application. Click it to open it in a browser
and then go to ~/Comments to try it out just the way we did locally.
Success
and end of this story!
