{"id":4589,"date":"2023-02-27T13:10:36","date_gmt":"2023-02-27T13:10:36","guid":{"rendered":"https:\/\/isophal.com\/?p=4589"},"modified":"2023-02-27T13:16:37","modified_gmt":"2023-02-27T13:16:37","slug":"entity-framework-new-database-first-tutorial-with-asp-net-5-for-beginners","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2023\/02\/27\/4589.html\/","title":{"rendered":"Entity Framework\u00a0<\/strong>– New Database First Tutorial With ASP.NET 5 For Beginners"},"content":{"rendered":"\n

In this chapter, we will learn Entity Framework 6<\/strong> with a new database with the help of easy programming example. We will create a demo Entity Framework Project here and explain all the steps briefly so you can understand it clearly. Before starting this chapter, following knowledge is required.<\/p>\n\n\n\n

1.<\/strong> Basic knowledge of ASP.Net MVC
2.<\/strong> SQL Server 2005\/2008\/2012
3.<\/strong> C# Programming Language<\/p>\n\n\n\n

I. ABOUT THIS CHAPTER<\/h3>\n\n\n\n

Here, I am going to create a simple MVC 5 project<\/strong> with the help of Entity Framework 6<\/strong>. This project will do the following thing.<\/p>\n\n\n\n

1.<\/strong>\u00a0One Page Design
2.<\/strong>\u00a0Create Database and Table
3.<\/strong>\u00a0Accept Entries from the User.
4.<\/strong>\u00a0Save them to database
5.<\/strong>\u00a0Display Data
6.<\/strong>\u00a0Edit Data
7.<\/strong>\u00a0Update Data
8.<\/strong>\u00a0Delete Data<\/p>\n\n\n\n

After finishing project, your application will look like:<\/p>\n\n\n\n

\"EF<\/figure>\n\n\n\n

II. Start A New ASP.NET Web Application (.NET Framework) Project<\/h2>\n\n\n\n

Here, I am using Visual Studio 2015 but you can use any of VS 2010\/2012\/2015 or 2017 version. You just have to create any version of MVC Project.<\/p>\n\n\n\n

There are 5 parts in this project and this is 2nd Part.<\/p>\n\n\n\n

PART 2:<\/p>\n\n\n\n

PART 1.<\/strong> EF \u2013 New Database First Overview<\/a>
PART 2.<\/strong>Start a New ASP.NET MVC Project
PART 3.<\/strong> Create New Database and Table for EF<\/a>
PART 4.<\/strong> Install Entity Framework and Create Entity Data Model<\/a>
PART 5.<\/strong> CRUD Operation using Entity Framework 6<\/a><\/p>\n\n\n\n

STEP 1:<\/h3>\n\n\n\n

Open Visual Studio 2015<\/strong> and Start a New Project<\/strong>.<\/p>\n\n\n\n

\"EF<\/a><\/figure>\n\n\n\n

STEP 2:<\/h3>\n\n\n\n

Select Web<\/strong> in the left panel and then select ASP.NET Web Application (.NET Framework)<\/strong> from middle panel. Give Project Name FirstEFProject<\/strong> and click OK<\/strong>.<\/p>\n\n\n\n

\"EF<\/a><\/figure>\n\n\n\n

STEP 3:<\/h3>\n\n\n\n

Select MVC<\/strong> in template window and change authentication to No Authentication<\/strong> and click OK<\/strong>.<\/p>\n\n\n\n

\"EF<\/a><\/figure>\n\n\n\n

III. Create New Database And Table For Entity Framework<\/h2>\n\n\n\n

This project is about storing and retrieving Book Details in the library so we will create database and table according to the project.<\/p>\n\n\n\n

There are 5 parts in this project and this is 3rd Part.<\/p>\n\n\n\n

PART 3:<\/p>\n\n\n\n

PART 1.<\/strong> EF \u2013 New Database First Overview<\/a>
PART 2.<\/strong> Start a New ASP.NET MVC Project<\/a>
PART 3.<\/strong>Create New Database and Table for EF
PART 4.<\/strong> Install Entity Framework and Create Entity Data Model<\/a>
PART 5.<\/strong> CRUD Operation using Entity Framework 6<\/a><\/p>\n\n\n\n

STEP 1:<\/h3>\n\n\n\n

Create Database LibraryDB<\/strong>. Open Server Explorer<\/strong> in Visual Studio. Go to View<\/strong> > Server Explorer<\/strong>.<\/p>\n\n\n\n

\"Create<\/a><\/figure>\n\n\n\n

STEP 2:<\/h3>\n\n\n\n

Right Click on Data Connections<\/strong> and click on Create New SQL Server Database<\/strong>.<\/p>\n\n\n\n

\"Create<\/a><\/figure>\n\n\n\n

STEP 3:<\/h3>\n\n\n\n

Give Server Name<\/strong> as follows and Create Database LibraryDB<\/code><\/strong>.<\/p>\n\n\n\n

\"\"\/<\/a><\/figure>\n\n\n\n

STEP 4:<\/h3>\n\n\n\n

Add a New Table BookDetails<\/strong> in the database. Expand LibraryDB<\/strong> in server explorer and right click on Tables and click on Add New Tables<\/strong>.<\/p>\n\n\n\n

\"Create<\/a><\/figure>\n\n\n\n

STEP 5:<\/h3>\n\n\n\n

Create a table as mentioned in picture. After designing table click on Update<\/strong> button to save it into the database.<\/p>\n\n\n\n

\"Create<\/a><\/figure>\n\n\n\n

STEP 6: SQL SCRIPT<\/h3>\n\n\n\n
CREATE TABLE [dbo].[BookDetails]\r\n(\r\n    [Id] INT NOT NULL PRIMARY KEY IDENTITY, \r\n    [BookName] NVARCHAR(50) NULL, \r\n    [Price] NVARCHAR(50) NULL, \r\n    [Category] NVARCHAR(50) NULL, \r\n    [AuthorName] NVARCHAR(50) NULL, \r\n    [Edition] NVARCHAR(50) NULL, \r\n    [BookCondition] NVARCHAR(50) NULL, \r\n    [Available] NCHAR(10) NULL\r\n)<\/code><\/pre>\n\n\n\n
SUMMARY:<\/h3>\n\n\n\n
In this chapter, you created SQL Database and a Table. In the next chapter, we will\u00a0Install Entity Framework and Create Data Model.<\/strong><\/p>\n\n\n\n
IV. Install Entity Framework And Create Entity Data Model<\/h2>\n\n\n\n
There are 5 parts in this project and this is 4th Part.<\/p>\n\n\n\n
PART 4:<\/p>\n\n\n\n
PART 1.<\/strong> EF \u2013 New Database First Overview<\/a>
PART 2.<\/strong> Start a New ASP.NET MVC Project<\/a>
PART 3.<\/strong> Create New Database and Table for EF<\/a>
PART 4.<\/strong>Install Entity Framework and Create Entity Data Model
PART 5.<\/strong> CRUD Operation using Entity Framework 6<\/a>
<\/p>\n\n\n\n
If you haven’t install Entity Framework yet, then you can install easily. Just read the following installing guide.<\/p>\n\n\n\n
1.<\/strong> Right click<\/strong> on Project Name<\/strong> in Solution Explorer and Click Manage NuGet Packages\u2026<\/strong>
2.<\/strong> NuGet Package Manager<\/strong> Window will be open. Here, Browse for Entity Framework<\/strong>. Now, Click Install Icon<\/strong> or Install button<\/strong> to Installing it into your project.
3.<\/strong> A Review Changes<\/strong> Dialog box will appear. Click OK<\/strong>.
4.<\/strong> Accept License Agreement<\/strong> by clicking on I Accept<\/strong> button.
5.<\/strong> Now, you can see Entity Framework<\/strong> under References<\/strong> in Solution Explorer<\/strong>.<\/p>\n\n\n\n
Here, is a Step by Step Pictorial Guide of Installing Entity Framework 6. Install Entity Framework 6 Pictorial Guide<\/a><\/p>\n\n\n\n
CREATE ENTITY DATA MODEL<\/h3>\n\n\n\n
STEP 1:<\/h3>\n\n\n\n
Right Click<\/strong> on Model<\/strong> Folder in Solution Explorer<\/strong> and click Add<\/strong> > New Item<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 2:<\/h3>\n\n\n\n
Select Data<\/strong> in Left Pane<\/strong> and then choose ADO.NET Entity Data Model<\/strong> in the middle pane<\/strong>. Give the name to BookDataModel<\/code> and click Add<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 3:<\/h3>\n\n\n\n
Entity Data Model Wizard<\/strong> will appear that will ask you to choose your data model. Choose EF Designer from Database<\/strong> and click Next<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 4:<\/h3>\n\n\n\n
In the next wizard choose the connection properties for your connection string. Just check the radio button<\/strong> saying “Yes, include the sensitive data in the connection string.”<\/strong> And make sure the check box is checked<\/strong> which asked you to “Save connection setting in Web.Config as:”<\/strong> and click Next<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 4:<\/h3>\n\n\n\n
Select Entity Framework 6.x<\/strong> if Wizard asks you to choose Entity Framework<\/strong> version and click Next<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 5:<\/h3>\n\n\n\n
In the next Windows select object of the database. You must select your table BookDetails<\/code> and click Finish<\/strong>.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
STEP 6:<\/h3>\n\n\n\n
If everything goes fine then you will see your BookDataModel<\/code> in designer mode.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
Congratulations!<\/strong> You have successfully created entity data model from new database. Now you will see that inserting, updating and deleting operation with a table is so much easy with the help of your BookDataModel.<\/p>\n\n\n\n
V. MVC 5 CRUD Operation Using Entity Framework 6<\/h2>\n\n\n\n
Till now, you have completed all the previous chapters. This is the time to combine all the work together and display output in a web browser. You are using Entity Framework so, you don’t need to worry about writing SQL queries and connection for database operation. All database part will be handled by EF automatically.<\/p>\n\n\n\n
There are 5 parts in this project and this is 5th Part.<\/p>\n\n\n\n
PART 5:<\/p>\n\n\n\n
PART 1.<\/strong> EF \u2013 New Database First Overview<\/a>
PART 2.<\/strong> Start a New ASP.NET MVC Project<\/a>
PART 3.<\/strong> Create New Database and Table for EF<\/a>
PART 4.<\/strong> Install Entity Framework and Create Entity Data Model<\/a>
PART 5.<\/strong>CRUD Operation using Entity Framework 6
<\/p>\n\n\n\n
Add a new Scaffolding Item to Controller<\/p>\n\n\n\n
STEP 1:<\/h3>\n\n\n\n
Right click<\/strong> on Controller folder. Select Add > New Scaffolded Item.<\/strong><\/p>\n\n\n\n
\"MVC<\/a><\/figure>\n\n\n\n
STEP 2:<\/h3>\n\n\n\n
A window will open. Select MVC5 Controller with views, using Entity Framework<\/strong> and click on Add<\/strong> button.<\/p>\n\n\n\n
\"MVC<\/a><\/figure>\n\n\n\n
STEP 3:<\/h3>\n\n\n\n
An Add Controller<\/strong> window will open. In Model class<\/strong>, select BookDetails (FirstEFProject.Models)<\/code> and in the Data context<\/strong> class, select LibraryDBEntities (FirstEFProject.Models)<\/code> and click on ADD<\/code> button.<\/p>\n\n\n\n
\"MVC<\/a><\/figure>\n\n\n\n
STEP 4:<\/h3>\n\n\n\n
Now, see the Solution Explorer<\/strong>. You will notice that a BookDetailsController.cs<\/code> is automatically added. You will also notice that BookDetails<\/strong> Views is also automatically added.<\/p>\n\n\n\n
\"MVC<\/a><\/figure>\n\n\n\n
STEP 5:<\/h3>\n\n\n\n
Set BookDetailsController<\/code> to start page. Expand App_Start<\/strong> folder in solution explorer and open RouteConfig.cs<\/code><\/strong>.<\/p>\n\n\n\n
\"App_Start<\/a><\/figure>\n\n\n\n
STEP 6:<\/h3>\n\n\n\n
Here change controller name Home to\u00a0BookDetails<\/strong><\/p>\n\n\n\n
defaults: new { controller = \"BookDetails\", action = \"Index\", id = UrlParameter.Optional }<\/pre>\n\n\n\n
STEP 7:<\/h3>\n\n\n\n
Press F5<\/strong> to run your project.<\/p>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
OUTPUT PICTURE<\/h3>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
\"EF<\/a><\/figure>\n\n\n\n
SUMMARY:<\/h3>\n\n\n\n
Till now, you learned how to\u00a0create an MVC 5 Project with Entity Framework 6<\/strong>\u00a0with Database First. I hope you won\u2019t get any trouble creating this project. If you have any trouble then you can post your problem in the comment section. In the next chapter.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this chapter, we will learn Entity Framework…<\/p>\n","protected":false},"author":1,"featured_media":4590,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189],"tags":[191,576,577],"class_list":["post-4589","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net","tag-asp-net","tag-entity-framework","tag-mvc"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=4589"}],"version-history":[{"count":2,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4589\/revisions"}],"predecessor-version":[{"id":4593,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4589\/revisions\/4593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/4590"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=4589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=4589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=4589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}