BlueCollar.SQLiteRepository.GetSchedule C# (CSharp) Method

        public ScheduleRecord GetSchedule(long id, IDbTransaction transaction)
        {
            const string Sql =
            @"SELECT *
            FROM [BlueCollarSchedule]
            WHERE
            [Id] = @Id;";

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