How to Create multiple Database Tables and use them In one Controller

Question

I would like to create mutliple database tables and control them in one controller
what would be the best approach for doing that,

I thought about Creating multiple Connectionstrings (and Data Contextes, and multiple Services in the Startup.cs)
but once i start scaffolding them i can only control them in differend controllers.
And it would not be scalable if i want 20 database tables

It might better to have one Database table that links to different tables

but im not quite sure how to do that or if thats even a good idea?

and how to link the Models to those tables

Sachin Singh · Answer

you can create 100 of tables , but if you need 100 table's data to display in view then you need to create a viewmodel which includes all other individual models as properties . for example you have student table and teacher table and you want to display both on a view then create a studentTeacherVM like below public class Student { public int id{get;set;} public string Name{get;set;} } public class Teacher { public int Id{get;set;} public string Name {get;set;} } public class studentTeacherVM { public Student student {get;set;} public Teacher teacher {get;set;} } other way of creating viewmodel is to include properties public class Student { public int StudentId{get;set;} public string StudentName{get;set;} public int TeacherId{get;set;} public string TeacherName {get;set;} } now fetch data using join statements and use viewmodel .