BlueCollar.SQLiteRepository.GetWorking C# (CSharp) Method

        public WorkingRecord GetWorking(long id, IDbTransaction transaction)
        {
            const string Sql =
            @"SELECT *
            FROM [BlueCollarWorking]
            WHERE
            [Id] = @Id;";

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