Inner Geek, Links

Creating a CRUD Application and Hosting it in Microsoft Azure Webforms Using Azure Active Directory for Authentication Webforms
Using Azure Active Directory for Authentication

The video that is linked to this page is a complete end-to-end walk through of creating a web facing application hosted in Azure to create, read, update, and delete (CRUD) data using MVC (Model – View – Controller) and the entity framework in Visual Studio. The entity framework uses the database first template. This mirrors a real world scenario where an entity has existing data in an on-premise SQL server and there is a need to maintain that data in an internet facing application.

I made this video simply because when I was learning how to create a CRUD application and host it in Azure, I was not able to find a good resource that had COMPLETE instructions. I found bits and pieces here and there. Many times, the bits and pieces I found were outdated and incomplete.

The linked video uses these resources:
Microsoft Visual Studio (I used the 2019 Community Edition v16.4.4)
Microsoft Data Migration Assistant (I used version v5.0)
An Azure account (I used a free Azure account)

In addition to the above resources, I prepared a small text file that has some SQL script and some code that can be used if you want to re-create the application that is in the video. It is not required, but it will save some typing.
You can download the supplemental text file here:

The development in the linked video meets these objectives:

  • Uses existing on-premise data to build the application
  • Migrates the on-premise data to a database hosted in Azure
  • Hosts the application in Azure for access with an internet browser
  • Controls access to data in the application using user authentication
  • Limits functionality in the application by user roles
  • Uses Visual Studio as the development tool