how to join 2 table with asp.net mvc4

Question

how can i merge 2 table in 1 view This is my Models.

namespace ProfileApplication.Models
{
    using System;
    using System.Collections.Generic;

    public partial class EMP
    {
        public string EMP_ID { get; set; }
        public string EMP_NAME { get; set; }
        public string EMP_LNAME { get; set; }
     } 

    public partial class X_EMP_MAIL
    {
        public string EMP_ID { get; set; }
        public string EMAIL { get; set; }
    }

this is my Controtller.

public class profileController : Controller
    {
        //
        // GET: /profile/
        ProfileEntities db = new ProfileEntities();

        public ActionResult Index()
        {
            return View(db.EMP.ToList());
        }

        public ActionResult detail(string id = null) 
        {

            var query = from EMP in db.EMP

                        join X_EMP_MAIL in db.X_EMP_MAIL on EMP.EMP_ID
                             equals X_EMP_MAIL.EMP_ID

                        where   X_EMP_MAIL.EMP_ID == EMP.EMP_ID
                        select new joinproflie
                        {
                            EMP_ID    = EMP.EMP_ID,
                            EMP_NAME  = EMP.EMP_NAME,
                            EMP_LNAME = EMP.EMP_LNAME,
                            EMAIL     = X_EMP_MAIL.EMAIL
                        };

            if (query == null)
            {
                return HttpNotFound();
            }
            return View(query);
        }

this is my view

@model IEnumerable<ProfileApplication.Models.EMP>
 @foreach (var item in Model)
    {
        <tr>
            <td>@item.EMP_ID    </td>
            <td>@item.EMP_NAME  </td>
            <td>@item.EMP_LNAME </td>
            <td>@item.EMAIL </td>
         <!--   -->
        </tr>
        <br/>
    }

how should i do?

Sanjeev Rai · Accepted Answer · 2013-06-07 09:54:43Z

You can create one more viewmodel class to combine both viewmodels:

public partial class EMP_Details
{
    public string EMP_ID { get; set; }
    public string EMP_NAME { get; set; }
    public string EMP_LNAME { get; set; }
    public string EMAIL { get; set; }
 }

On controller change it to return EMP_Details viewmodel. as

public ActionResult detail(string id = null) 
    {

        var query = from EMP in db.EMP

                    join X_EMP_MAIL in db.X_EMP_MAIL on EMP.EMP_ID
                         equals X_EMP_MAIL.EMP_ID

                    where   X_EMP_MAIL.EMP_ID == EMP.EMP_ID
                    select new EMP_Details
                    {
                        EMP_ID    = EMP.EMP_ID,
                        EMP_NAME  = EMP.EMP_NAME,
                        EMP_LNAME = EMP.EMP_LNAME,
                        EMAIL     = X_EMP_MAIL.EMAIL
                    };

        if (query == null)
        {
            return HttpNotFound();
        }
        return View(query);
    }

on view change ViewModel Name as:

@model IEnumerable<ProfileApplication.Models.EMP_Details>

and you are done!

Schiavini · Accepted Answer · 2013-06-07 09:32:03Z

0

You can either create a model class with the properties EMP_ID, EMP_NAME, EMP_LNAME and EMAIL, or you can use dynamic as your model.

answered Jun 7, 2013 at 9:32

Schiavini

2,9492 gold badges27 silver badges50 bronze badges

Collectives™ on Stack Overflow

how to join 2 table with asp.net mvc4

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related