2 posts with tag MSSQL

The impact of SqlDataReader.GetOrdinal on performance

I recently had a discussion about the impact of SqlDataReader.GetOrdinal on execution of a SqlClient.SqlCommand. I then decided to run some code to measure the difference, because I think that's the o…

· 3 minutes reading time

TransactionScope & SqlConnection not rolling back? Here's why...

A while back we ran into an issue with one of our projects where we executed a erroneous query (missing DELETE statement), and then left the database in an inconsistent state. Which is weird, consider…

· 2 minutes reading time