MVC5 and EF6 Code First a complete example tutorial for getting Started

MVC is not a fire today, I am going to introduce a practical example of MVC5 and EF6 development, because the EF6 default is code first, so I will use the EF6 code first to make a simple example, in order to make the instance appear simple, here is a table To show the records of a table, and the model and the Dal are all in one project. Here are the detailed steps:

1. Create an MVC project open VS2013 New Project A Web project, the framework selected. NET Framewok4.5, the project name is Miniprofilerdemo. Such as:

Next, in the popup window, select the project template for MVC, such as:

2. Add Install EF Framework Dependency package to project

Select the project you just built, and right-click the following menu:

Click "Manage NuGet Packages" and click "Install" in the following screen entityframework 6.1

After the installation is successful, the associated DLL references are automatically added to the project.

3. Add a model to select the Models folder in the project and add a product class:

2. Namespace Miniprofilerdemo. Models
4. {
6. public class Product
8. {
10. public int ID { get; set; }
12. public string Name { get; set; }
14. public decimal price { get; set; }
16. public int Quantity { get; set; }
18. }
20. }

4. Add a context class for EF

Add an EF context class for the project to use as a public class for accessing the database:

2. Using miniprofilerdemo. Models;
4. Using System. Data. Entity;
8. Namespace Miniprofilerdemo. DAL
10. {
12. public class efdbcontext:DbContext
14. {
16. public DbSet<Product> Products { get; set; }
18. }
20. }

To include a database link in Web. config:

1. <connectionStrings>
2. <add name="Efdbcontext" connectionString="server=.;D Atabase=miniprofilerdemo;uid=sa;pwd=sa; " providerName="System.Data.SqlClient" />
3. </connectionStrings>

Note:The database link string above is based on your own database to make the appropriate adjustments, the database link node named "Efdbcontext" and the above-built EF's context class name. There is no node name specified in the EF context class, the default is that the class name is the same as the database link configuration node, and of course you can do it differently in practice, but this will add a constructor to your EF context class:

1. Public Efdbcontext(): base("Database linked node name")
2. {
4. }

5. Create a controller and view that shows the model class

1. Select the Controller folder for the project and add a controller named product

2. Using miniprofilerdemo. DAL;
4. Using System. LINQ;
6. Using System. Web. MVC;
10. Namespace Miniprofilerdemo. Controllers
12. {
14. public class productcontroller : Controller
16. {
18. public actionresult Index()
20. {
22. Using (efdbcontext db=new efdbcontext())
24. {
26. var m = db. Products. ToList();
28. return View(m);
30. }
32. }
34. }
36. }

2, move the cursor to the above action for the index method, right-click on the pop-up menu "Add View", enter the following content:

2. @model List<miniprofilerdemo. Models. Product>
4. @{
6. ViewBag. Title = "ProductList";
8. }
12. productlist</h2>
14. <table class= "Table" >
16. <thead>
18. <tr>
20. <th>id</th>
22. <th>Name</th>
24. <th>price</th>
26. <th>Quantity</th>
28. </tr>
30. </thead>
32. <tbody>
34. @foreach (var item in Model)
36. {
38. <tr>
40. <td> @item. id</td>
42. <td>@item. Name</td>
44. <td> @item. price</td>
46. <td>@item. Quantity</td>
48. </tr>
50. }
52. </tbody>
54. </table>

The model type of the binding for this view is strongly typed List<miniprofilerdemo.models.product>, and the data record is presented in a table.

6. View page, run results

The first run of the page, there is no data, this is normal, because the beginning of the database is not yet, when running EF will automatically create a database and model corresponding to the database link and EF context, such as:

Let's manually open the table product and add some records

Refresh the page again with the data you just added, such as:

MVC5 and EF6 Code First a complete example tutorial for getting Started