asp.net core docker Part 25 Insert update delete in mvc using entity framework

In this video we will discuss, selecting, inserting, updating and deleting data in mvc using entity framework. Please watch Part 24, before proceeding.

We will be using tables tblDepartment and tblEmployee for this demo. You can get the sql script to create and populate these tables from Part 10 of this video series.

Step 1: Create a new asp.net mvc 4 web application.

Step 2: Right click on the "Models" folder and add "ADO.NET Entity Data Model". Set Name = EmployeeDataModel.edmx.

On the subsequent screen, select "Generate from database" option and click "Next".

On "Choose your data connection screen", click on "New Connection" button.

Specify the sql server name. In my case, I have sql server installed on my local machine. So I have set "Server Name=(local)". From "Select or enter a database name" dropdownlist, select the Database name and click "OK".

Click "Next".

On "Choose your database objects" screen, expand "Tables" and select "tblDepartment" and "tblEmployee" tables. Set "Model Namespace=Models" and click "Finish"

At this point we should have tblDepartment and tblEmployee entities generated.
a) Change tblDepartment to Department
b) Change tblEmployee to Employee
c) Change tblEmployees nvigation property to Employees
d) Change tblDepartment nvigation property to Department

Right click anywhere on "EmployeeDataModel.edmx" file and select "Properties". In the properties window set
Entity Container Name = EmployeeContext

Build the solution.

Step 3: Right click on the "Controllers" folder and select Add - Controller. Set
Name = EmployeeController
Template = MVC controller with read/write actions and views, using Entity Framework
Model class = Employee(MVCDemo.Models)
Data Context Class = EmployeeContext(MVCDemo.Models)
Views = Razor

Finally click "Add".

At this point you should have the following files automatically added.
1. EmployeeController.cs file in "Controllers" folder
2. Index, Create, Edit, Detail and Delete views in "Employee" folder.

On Create and Edit views, please delete the following scripts section. We will discuss these in a later video session.
@section Scripts { @Scripts.Render("~/bundles/jqueryval")
}

At this point, if you run the application by pressing CTRL + F5, you will get an error stating - The resource cannot be found. This is because, by default, the application goes to "HOME" controller and "Index" action.

To fix this,
1. Open "RouteConfig.cs" file from "App_Start" folder
2. Set Controller = "Employee"

Run the application again. Notice that, all the employees are listed on the index view. We can also create a new employee, edit an empoyee, view their full details and delete an employee as well. However, there are few issues, with each of the views, which we will address in our upcoming videos.

Text version of the video
http://csharp-video-tutorials.blogspo...

Slides
http://csharp-video-tutorials.blogspo...

All ASP .NET MVC Text Articles
http://csharp-video-tutorials.blogspo...

All ASP .NET MVC Slides
http://csharp-video-tutorials.blogspo...

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenka...

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatAr...

asp.net core docker Part 25 Insert update delete in mvc using entity framework
602 Likes	602 Dislikes
293,056 views views	524K followers
Education View attributions	Upload TimePublished on 27 May 2013

Related keywords

