Insert/Select with Linq-To-SQL

Question

Is there a way to do an insert/select with Linq that translates to this sql:

INSERT INTO TableA (...)
SELECT ...
FROM TableB
WHERE ...

Answer 1

context
  .TableA
  .InsertAllOnSubmit(
    context
      .TableB
      .Where( ... )
      .Select(b => new A { ... })
  );

Answer 2

Yes @bzlm covered it first, but if you prefer something a bit more verbose:

// dc = DataContext, assumes TableA contains items of type A
var toInsert = from b in TableB
               where ...
               select new A 
               {
                   ...
               };

TableA.InsertAllOnSubmit(toInsert);
dc.SubmitChanges();

I kind of prefer this from a review/maintenance point of view as I think its a bit more obvious what's going on in the select.