BlueCollar.SQLiteRepository.GetScheduledJobList C# (CSharp) Method

        public ScheduledJobRecordList GetScheduledJobList(string applicationName, long id, string search, int limit, int offset, IDbTransaction transaction)
        {
            StringBuilder cb = new StringBuilder(
            @"SELECT CAST(COUNT(j.[Id]) AS bigint)
            FROM [BlueCollarScheduledJob] j
            WHERE
            j.[ScheduleId] = @Id");

            StringBuilder sb = new StringBuilder(
            @"SELECT s.[Id], s.[Name], j.*
            FROM [BlueCollarSchedule] s
            LEFT OUTER JOIN [BlueCollarScheduledJob] j ON s.[Id] = j.[ScheduleId]");

            if (!string.IsNullOrEmpty(search))
            {
                cb.Append("\n    AND j.[JobType] LIKE @Search");
                sb.Append(" AND j.[JobType] LIKE @Search");
            }

            cb.Append(";\n\n");
            sb.Append(@"
            WHERE
            s.[Id] = @Id
            ORDER BY s.[Name], j.[Number] ASC
            LIMIT @Limit OFFSET @Offset;");

            sb.Append("\n");
            sb.Append(CountsSql);

            var p = new
            {
                ApplicationName = applicationName,
                Id = id,
                Search = !string.IsNullOrEmpty(search) ? string.Concat("%", search, "%") : null,
                Limit = limit,
                Offset = offset
            };

            ScheduledJobRecordList list = new ScheduledJobRecordList();

            using (var multi = this.connection.QueryMultiple(cb.ToString() + sb.ToString(), p, transaction, null, null))
            {
                bool readSchedule = false;
                list.SetPaging(multi.Read<long>().First(), limit, offset);

                var records = multi.Read<ScheduleRecord, ScheduledJobRecord, ScheduledJobRecord>(
                    (s, sj) =>
                    {
                        if (!readSchedule)
                        {
                            list.Id = s.Id.Value;
                            list.Name = s.Name;
                        }

                        return sj;
                    },
                    "Id").Where(r => r != null);

                foreach (var record in records)
                {
                    list.Records.Add(record);
                }

                list.Counts = CreateCounts(multi);
            }

            return list;
        }