title: Take data from different tables and display it in View Index in mvc4
body: <p>I have 2 tables <code>Work_table</code> and <code>Employee_table</code>.I want to display <code>emp_id</code> from <code>Work_table</code> and corresponding <code>emp_name</code> from <code>Employee_table</code> in the index view of <code>Employee_table</code>.
  my models are:</p>
  
  <pre><code>namespace MvcConQuery.Models
  {
  [Table("Work_Table")]
  public class EnquiryModel
  {
  [Key]
  [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
  public Int32 Enq_id { get; set; }
  [Required]
  [Display(Name="Name")]
  public string CustomerName { get; set; }
  [ReadOnly(true)]
  public string Date
  {
  get
  {
  DateTime Date = DateTime.Now;
  return Date.ToString("yyyy-MM-dd"); ;
  }
  set{}
  }
  [Required]
  [Display(Name = "Region")]
  public string Region { get; set; }
  [Required]
  [RegularExpression(@"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$", ErrorMessage = "Entered phone number format is not valid.")]
  [Display(Name = "Phone number")]
  public string Ph_No { get; set; }
  [Required]
  [DataType(DataType.EmailAddress)]
  [Display(Name = "Email_id")]
  public string Email_id { get; set; }
  [Required]
  [Display(Name = "Address")]
  public string Address { get; set; }
  [Required]
  [Display(Name = "Query")]
  public string Query { get; set; }
  public string Referral { get; set; }
  public string Feedback { get; set; }
  public string Status { get; set; }
  public Int32? Emp_id { get; set; }
  public string FollowUpDate { get; set; }
  public List&lt;EmployeeModel&gt; Employees { get; set; }
  }}
  
  
  namespace MvcConQuery.Models
  {
  [Table("Employee_Table")]
  public class EmployeeModel
  {
  
  [Key,Column(Order=0)]
  [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
  //[ForeignKey("EnquiryModel")]
  public Int32 Emp_id { get; set; }
  public string Emp_Name{ get; set; }
  //[Key,Column(Order=1)]
  public string Region { get; set; }
  //[ForeignKey("Region")]
  public string Emp_PhNo { get; set; }
  public string Emp_Address { get; set; }
  public List&lt;EnquiryModel&gt; Enquires { get; set; }
  
  
  }
  
  }
  </code></pre>
  
  <p>How to write controller?
  I stucked when writing the function in controller. </p>
  
  <pre><code>public ActionResult Index()
  {
  } 
  </code></pre>
  
  <p>Please suggest a solution. thanks in advance.</p>
  
  <p>Regards</p>