cn = new System.Data.OleDb.OleDbConnection( System.Configuration.ConfigurationSettings.AppSettings["connectionString"]); I also tend to make a base page class and subclass that instead of ...

A connection to a database is a resource intensive operation that typically comprises a few steps. A channel of communication between the application and the database should be established before the ...

Take advantage of the Dapper ORM’s support for asynchronous operations to bring fast data access to your ASP.NET Core applications Dapper is an open source, lightweight “micro ORM” that supports many ...

I had been passing username/password strings directly into the ADO.NET connection string, however this means that if a user has a quote character in his password, it borks the ConnectionString and ...

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 ...

Visual Studio 2013 came with a new version of Web API. The Web API 2.1 update includes a host of new features, including support for Binary JSON. Learn how to leverage BSON by building a Web API 2.1 ...