Hello Friends, In this blog we will try to understand what exactly ADO.NET/ Entity Framework connection pooling is? And we will also go through some important points related to connection pooling. So ...

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

Embedding connection strings in your application's code can lead to security vulnerabilities and maintenance problems. Unencrypted connection strings compiled into an application's source code can be ...

Guideline for connecting to a SQL Server by SqlClient provider. To connect to Microsoft SQL Server, use the xref:Microsoft.Data.SqlClient.SqlConnection object of the Microsoft SqlClient Data Provider ...

Leverage ADO.Net's ability to work in disconnected mode to enable your application to stay disconnected to the database, conserve the system resources, and reduce the network traffic Microsoft’s ...

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

Faster performance in business applications comes down to reducing the "critical two" -- disk I/O and trips to the server. Doing that means doing a lot of things right, starting with your database ...

ADO.NET refers to ActiveX Data Objects. It is a crucial factor of the .NET framework. It is intended to join with diverse databases like SQL, MySQL, Oracle, and MS Access, etc. The Data Reader object ...