Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data Model

Here select Named connection and DefaultContainerName. Then press Next button and open configure data selection dialog box as shown in the below image,


In this opened dialog box select an EntitySetName and properties. Also you should select checkbox for automatic inserts, updates and deletes and click finish button.

After that configure process, run project, and open in browser as shown in the below image,


Here you can see just student information display. It's not displaying any button for insert, update and delete.

Don’t worry, it’s very easy go to web from design in gridview control for adding Edit and delete buttons as shown in the below image,

The above image goes to gridview task and enables Editing and Deleting checkbox.

Now goes to Detailview control tasks and choose data source and enable inserting as shown in the below image,



You can see here detailview control is available as read only so you should change detailview DefaultMode properties as shown in the below image,

Next map a stored procedure for insert, update, delete operation which goes to our created Model and select and right click on that and it goes to properties as shown in the below image,


Now click on stored Procedure Mapping then open Student Mapping Detail dialog box as shown in the below image,

Here you should map created stored procedure as shown in the below image,

Here you can see all stored procedure parameter fields mapped with property fields as shown in the above image. Here you can see Student id is not mapped because it’s an auto increment primary id for all students so we cannot insert from here. So you should go to Detailview design code and primary ID datafield property make InsertVisible = “false” as shown in the below image,

When you make ID property InsertVisible = “false” then you cannot see id in detail view as shown in the below image,



Now you can see here three fields available as per our requirement. Now add one more command ItemInserting property of detailview for inserted record display on gridview as shown in the below image,

Also you should be add a single line code on Student.aspx.cs page as shown in the below image,

Now we're ready for our code add to insert, update and delete operation so you can now open web form on browser as shown in the below image,


In this above image you can see here add a new record in a table and after that try to update and delete record as shown in the below image,



Now you can check in database student table if the record is changed or not.

I hope you understood how SQL stored procedure performs with entity framework using ADO.NET Entity Data Model.

Good Day...Happy Coding