BlueCollar.SQLiteRepository.GetQueuedDetails C# (CSharp) Метод

        public QueueDetailsRecord GetQueuedDetails(long id, IDbTransaction transaction)
        {
            const string Sql =
            @"SELECT
            q.[Id],
            q.[QueueName],
            q.[JobName],
            q.[JobType],
            q.[Data],
            q.[QueuedOn],
            q.[TryNumber],
            s.[Name] AS [ScheduleName]
            FROM [BlueCollarQueue] q
            LEFT OUTER JOIN [BlueCollarSchedule] s ON q.[ScheduleId] = s.[Id]
            WHERE
            q.[Id] = @Id;";

            return this.connection.Query<QueueDetailsRecord>(
                Sql,
                new { Id = id },
                transaction,
                true,
                null,
                null).FirstOrDefault();
        }