Microsoft announced a new data access driver for SQL Server that should be the path forward for data developers in the era of .NET Core.

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

In this article we will examine how we can configure the DbContext using an instance of DbContextOptions to connect to a database and perform CRUD operations using the Entity Framework Core provider.