Add data from List to database in mvc

Question

I am developing a simple shopping cart in asp.net mvc. I created a list and stored the list item in a Session variable
called Session["cart"].

List<Item> cart=(List <Item>) Session["cart"];
Where Item is a class inside controller folder.

Now how can i store the records from Session["cart"]
to my database table called "Orders"??

Vignesh Mani · Answer

Hi Refer below link. http://www.codeproject.com/Questions/622603/How-to-add-data-into-an-unordered-list-from-databa

Shuvojit Halder · Answer

l is table object in linq query.

Shibly Sadik · Answer

What is I that u written in (from I)?

Shuvojit Halder · Answer

your code should be var _list = (from l in db. Orders select new cart { cartItem1 =l.tabledata1 cartItem2 =l.tabledata2 cartItem3 =l.tabledata3 cartItem4 =l.tabledata4 cartItem5 =l.tabledata5 }).ToList(); Session[cart]= _list;