This project is a simple ASP.NET WebForms application designed to demonstrate how to test a connection to an SQL Server database. The project includes code examples for establishing and verifying a ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

General question:<BR>We recently switched one of our applications to Application Role security, which mandates (because the backend is SQL2000) that we turn off .NET Connection pooling for the sql ...

My tinkering with ASP.NET got me to wondering if you can do named parameters directly in SQL from within classic ASP/ADO. I can't seem to get it to work, it seems to ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...

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. A high-quality application must be stable, ...