• 6 hours
  • Medium

Free online content available in this course.



Got it!

Last updated on 11/15/19

Log in or subscribe for free to enjoy all this course has to offer!

Course introduction

You don’t have to be a database administrator (DBA) or architect (logical DBA) to build relational databases. Developers today are frequently tasked with this responsibility. Fortunately, ASP.NET Core has a terrific way of providing programmatic access to relational databases, whether accessing an existing database or creating a new one.

In this course, you’ll leverage your knowledge of SQL, SQL Server, C#, and MVC to learn two different approaches to integrating a relational database with a .NET MVC application:

  • Code-first migrations

  • Scaffolding (sometimes called database-first integration)

You’ll use code-first migrations to generate a new relational database directly from your C# code. Then you’ll turn that process around and, after building a relational database using SQL Server Management Studio (SSMS), you’ll use ASP.NET’s built-in object-relational mapping (ORM) tool, Entity Framework Core, to scaffold C# code to provide programmatic access to the existing database.

Are you ready to make database integration a whole lot easier than you might have imagined? Then join me in the first chapter and let’s get started!

Meet Your Teacher: Andrew Jensen

I have spent more than 25 years in the IT industry and academia as an entrepreneur, manager and director, corporate trainer, software developer, technical writer, research scientist, teacher, and student. I'm the co-founder and CEO of jTEC Web Services, an IT consulting firm, and jTEC University, a soon-to-be-launched coding boot camp specializing in .NET development education. I'm also the author of the curriculum in use at Coder Foundry, a .NET-based coding boot camp headquartered in Kernersville, North Carolina, and a contributing author, instructor, and curriculum consultant here at OpenClassrooms. My research work, both in the effects of risk on technology acceptance and in IT education through embodied pedagogical agents, has been published in international academic journals and conference proceedings.

Example of certificate of achievement
Example of certificate of achievement