In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications to SQL Server 2012 databases using .NET classes. That article and its examples focused on .NET 4.0 desktop ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.

Message: Unable to connect to SQL Server session database. Trace: at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e) ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Take advantage of connection resiliency in EF Core to detect errors and retry commands and enable your ASP.NET Core application to overcome transient faults.