10 TIPs - To Become a Good Developer/Programmer
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Eswar Datta
2k
115
4.9k
Stored Procedure in MVC
Jun 12 2018 4:07 AM
I created two tables in sql-server
1. Employeedata contains employee details
2. Registration table.
Now i created StoredProcedure to insert data in to Registration table it retreiving data from Employeedata table.
stored procedure
CREATE
procedure
[dbo].[RegistrationInsert](
@empEmail nvarchar(
max
),
@
password
nvarchar (
max
)
)
as
begin
insert
into
[Registration ] ([EmployeeName],[EmployeeEmail],[
Password
],[PhoneNumber],[Role],[EmployeeID])
select
[EmployeeName],[EmployeeMailID],@
password
,[EmployeePhoneNumber],[EmployeeDesignation],[EmployeeID]
from
[Employeedata ]
where
[EmployeeMailID] = @empEmail
end
GO
But i don't know how to call this procedure in MVC controller.
Reply
Answers (
3
)
how to improve speed of file read write opeartion
I need to delete gridview row