Entity framework not able load roles in one to many

Question

0.00/5 (No votes)

See more:

Hello Everyone,

This is the first time i am creating something on ASP.net MVC with entity framework with code first Approach, User details are getting loaded but role for the user is not getting loaded my code is as follows.

What I have tried:

public class User
 {
     public int UserId { get; set; }
     [Required]
     public string UserName { get; set; }

     [Required]
     public string UserPwd { get; set; }
     public string ProjectCode { get; set; }
     public string UserType { get; set; }
     public bool IsEnabled{ get; set; }
     //public int RoleId { get; set; }

     public DateTime? CreatedDate { get; set; }
     public string CreatedBy { get; set; }
     public DateTime? UpdateDate { get; set; }
     public string UpdatedBy { get; set; }
     public Role Role { get; set; }

 }

public class Role
{
    public int RoleId { get; set; }
    public string RoleName { get; set; }

    public ICollection<User> Users { get; set; }
}

public class UserContext : DbContext
{
    public DbSet<Role> Roles { get; set; }
    public DbSet<User> Users { get; set; }
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        Database.SetInitializer<UserContext>(null);
        modelBuilder.Entity<User>().ToTable("Users");


        modelBuilder.Entity<User>().HasKey(u=> new{ u.UserId});

    }

}

public static bool Authenticate(User u)
{
    UserContext uc = new UserContext();

    List<User> uList = uc.Users.Where(p => p.UserName == u.UserName && p.UserPwd == u.UserPwd).ToList();


    return false;
}

Above uList returns Users list but not Roles??
Not able to understand what to do, tried many articles on internet but nothing is really working for me.

Posted 20-Nov-17 5:14am

sunil mali

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2017-11-20T05:24:00

Entity Framework Loading Related Entities[^]

You have two options:

1) Lazy Loading (Not recommended)
Make your collection and navigation properties virtual, and Entity Framework will create dynamic proxies for your entities, which will be able to load the related entities dynamically on demand.

C#

public virtual Role Role { get; set; }

However, this only works so long as the DbContext is still alive, and it can dramatically increase the number of queries used.

2) Eager Loading
Use the Include extension method to load the related entities at the same time as the main entity.

C#

List<User> uList = uc.Users
    .Include(p => p.Role)
    .Where(p => p.UserName == u.UserName && p.UserPwd == u.UserPwd)
    .ToList();

NB: You are storing passwords in plain text. Don't do that!
Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

And why are you re-inventing the wheel? ASP.NET has several perfectly good authentication systems built-in - for example, ASP.NET Identity[^]