How to use Database connectivity with SQL Server for MVC.

Question

Hi, I have knowledge about db connectivity for MVC. But i want to know actual process using entity framework. Please suggest best link for learn. Regards Hemlata

Santhakumar Munuswamy · Answer

Hi Hemlata Kushwaha, Refer below link http://www.mikesdotnetting.com/article/234/creating-a-connection-string-and-working-with-sql-server-localdb

Shibly Sadik · Answer

This is very simple application to create a database using entity framework.. Create a model class named Student under Model folder and write the follwing code inside the model: public class Student { public int StudentId {get;set;} public string Name {get;set;} public string Roll {get;set;} public string Dept {get;set;} } public class StudentContext:DbContext { public DbSet Students {get;set;} } //Add a controller Named StudentController public class StudentController:Controller { StudentContext db=new StudentContext(); public ActionResult AddStudent(Student student) { if(ModelState.isValid) { db.Students.add(student); db.SaveChanges(); } } } Now rebuild the project.Open the View folder.Right click on Student Folder.Select Add and then choose View.Give the view name AddStudent.Select Create template.Select model Student and choose database context s StudentContext.Click Add.You are done.Run your project. This may help you.

Francis · Answer

There are tons of tutorial available in online. But i hope learn from the Source give much insight and give deeper knowledge on EF. So i suggest the below url: http://www.asp.net/entity-framework

Harshad Pansuriya · Answer

http://www.asp.net/mvc/overview/getting-started/introduction/creating-a-connection-string

How to use Database connectivity with SQL Server for MVC.

Answers (4)