Database in MVC without CRUD operation

Question

I want to make a student database where i want to connectinsertupdate and delete database using SQL command without using CRUD operation.. like as below.. SqlConnection conn= new SqlConnection(connection string); SqlCommand cmd= new SqlCommand() ...e.t.c How can i do it? Explain me details please..

Jignesh Trivedi · Answer

CRUD means - CREATE READ UPDATE and DELETE and you want to perform connect insert update and delete database using SQL command I did not get your question

shivendra pratik · Answer

You can achieve this by writing store procedures in the database and make a call to them by making a SqlConnection from your code and execute them.