Linq to sql返回相关数据 [英] Linq to sql to return related data

问题描述

我有两个相关的模型.

public class RolesModels
{
    public RolesModels()
    {
        this.Users = new HashSet<UserModels>();
    }

    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int RoleId { get; set; }

    [Required]
    [DataType(DataType.Text)]
    [StringLength(20, ErrorMessage = "The {0} must be at least 6 characters long.", MinimumLength = 6)]
    [Display(Name = "Caption")]
    public string Caption { get; set; }

    [Display(Name = "Can Create")]
    public bool createRole { get; set; }

    [Display(Name = "Can View")]
    public bool viewRole { get; set; }


    [Display(Name = "Can Modify")]
    public bool modifyRole { get; set; }

    [Display(Name = "Can Delete")]
    public bool deleteRole { get; set; }

    public virtual ICollection<UserModels> Users { get; set; }

}

第二个是这样的

   public class UserModels
{
    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]

    public int user_id { get; set; }

    [Required]
    [DataType(DataType.Text)]
    [Display(Name = "User Name")]
    [StringLength(20, ErrorMessage = "The {0} must be at least 3 characters long.", MinimumLength = 3)]
    public string user_name { get; set; }

    [Required]
    [DataType(DataType.Password)]
    [Display(Name = "Password")]
    [StringLength(10, ErrorMessage = "The {0} must be at least 4 characters long.", MinimumLength = 4)]
    public string user_pass { get; set; }

    [DataType(DataType.EmailAddress)]
    [Display(Name = "Email")]
    [StringLength(50, ErrorMessage = "The {0} must be at least 6 characters long.", MinimumLength = 6)]
    public string UserEmail { get; set; }

    [Display(Name = "Registeration Date")]
    [DataType(DataType.Date)]
    [DisplayFormat(DataFormatString = "{0:dd-MM-yyyy}", ApplyFormatInEditMode = true)]
    public DateTime RegDate { get; set; }

    [Display(Name = "Enable User")]
    public bool status { get; set; }

    //[Bindable(false)]
    public int RoleId { get; set; }

    [Display(Name = "User Roles")]
    public virtual RolesModels Roles { get; set; }

}

问题是，我希望能够检索以下各列的记录:

The thing is, I want to be able to retrieve records with the following columns:

   User Name | Email | Registration Date | Enable User | Role Caption 

这是我的linq to sql代码:

here is my linq to sql code:

  var model = from c in db.UserModels
               join o in db.RolesModels on c.RoleId equals o.RoleId
               where 1==1
               select c;

推荐答案

我可以使用Consoto University示例项目来弄清楚. 解决方法如下:

I was able to figure it out using the Consoto University sample project. Here is the solution:

var m = db.UserModels.Include(u => u.Roles);
return View(m.ToList());

和modelItem => item.Roles.Caption，以使用导航属性从Roles模型中获取角色标题.

and modelItem => item.Roles.Caption to fetch the role caption from the Roles models using the navigational property.

感谢所有尝试.

这篇关于Linq to sql返回相关数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！