Create classes when reading from multiple tables in C#

Question

I have tables in the database named

Students (StudentId,Name,Address)
Subjects (SubjectId,SubName)
Stud_Subjects (StudentId,SubjectId)

And I hv created c# classes for Student and Subject. I want to take data from Stud_Subjects table do i need to create another class named "Stud_Subject". How to add add properties to that class.

lets say I want to get data joining these tables and the result should be like this.

(StudentId,Name,SubName)

How to map these result into C# class. do i have to create another class with above three fields.

Is that a mapping table Stud_Subjects? Post the table definition — Sriram Sakthivel
– Sriram Sakthivel, Commented Jul 20, 2014 at 16:25

Sriram Sakthivel · Accepted Answer · 2014-07-20 16:36:46Z

1

Two classes is enough. One for Student one for Subject. It looks like Stud_Subjects table is for "Many-Many relationship", you can implement that via a collection.

class Student
{
    public int StudentId { get; set; }
    public string Name { get; set; }
    public string Address { get; set; }

    public List<Subject> Subjects { get; private set; }
}

class Subject
{
    public int SubjectId { get; set; }
    public string SubjectName { get; set; }

    public List<Student> Students { get; private set; }
}

Subjects collection in Student class will have all the subjects which a student is mapped and Students collection in Subject class will have all the students which is mapped to current Subject.

You could also consider converting List<T> to Dictionary<int, Student> and Dictionary<int, Subject> for easy access them via their Ids

answered Jul 20, 2014 at 16:36

Sriram Sakthivel

73.8k7 gold badges118 silver badges200 bronze badges

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

2 Comments

Daybreaker Over a year ago

Thank u very very much dude.. I think it is the answer.

Sriram Sakthivel Over a year ago

@Daybreaker Welcome, make sure you see my edit. thanks.

Collectives™ on Stack Overflow

Create classes when reading from multiple tables in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related