BlueCollar.SQLiteRepository.CreateScheduledJob C# (CSharp) Method

        public ScheduledJobRecord CreateScheduledJob(ScheduledJobRecord record, IDbTransaction transaction)
        {
            const string Sql =
            @"INSERT INTO [BlueCollarScheduledJob]([ScheduleId],[Number],[JobType],[Data])
            SELECT
            @ScheduleId,
            coalesce((SELECT MAX([Number]) FROM [BlueCollarScheduledJob] WHERE [ScheduleId] = @ScheduleId), 0) + 1,
            @JobType,
            @Data;
            SELECT last_insert_rowid();";

            record.Id = this.connection.Query<long>(
                Sql,
                record,
                transaction,
                true,
                null,
                null).First();

            return record;
        }