How can we check the whole sql database for login username and password in mvc3 c# : I have more than one table in my sql server database.each table is for each users named developers, designers, users and so on.my home page contain a login screen.when user try to login with their username and password then it automatically check whether the username and password belongs to the database.if yes it redirect to a page else prompt an error.I need whole database check instead of one table because there is only one login page for all users.thanks