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

I am just curios, in the generated code, why do you get the field values by ordinal number instead of using the field names? I assume that it's faster, but how much faster? Did you run any tests? let ...

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

An ORM (Object Relational Mapping) tool is one that is used to abstract the data access logic of your application. You can use ORM to bridge the apparent mismatch between the data and the object ...

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