private static int? GetVersion(Guid providerId, SqlTransaction transaction) { using (var command = new SqlCommand(SelectVersionQuery, transaction.Connection)) { command.Transaction = transaction; command.Parameters.AddWithValue("id", providerId); return (int?)command.ExecuteScalar(); } }