I have worked with PHP and MySQL before and recently I wanted to try and learn ASP.net MVC since some of my friends are using it in the work place. But the most confusing thing about this is, why does all the tutorials out there not mention how to work directly with a database that is stored in SQL Server?
For example, I create a database in MSSQL 2012 using "SQL Server Management Studio" and add a database in it. I switch over to Visual Studio 2010 to create a ASP.net MVC web application. Then I look online to see how the connection part work. To my surprise, almost all tutorial covers how to create databases IN visual studio and not working with one directly stored on SQL Server.
How do you even set MVC up for this? For example, the tutorials places parts of database in the Model section of MVC, but if I want to store database on SQL Server, do I leave the database information out of the "Model" folder?