Join Richard Goforth for an in-depth discussion in this video Platforms available to EF Core, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] One of the primary strengths of Entity Framework Core is how available it is. Entity Framework Core is part of the open source initiative .NET Core that rewrote the .NET Runtime and open-sourced it. Where .NET used to be mostly limited to Microsoft devices, it's now available across a multitude of platforms. Along with Windows machines MAC, Linux, and Docker containers, can all run .NET Core applications including applications that use Entity Framework Core. Those are the platform that .NET runs on.
Let's talk a bit about the databases that Entity Framework can run against. It's no surprise that Entity Framework Core runs against MS SQL databases. It also runs against IBM database servers, also known as DB2, SQLite, and PostgreSQL databases. Other platform support is in the works for Entity Framework Core including MySQL and Oracle databases. Entity Framework Core is extensible which means that you can write your own library against any type of custom database.
It's no simple task but it can be valuable in a large corporate environment.
- 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