Making a simple webshop in SQL and C#, need heeeelp!!

Question

Hey guys

 

For my school I am making an assignment where I have to create a webshop, a very simple one. In SQL I have created two tables, one with the different categories, and one with all the goods the store sells.

Now I need to make a C# program that can delete, add, and edit the goods, that only communicates to Console. And then I have to make a program or method that can calculate the total of the goods that the costumer might want, also in C#.

I am stuck , only got to the SQL part. I am new to this. Can anyone maybe help me or point me in a direction? Would be so amazing with the code in it self, since I am very late with this project, but a link to a tutorial would also do wonders. I have searched the internet to find something, but oh, how I hope there is a hero amongst you!

 

Thank you so much!!!

 

Fefe