I got a function implemented on a CLR using .Net Framework 4.8, this function is called millions of times a day, and each time it's called 1000 times, it acummulates around 80kb permanently on ...

When upgrading from .NET 6 to .NET 7 we encountered a breaking change in SqlDataReader. For some reason, upgrading runtime from 6 to 7 changes the behavior of System.Data.SqlDataReader.GetString() to ...

You can turn on logging for your Entity Framework code with a single line. Configuring it to write to a file takes only a little bit more effort. Assuming that you're using Entity Framework 6, you ...

While using ADO.NET classes we perform manipulations with data and tables. But if in any case we first want to know the table structure or want to get the schema structure then we can also use ...

While using data reader we know the limitations that it can load one result set at a time. So sometime we have situations where we need to read multiple result sets in our application. Their are many ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

I know that I keep going on about this, but the best way to speed up your application is to retrieve all the data you need on each trip to the database and make as few trips to your database as you ...