Loading

Database in MVC without CRUD operation

Shibly Sadik

I want to make a student database where i want to connect,insert,update 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..

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi11y ago
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 pratik11y ago
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.