Join Phil Japikse for an in-depth discussion in this video What you should know, part of Entity Framework Core Essential Training: 1.
- [Instructor] There is some base knowledge that this course assumes that you know, and we're going to start with C#. This course is written entirely in C#, mostly because that is where the .net Core support is. VB is weakly supported at this time. Although, you can use a framework core in a full .NET framework app, so you can use it with VB.net. Again, we are going to focus on C#. I presume that you're going to understand LINQ, at least at some level.
We will go through all the queries that we're writing here. But, it helps if you understand Language Integrated Query at some level before starting. And then, simple SQL Server functionality. We're going to restore database, we're going to manage a relationship with database diagrams, we have to fix something in AdventureWorks and then some simple queries using SQL Server Management Studio. Nothing too advanced, just real basic stuff and it's going to help you with the course.
But, we will walk through everything that we write and, so, you can certainly pick it up as you go, as well. There is some software that's required for this class. First and foremost, Visual Studio 2017, version 15.3 or greater. 2017 is actually version 15. I know, it's a little confusing because there was a Visual Studio 2015, as well. But, what we need to do is look in the upper corner of your Visual Studio installation and go to Help About and we can do this right here.
So, here's the start page, Help, About, Microsoft Visual Studio and we want to make sure that the version is at least 15.3. We need that to work with .NET Core 2.0. Any edition of Visual Studio will work. The community edition is the same as what used to be called Professional. It is now free, with some restrictions on how you can use it. And that can be downloaded from the link on your screen, but it's easy enough to remember, VisualStudio.com.
.net Core 2.0, we need to install the SDK, depending on what version of Visual Studio you are using. When 15.3 first came out, you had to manually install the SDK, so we'll go through that, as well. And that can be downloaded from the link on your screen. SQL Server Management Studio, we're going to need this to fix some things in the AdventureWorks database. That will make it work better with EF Core. The SQL Server Management Studio is free and 2017 is the current version.
The link on your screen is going to take you to version 17.4. The only thing that Microsoft has done is separated SQL Server Management Studio from the install of SQL Server itself. From a database perspective, we're going to be working with AdventureWorks in the assets folder, in the downloadable files for this course. I have the backup of my version of AdventureWorks, so you already have the fix in place for the relationship we have to change.
You have some database diagrams, as well. But, you can certainly start with AdventureWorks 2016 and you can download the raw version from Microsoft's GitHub site that you see on the screen. There's also an AdventureWorks 2017. Everything in this course will work with that. I chose to use the 2016 version. I figured more people will have SQL Server 2016 installed than 2017.
Talking about SQL Server, we'll be running SQL Server Express. I'm running 2016. Now, I'm actually running local DB, which is a special version of SQL Server Express that gets installed in Visual Studio 2017. And we'll talk more about that in the next section. But, you can also use 2017. Now, SQL Server Express as a stand-alone install is completely optional for this course. Some people feel more comfortable using the full version of SQL Server Express than local DB and you can certainly do that.
We'll just have to change some connection strings as we go through this course and we'll give a shout out to those changes when we get through them. Again, I am using AdventureWorks 2016 and local DB, which is a version of SQL Server express 2016, but you can use a 2017 version of AdventureWorks. You'll just want to make sure that you use SQL Server Express 2017 with that version of the database.
And in the next section, we will talk about how to install all these things that we need.
- Entity Framework Core components and projects
- Working with scaffolded files
- Testing with xUnit
- Viewing generated SQL
- Composing queries
- Sorting and filtering results
- Working with aggregates
- Loading related data
- Logging and tracking
- Mapping functions
- Generics and delegates
- Checking concurrency
- Resiliency and transactions