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

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 .