CODEWITHSUNDEEP
c#.netentity-framework
mmwaikar
mmwaikar

Reputation: 665

Entity Framework 6.1 - code first - reference properties not loading correctly

I've noticed an issue with EF 6.1 code first. I have the following classes -

namespace Domain
{
    public interface ISupportsOptimisticConcurrency
    {
        byte[] RowVersion { get; set; }
    }

    public class Entity : ISupportsOptimisticConcurrency
    {
        public int Id { get; set; }

        [Timestamp]
        public byte[] RowVersion { get; set; }
    }

    public class Lookup : Entity
    {
        public Lookup()
        {
            Description = string.Empty;
        }

        [Required]
        [MaxLength(100)]
        public string Name { get; set; }

        [MaxLength(300)]
        public string Description { get; set; }
    }

    public class GroupType : Lookup
    {
    }

    public class Group:Entity
    {
        public Group()
        {
                GroupType = new GroupType();
        }

        [Required]
        public string Name { get; set; }

        [Required]
        public Guid ExternalId { get; set; }

        [Required]
        public string Password { get; set; }

        [Required]
        public string MonitorEmail { get; set; }

        public string UrlRequestEmail { get; set; }

        public bool UsesDefaultOptions { get; set; }

        [ForeignKey("GroupType")]
        public int GroupTypeId { get; set; }
        public virtual GroupType GroupType { get; set; }
    }
}

I've written a typical Repository class for accessing data from DB. Now, when I try to find a Group by Id, and include the GroupType, the GroupType doesn't load properly, and the Name property of GroupType comes as null.

Interestingly, when I removed the Group constructor which initializes a new GroupType, things start working fine.

Could you please explain this behavior? Note: This same scenario works fine with NHibernate as it is.

Thanks for the replies.

Upvotes: 0

Views: 311

Answers (1)

L-Four
L-Four

Reputation: 13531

I think you have to remove the initialization logic in the Group constructor:

 GroupType = new GroupType();

This probably overwrites the loaded data or does not even load it (because it already was instantiated), causing the GroupType property to be the instance that you initialized it with instead of the one in the database.

It may be the same issue as explained here.

Upvotes: 1

Related Questions