I hear tell that you can't access SQL server from ASP.NET Core. That's simply not the case! In this episode we jam on connecting an ASP.NET Core application to SQL server.
In this episode we make use of the fantastic Dapper library for light weight ORM functionality.
Dapper.net
https://github.com/StackExchange/dapper-dot-net
Release notes for SQL Data Access
https://github.com/dotnet/core/blob/master/release-notes/1.0/Release-Notes-RC2.md#data