How to get details of particular records from multiple tables in asp.net MVC

Question

I have two tables StudentPersonalInformation and EducationQualification

Here in MVC, I have create two model classes StudentPersonalInformation.cs and EducationQualification.cs, here I create the object of both classes in one wrapper class and that class Name is StudentInfo.cs

public class StudentPersonalInfo {
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
    public string StudentFirstName { get; set; }
    public string StudentLastName { get; set; }
    public int Age { get; set; }
    public string BloodGroup { get; set; }
    public string Address { get; set; }

}

public class EducationQualification {
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
    public string Graduation { get; set; }
    public int Grad_Marks_obtain { get; set; }

    public string Grad_passing_year { get; set; }
    public stringPost Graduation { get; set; }

    public int PG_Marks_obtain { get; set; }
    public string PG_passing_year { get; set; }    
}

public class StudentInfo    
{
    public StudentPersonalInfo PersonalInfo { get; set; }
    public EducationQualification EducationalQualification { get; set; }
}

This is the DBContext class:

public class StudentDbContext:DbContext
{
    public DbSet<StudentPersonalInfo> StudentPersonalInfos { get; set; }
    public DbSet<EducationQualification> EducationQualifications { get; set; }
}

And My Question is:

How to display the details by id of particular students from both tables in one view. Please tell me how to do this….

if you want yo make the view as strongly typed then create the class that contain the combination of both the class properties,bind the data with the class and display the data in views. — user3217843
– user3217843, Commented Apr 3, 2014 at 8:56
How do you know which EducationQualification belings to which student? — Gert Arnold
– Gert Arnold, Commented Apr 3, 2014 at 9:05
The most straight forward way here would be to create a stored procedure of the student detail and use Linq to get the data in the class format you require. — Yasser Shaikh
– Yasser Shaikh, Commented Apr 3, 2014 at 9:06
@Gert Arnold i dont have any relationship between two tables, i wanted to dispaly it by ID. thats meanthe studentinformation with its respective education qualification — sksk
– sksk, Commented Apr 3, 2014 at 9:13
But how do you know what to display then?? What is an EducationQualification? Is it related to students anyhow? — Gert Arnold
– Gert Arnold, Commented Apr 3, 2014 at 9:25

Maximc · Accepted Answer · 2014-04-03 09:18:16Z

1

You should make a ViewModel and in the controller action you should populate all the properties you want the view to have.

public class MyViewModelWithMultipleLists
{
       public List<StudentPersonalInfo> Students{ get; set; } 
       public List<EducationQualification> Educations{ get; set; }
       //etc
}

edited Apr 3, 2014 at 9:18

answered Apr 3, 2014 at 8:51

Maximc

1,7721 gold badge24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sksk Over a year ago

Is there any query for display the perticular student info by id

Maximc Over a year ago

In order to query your context you should use LINQ. Google 'LINQ c#' you ll find a bunch of tutorials that will teach you how to query your data.

markpsmith · Accepted Answer · 2014-04-03 09:09:33Z

First you need to create a relationship between Student and Qualification by adding a navigation property to EducationQualification, assuming each qualification has 1 student.

public virtual Student Student {get; set;}

If a student can have more than one qualification, your StudentInfo model would be more likely to look like this:

    public StudentPersonalInfo PersonalInfo { get; set; }
    public List<EducationQualification> EducationalQualification { get; set; }

So then you you can query the db, and because you have created a relationship between student and qualification, your query will look something like:

var model= (from s in Student
where s.Id = id
select new StudentInfo
{
    PersonalInfo = s,
    EducationalQualification = s.EducationQualification.ToList()
}).FirstOrDefault()

You would pass the results:

return View(model);

to a strongly typed View:

    @model StudentInfo

   @Html.DisplayFor(x => x.PersonalInfo.StudentFirstName)
   ...etc

Collectives™ on Stack Overflow

How to get details of particular records from multiple tables in asp.net MVC

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related