In SQL, sometimes we need to select some data from one table and insert data into another table, this can be done as follows with a simple sql query:
Insert into Table1 (c1, c2, c3, c4, c5)
(Select c1, c2, c3, c4, c5 from Table2)
But make sure that both the tables have same fields, data type..
This article will explain you how to create, read, insert, update, delete operations with asp.net mvc with ado.net entity model.
Very nice article who are beginners with asp.net mvc framework.