Database in MVC without CRUD operation

Question

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..