Hello friend
Don't be frustrate , First of all for connecting database and related operation
you have option to use below library
(1) ADO.NET library
below example might useful to you .
Insertion in MVC using Ado.net | MVC Tutorials[
Insert]
Use this standard documentation for learning purpose
ADO.NET[
ADO.NET Doc]
(2) Entity Framework
Here i attached link of my code for CRUD operation with Entity Framework
Choose MVC practice option after clicking Here
for entity framework you have three option choose one of them approach
i.e..
(1) Database first
(2) Code first
(3) Model first
Please provide your code for partial view issue