filmov
tv
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.
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
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.
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
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.
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,
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
Slides
All ASP .NET MVC Text Articles
All ASP .NET MVC Slides
All Dot Net and SQL Server Tutorials in English
All Dot Net and SQL Server Tutorials in Arabic
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
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.
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
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.
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,
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
Slides
All ASP .NET MVC Text Articles
All ASP .NET MVC Slides
All Dot Net and SQL Server Tutorials in English
All Dot Net and SQL Server Tutorials in Arabic
0:10:27
Part 25 Insert update delete in mvc using entity framework
0:29:32
GridView insert update delete without using datasource controls - Part 25
0:07:08
Implementing Incremental load in Qlikview (3.Insert,Update and Delete) #Part 25
0:10:09
Part 25 - SQL Server - Subqueries With Insert, Update and Delete By Ramesh Babu Bollu
0:05:27
SQL. Insert, Update, Delete | 11/25 | UPV
0:05:30
Insert, Update, Delete | 11/25 | UPV
0:29:37
ASP.NET - Day 25 - Insert, Update, Delete using DataList Control
0:17:33
Part 24 - How to make custom insert function & update function in php for mysql insert update qu...
3:52:29
How to Build a PC, Step by Step, Slow & Easy Computer Build Guide
0:11:59
Insert update delete in mvc using entity framework in arabic
0:23:47
GridView insert update delete in asp.net - Part 23
0:12:42
DML commands in SQL | insert , update , delete in sql | dml in sql
0:07:34
Insert update delete in asp.net c# with sql server (Step by Step) - Part 1
0:09:19
MyBatis Spring Boot Example with MySQL | Select, Insert, Update and Delete
0:08:46
CURSO SQL | DML (Select , Insert , Update , Delete) | #4
0:50:22
PHP Veritabanı İşlemleri (Select, Insert, Update, Delete)
0:01:52
Simple Insert update delete select database csharp
0:11:20
Insert Update & Delete using LINQ to SQL in ASP.NET Part 1
0:05:44
Gridview- insert update delete using stored procedures in Asp.Net
0:16:42
PowerShell SQL - Making a SQL Module Part 3 : Insert, Update, Delete
0:02:02
PHP And MySQL CRUD (Insert,Update,Delete) Tutorial - PART 1 HOW TO DOWNLOAD SUBLIME TEXT
![[WPF] Thêm xóa](https://i.ytimg.com/vi/X7oDev20D1o/hqdefault.jpg)
0:02:51
[WPF] Thêm xóa sửa (insert, update, delete) with SQLSERVER C#
0:26:21
JAVA- How To Insert Update Delete And Display Data In jTable || Part 22- Fees Management System |
0:10:12
PHP And MySQL (Insert,Update,Delete) Tutorial - PART 2 HOW TO DOWNLOAD AND INSTALL XAMPP SERVER
Комментарии