Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 19 Minute(s)
Language
English
Taught by
MPire Training
Rating
Course Overview
Learn how to create an application in C# that can generate it's own database using Entity Framework and Code First.
In this course you will learn how to create a simple C# application using Microsoft Visual Studio that creates and connects to an SQL Database with the Entity Framework*, with no database development required!
We will use Code First development principals to define all database tables and columns using only C# code.
All database tables and columns will be generated automatically from the C# code without the need to edit the database directly. As such we will be doing no database development (except for a section on calling SQL statements directly if you need to).
All source code is included as a Microsoft Visual Studio 2013 project so you can get up and running straight away.
Thank you for choosing this course and we look forward to viewing your positive reviews and feedback.
MPire Solutions Pty Ltd
* Note: The Entity Framework is Microsofts' newest data access technology, and Code First allows us to create database driven applications using only C# code, with no database development required!
Course Content
- 8 section(s)
- 24 lecture(s)
- Section 1 Introduction
- Section 2 Setup
- Section 3 The Models
- Section 4 Relationships
- Section 5 Data Context
- Section 6 C.R.U.D.
- Section 7 Extra Topics
- Section 8 Conclusion
What You’ll Learn
- By the end of the course you will be able to define and build an SQL database using only C# code. No database development required!, Perform CRUD operations (Create, Read, Update, Delete) on entities using C# code., Handle entity changes using Code First Migrations., For the majority of the course, we will do absolutely no database development! However, we will show how to call custom SQL statements if you need to.
Skills covered in this course
Reviews
-
MMichael Flum
The course is fine if you want to do the nessesary research on how to implement a database if one does not exisit. This is 2020 not 2013 so i had to go back to a Microsoft archive to get a 2013 Visual Studio so I could follow along. Then after researching I install SQL Express. Then after the install I had to do the work to create the App.config
. Mine turned out to be: Then test it with the Nuget package untill you get it right. In all this cost me hours. This course must be revisited to bring it upto date or you should not charge for it. -
ZZerro Unno
Yes, it match, especially when someone else working. I was working with Matt of course. But it's not enough only do this one time. Maybe after couple of times it will be better and better to understand perfect. However this guy is professional of course, and I am not. I hope that I am on right way. This will be maybe worth sometimes.
-
GGabriel Barrett
(Using Visual Studio 19 and Microsoft SQL Server 18) The course was super easy to follow along. The only issues I had was connecting to the database via Visual Studio. I was able to connect to my local DB and view all changes made in the UI and make my own changes in a separate instance of SQL. The instructor went at a good pace, I only had to pause and rewind a few times. He was easily understood and my program works!
-
JJustin Rodgers
A pretty good course; one of the better ones I've seen so far. It's easy to follow and can be understood up to about 1.5x playback speed. There were a few issues I had that the instructor glazed over, specifically dealing with some file structure with databases and what could cause issues for a new developer. No one seems to talk about how to clean up databases, tables or migrations as a new developer will make some mistakes, miss things and may even have a couple of early tutorial tables in the way causing confusion. I had to get outside help on a couple of things but I guess that's normal with development in this field. I had to stop trying to follow along as some of the features didn't always work in the later parts but stick with it. Pay attention and use your playback controls because this course will help with a lot. Worth the purchase. Worth coming back to for reference.
