title: Can I do an INSERT with a SELECT equivalent in Entity Framework 4
body: <p>I'm migrating an application from SqlClient to the Entity Framework 4, working with SQL Server. I have a situation where I have to copy several rows from one table to another, so I do it with an INSERT ... SELECT, as below:</p>
  
  <pre><code>INSERT INTO dbo.Table1 (Reg1, Reg2, Reg3, Reg4, Reg5, Reg6, Reg7, Reg8)
  SELECT Reg1, Reg2, Reg3, Reg4, Reg5, @Reg6, GETDATE(), @Reg8
  FROM dbo.Table2 
  WHERE Reg1 = @Reg1
  </code></pre>
  
  <p>Can I accomplish something remotely similar to this with the Entity Framework, or would I have to get all of the rows from Table2, and insert them row by row in Table1? How could I handle the GETDATE()?<br>
  Tks</p>