How can I use SQL Server as ASP.NET MVC database ?

Question

I am creating ASP.NET MVC project so I want to use SQL Server database in order to save my data in it so please guide me to how I can do that.

Manas Mohapatra · Answer

Please follow below link: http://www.c-sharpcorner.com/UploadFile/nipuntomar/connection-strings-for-oracle/

Joe Wilson · Answer

The other question that I have is this: could you please explain about connection string of other databases which are being used in modals of MVC like oracle too?

Joe Wilson · Answer

Well Thank you for your answer by the way I have read that the modals in MVC can connect databasecould you please explain about that?

Manas Mohapatra · Answer

Hi When you are using ASP.NET MVC application there is nothing different to use SQlServer database. If you know simple ASP.NET application - you use ADO.NET EntityFramework etc. to access SqlServer. Same way you can use same ADO.NET EntityFramework concept to use SqlServer as database. Please follow below links how they implemented: http://oakdome.com/programming/MVC3_Simple_DBContext_Class.php http://www.asp.net/mvc/overview/older-versions/hands-on-labs/aspnet-mvc-4-models-and-data-access