Quick tip: Optimizing repeating try-catch-finally statement
Lately, I’ve started noticing a pattern in data layer of one of our projects at work. The pattern looks like this: SqlConnection connection = null; SqlTransacton transaction = null; try { connection = new SqlConnection(connectionString); connection.Open(); transaction = connection.BeginTransaction(“transactionName”); // execute database queries and do mapping and stuff } catch (Exception) { if (null != […]