wcf vs web api,sql server management studio,webkinz,create qr code,webadvisor,viewing,craigslist nj,asp.net core 3,ajax players,csharp corner,asp.net machine account,asp.net core dependency injection,model t,entity framework with oracle,update csgo,model s,ajax ontario,delete all messages,insert signature in word,asp.net mvc tutorial,selection,insert footnote word,insert drop down in excel,create new apple id,tutorialspoint python,services briefcase,ajax jquery,craigslist ny,server memes,select distinct,services online,controller pioneer,model cars,controller php,server resume,tutorialspoint javascript,view park hotel,mvcc connect,services technologies gps,create a resume,server jobs,modeling agencies,model x,website,model y,mvc tutorial,insert table of contents word,costco hours,create a gmail account,wcf service application,controlleradvice,controller ableton,tutorialspoint spring,serverless,contrôleur dj,wcf cat,deleted,model o mouse,entity framework core,services & training hse colombia sas,citibank,ajax parking,sql database,delete instagram account,updates were rejected because the tip of your current branch is behind,mvconnect,asp.net guida,cunyfirst,insert multiple rows sql,csharp online,http://asp.net,server 2019,ado.net descargar,chernobyl,model t ford,entity framework update,ado.net visual studio 2019,ado.net visual studio 2017,sql like,wcfm,delete oracle,insert checkbox in excel,modelo negra,update node,asp.net core mvc,ajax soccer,create kahoot,update viajes,update postgresql,insertional achilles tendonitis,wcfi,delete facebook,craigslist,delete sql,create email,insert multiple rows excel,tutorialspoint python 3,sql developer,webster,services transmission company sas,update windows 10,sql group by,mvc near me,selective mutism,entity framework database first,deletereas,mvc map,delete repository github,asp.net download,sql between,modeling clay,ado.net c# pdf,wcf 2019 nba,entity framework core database first,selecta fresh milk,update oracle,ado.net ventajas y desventajas,insert name here hair,create your own logo,wcf tutorial,controller for all,insert checkbox in word,tutorials dojo,central park 5,view meaning,ado.net c#,viewshare mini,controller chaos,server status,server jobs nyc,asp.net core swagger,select html,server error in '/' application,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,viewpoint,ado.net entity data model,sql insert,tutorialspoint tableau,model engine kits,sqlyog,sql server,tutorials by a,servicenow,entity framework tutorial,insert pdf into word,controllership,csharp array,csharp enum,asp.net core 2. guida completa per lo sviluppatore,server status ffxiv,model x tesla,cheap flights,asp.net core hosting,update java,model a ford,update npm,tutorialspoint java,webmd,ado.net dataset,cnn,website builder,asp.net web api,weber grills,sql server 2017,delete postgresql,asp.net core download,entity framework core nuget,viewshare diamond,delete column oracle,select all shortcut,webster bank,ajax post,services fms publish announcement,services.msc no abre,modelo abv,csharp operator,server duties,deletereo,csharp random,controller midi,mvcsd,mvcsc,ado.net pdf,asp.net core configuration,mvc medical,viewster,wcfs international curriculum,controller switch,create gmail,wcf api,server jobs near me,webex,sql meaning,sql tutorial,entity framework join,sql commands,create react app,delete element array javascript,ado.net entity framework,insert check mark in excel,model 3,ajax greek,csharp tutorial,ado.net connection,asp.net identity,modelo beer,entity framework code first,viewsonic,wcf web service,mvc webadvisor,web store,selective memory,selecta ice cream price,mvctc,entity framework migrations,update mysql,ado.net core,selection process,wcf one piece,viewfruit,weber grill parts,webtoon,tutorials by hugo,mvc design pattern,insert page break excel,servers for minecraft,ado.net tutorial,viewshare mini login,selective amnesia,services angular,createspace,controller spring,update angular cli,selecta fortified milk,delete con inner join,asp.net cos'è,csharp assembly,select a product concept,entity framework c#,create your own shirt,sql join,asp.net core web api,wccftech,delete tweets,asp.net zero,csharp foreach,sql date format,delete laravel,chase,update select,serverless architecture,view as facebook,wcf c#,server books,ado.net mysql,view-sourcehttps //www.facebook.com,create apple id,entity framework core code first,selective breeding,controller pak n64,insert row shortcut,ajax deadpool,create google account,cvs,controller angularjs,wcf soap,wcf test client,cool math games,selection sort,delete branch git,view source,servicestack,asp.net core identity,sql union,asp.net core logging,wcf nba,csharp download,wcfi foundation,wcf authentication,model s tesla,tutorials near me,web of dreams,serverminer,ajax cleaner,insert sql,webassign,ado.net vs entity framework,csharp list,delete mysql,asp.net mvc,asp.net core tutorial,sqlite,ajax roster,mvc architecture,http://ado.net,server hosting,update inner join,controller ps4,delete table,updated,ajax dish soap,controller ps4 pc,capital one,server rack,tutorialspoint html,csharp interface,entity framework 6,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,insert name here,insert into select,asp.net core signalr,services manager,mvc framework,ajax paving,update traduccion,delete column sql server,entity framework mysql,tutorialspoint spring boot,entity framework core mysql,csharp online compiler,update chrome,update from,services tag dell,csharp switch,csharpstar,entity framework many to many,selecta,modeling,tutorialspoint,controller pro switch,ajax meaning,csharp-video-tutorials.blogspot,csharp string format,viewshare,asp.net core github,ajax fc,sql formatter,credit karma,services group,selecta ice cream,http://controller.access.network,wcf ria services,calculator,view quotes,services google play apk,create yahoo email,create microsoft account,asp.net core 3 release date,view-sourcehttps //m.facebook.com/ _rdr,server job description,update bios,webcam,mvc hours,webmd symptom,ajax call,asp.net core,server pro,controller firmware revision 2.10.00 embedded media manager failed media attach,view synonym,webcrims,services sas,select2,modells,tutorialspoint java compiler,view-sourcehttps //m.facebook.com/home.php,csharp to json,selection meaning,college football,csharp dictionary,create a logo,tutorialspoint sql,server side rendering,mvc nj,tutorialspoint spark,ado.net oracle,csharp to vb.net,entity framework core postgresql,insert pdf into powerpoint,delete facebook account,webstaurant,create a website,tutorialsystems,ajax jersey,asp.net core razor pages,asp.net core environment variables,insertion sort,create tv,insert line in word,century 21,entity framework core oracle,services consultores,services consulting,services.msc,ajax marvel,sql update,asp.net tutorial,create synonym,ado.net entity data model visual studio 2019,mvc2,ado.net entity data model visual studio 2017,update sql,chase online,entity framework include,costco,update ubuntu,create a meme,controller area network,ajax tavern,controller symfony,tutorialsteacher,ajax javascript,services desk,entity framework postgresql,viewfinder,mvc pattern,ado.net sql server,mvcu,asp.net core middleware,selecta solo pack,viewpoint panel,modelo especial,mvcc,webmail,mvci,selecta ice cream flavors,