Join Richard Goforth for an in-depth discussion in this video What you need to know, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] Before we get coding, let's talk about what you need to know. You should be proficient in C#, able to use generics and extension methods. You should also know LINQ. We'll be making heavy use of LINQ to query the database. If you're not familiar with these concepts, why don't you check out our course, LINQ with C# Essential Training? Finally, you need to know basic SQL and database design. You need to understand what a one to many or many to many relationship is, foreign keys, indexes, et cetera.
If you need to learn more about this, check out our course, SQL Essential Training. It's also helpful to know another Object Relational Mapper. Some other ones that you may have used include NHibernate, Dapper or older versions of Entity Framework. It would also be good to have experience coding against other databases. These things will give you a leg up on this course. Let's talk a little bit about our course environment. For the bulk of this course, we'll be using Windows and Visual Studio 2015 Update 3.
If you want to follow along on another operating system, such as a Mac, the code and concepts will remain the same, but your text editor and database tools will vary from what you see in the course. We'll also be using a SQL Server database in this course. You can use a local SQL Server, SQL Server on Azure, or SQL Express, but we'll be using SQL Server Data Tools packaged with Visual Studio.
- Setting up your project
- Connecting to a legacy database
- Scaffolding an initial model and context
- Improving the model
- Updating properties and indexes
- Adding concurrency tokens and timestamps
- Creating complex relationships
- Working with non-Microsoft databases such as SQLite and PostgreSQL