C#C
C#2y ago
Whiteboy

✅ MySQL with Entity Framework, getting null of entity all time

public class UserAssignmentDate
{
    [ForeignKey("UserId")]
    public int UserId { get; set; }

    [ForeignKey("AssignmentId")]
    public int AssignmentId { get; set; }
    
    public DateTimeOffset AssignmentTime { get; set; }
    public DateTimeOffset DeadLineDateTime { get; set; }
    public DateTimeOffset LastUploadDateTime { get; set; }
    public TimeSpan TimeToNextUpload { get; set; }

    // Navigation properties
    public User User { get; set; }
    public Assignment Assignment { get; set; }
}

            var userAssignmentDate = await dbContext.UserAssignmentDates
                .FirstOrDefaultAsync(userAssignmentDate => userAssignmentDate.UserId == UserId && userAssignmentDate.AssignmentId == assignmentId);

        foreach (int userId in userIds)
        {
            var userAssignmentDate = new UserAssignmentDate
            {
                UserId = userId,
                AssignmentId = assignmentId,
                AssignmentTime = assignmentTime,
                LastUploadDateTime = DateTimeOffset.MinValue,
            };

            dbContext.UserAssignmentDates.Add(userAssignmentDate);
        }
        
        await dbContext.SaveChangesAsync();

and userAssignmentDate returns null all time when UserId and AssignmentId are good values
Was this page helpful?