Database providers - Entity Framework Tutorial

Hello again, friends. Welcome back to Entity Framework Core for Beginners. In previous videos we've looked at using Entity Framework Core exclusively with SQL Server. In this video, we're going to look at using Entity Framework Core with other database providers. The database provider is a layer in the EF Core architecture that's responsible for the communication between Entity FrameWork Core and the database. It's a pluggable architecture, which means EF Core can support all kinds of databases. The first database provider we're going to look at is SQLite. SQLite is an open source cross-platform embedded database technology. In SQLite, the entire database is stored as a single file. So it's a great choice when you don't want to take a dependency on a server based database platform. I'm starting with a console application preconfigured with my NuGet packages. I've already written context and model classes. The code in program.cs adds some records to the products table. Using a…