Activities of "jtallon"

Of we have OpenId configured, can a logout url be defined in the OpenId config?

HI samara081,

Would it be possible for you to share how you hooked up registering the tables to be system versioned?

I was taking a look at EntityFrameworkCore.TemporalTables @ https://github.com/findulov/EntityFrameworkCore.TemporalTables, but its not picking up to to make the changes within the AspNetZero framework.

I am sure I am mostlikely missing something.

Would apprciate any insight?

Regards John

Hi @ismcagdas,

The user might make a change to an OrderItem or the OrderDetails (Parent) or both. We want to allow the user to view the history on the OrderDetails where they will be able to see if a OrderItem has also been changed.

In summayr, we want to track any change to an entity and any related enities by looking at the root... OrderDetails.

Hope this is achieveable?

Regards John

Hi we now face this problem when running the test suite. All tests fail. "System.NotSupportedException : SQLite doesn't support computed columns."

Related to this I understand https://support.aspnetzero.com/QA/Questions/8404

I think that's what we'll do. possibly let sql server generate it from the ScarNumber column.

This is what I was hoping I wouldn't hear. :( However, I think this is the case. EF Core 3.0 brought some breaking changes such as not allowing client side evaluation where it was unable to evaluate the where clause. Like this case.

If you have any workarounds it would be great, i would like to avoid saving the string property down to the database but this maybe the only option to search on it.

Hi ismcagdas, thanks for getting back to me. I updated the CourseTrainer entity to include

public bool Equals(CourseTrainer other)
        {
            if (ReferenceEquals(other, null))
            {
                return false;
            }
            if (ReferenceEquals(this, other))
            {
                return true;
            }
            return CourseId.Equals(other.CourseId) && TrainerId.Equals(other.TrainerId);
        }

        public override int GetHashCode()
        {
            int hashCourseId = CourseId.GetHashCode();
            int hashTrainerId = TrainerId.GetHashCode();
            return  hashCourseId ^ hashTrainerId;
        }

With the above I was then able to use the Except keyword

private async Task UpdateCourseTrainers(Course courseInputEntity, Course savedCourse)
        {            
            var toRemove = savedCourse.CourseTrainers.Except(courseInputEntity.CourseTrainers).ToList();          
            await _courseTrainerRepository.DeleteAsync(ct => toRemove.Any(t => t.TrainerId == ct.TrainerId));

            var toInsert = courseInputEntity.CourseTrainers.Except(savedCourse.CourseTrainers).ToList();
            foreach (var trainer in toInsert)
            {
                await _courseTrainerRepository.InsertAsync(trainer);
            }
        }

It works well now

No, my project is using 8.0

This is the error i am getting.

No, my project is using 8.0

Any update on this?