mvc crud operations without entity framework code example

Example 1: crud operation without entity framework in mvc

Create procedure [dbo].[DeleteStudent]  (     @StdId int  )  as   begin     Delete from StudentReg where Id=@StdId  End

Example 2: crud operation without entity framework in mvc

<connectionStrings>    <add name="StudentConn" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=StudentDB;Integrated Security=True;Pooling=False"/>  </connectionStrings>

Example 3: crud operation without entity framework in mvc

Create procedure [dbo].[AddNewStudent]  (     @Name nvarchar (50),     @City nvarchar (50),     @Address nvarchar (100)  )  as  begin     Insert into StudentReg values(@Name,@City,@Address)  End