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