What is the best way to keep the connection string for a database connection in a central (change it only in one place to change everywhere) location?

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

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

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

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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