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
