Entity Framework 6 Lazy Loading doesn't work

Question

I have created two model classes: Student and Exam.

Student:

class Student
{
    [Key]
    public int StudentId { get; set; }

    [Required, MaxLength(30)]
    public string FirstName { get; set; }

    [Required, MaxLength(50)]
    public string LastName { get; set; }

    [Required]
    public DateTime BirthDate { get; set; }

    public virtual ICollection<Exam> Exams { get; set; } 
}

Exam:

public enum Grade
{
    A, B, C, D, E, F
}
class Exam
{
    [Key]
    public int ExamId { get; set; }

    [Required]
    public Grade Grade { get; set; }

    [ForeignKey("Student"), Required]
    public int StudentId { get; set; }

    public virtual Student Student { get; set; }
}

But it seems Lazy Loading doesn't work, here's example how I retrieve data:

using (var context = new StudentContext())
{
    context.Configuration.LazyLoadingEnabled = true;
    context.Configuration.ProxyCreationEnabled = true;

    var student = context.Students.Single(s => s.LastName == "ABC");

    foreach (var exam in student.Exams)
    {
        Console.WriteLine($"{exam.ExamId}: {exam.Grade}");
    } 
    context.SaveChanges();
}

And I'm getting NullReferenceException when I try to access students.Exams property. What's wrong in my code?

The problem with my code is that Entity Framework Lazy Loading isn't working and I don't know why. It's not about not initializing Exams, because Entity Framework should do it alone when I try to access Exams property.

@Nasreddine, not really. I have read that EF during Lazy Loading should notice if collection is initialized or not and initialize it. I added initialization in constructor but Lazy Loading still doesn't work. Now when I try to loop over student exams(these exams exist in database) I don't get any output. student.Exams is an empty collection, but EF should have load it. — monoh_
– monoh_, Commented Mar 22, 2016 at 16:07
@TomTom, @Rene Vogt, how is my question a duplicate of how to fix NRE? My problem is that EF Lazy loading doesn't work, not about Exams being null, because EF should itself initialize this collection. — monoh_
– monoh_, Commented Mar 22, 2016 at 16:09
@AlexanderDerck, initializing collection in constructor prevents from getting NullReferenceException but collection is empty even if in database I have exams with id of given student. I have read lots of similar questions but still wasn't able to get my code working. — monoh_
– monoh_, Commented Mar 22, 2016 at 17:26

Alexander Derck · Accepted Answer · 2016-03-23 07:50:40Z

13

You didn't follow the rules to enable Entity framework to create proxies (required for lazy loading), which needs public access:

A custom data class must be declared with public access.

Make your Exam and Student public and it should work.

answered Mar 23, 2016 at 7:50

Alexander Derck

14.7k5 gold badges61 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

arminb Over a year ago

May God (repectively the flying spaghetti monster) bless you.

Erkan Demirel · Accepted Answer · 2016-03-23 08:31:33Z

2

In c# if you don't declare access modifiers, It will accept it as internal by default.

You should declare you entity classes as public.

Secondly collections should return empty collection beside of null. So If a student doesn't have any exam, you should return empty collection. That's wyh you should change your Student Constructor also.

 public class Student
    {
        public Student()
        {
            Exams = new List<Exam>();
        }
    }

Edit: If you have ICollection or IList, ef returns empty collection. You should use this constructor, if you are using IEnumurable.

edited Mar 23, 2016 at 8:31

answered Mar 23, 2016 at 7:58

Erkan Demirel

4,4021 gold badge27 silver badges43 bronze badges

2 Comments

Alexander Derck Over a year ago

Tested it and even without constructor or lazy initialization of the collection you get back an empty collection. I think this was only needed in old versions of EF

Erkan Demirel Over a year ago

I didn't know that. Thanks for info.

Collectives™ on Stack Overflow

Entity Framework 6 Lazy Loading doesn't work

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related