Working with the new Microsoft.Data.SqlClient

The Discussion

• 

  thanks for sharing!!

• 

  If you really want to use SQL Client to the fullest, there is a tool that builds all the SQL Client code and mappings by simply adding a few comments to a stored procedure. You can learn more about the approach and the tools at www.SQLPLUS.net
  
  

• 

  any sample for Microsoft.Data.SqlClient applied in Dependency Injection ?

• 

  I am using .NET Core 3.0 console application with Ado.net. Things are no that simple as you mentioned in video. I replaced System.Data with Microsoft.Data but IDbConnection, IConnectionFactory didn't worked. Similarly I am not able to get connection factory and getting error:
  
  System.ArgumentException: 'The specified invariant name 'System.Data.SqlClient' wasn't found in the list of registered .NET Data Providers.'
  
  Can you shed some light ?

• 

  Will this work with Entity Framework?

• 

  I could not find any tutorial for sqlClient on official docs .do some thing about it