public WorkerRecord GetWorker(long id, IDbTransaction transaction) { const string Sql = @"SELECT * FROM [BlueCollarWorker] WHERE [Id] = @Id;"; return this.connection.Query<WorkerRecord>( Sql, new { Id = id }, transaction, true, null, null).FirstOrDefault(); }