Linq To SQL + Move Data From One Table To Another

Hi dkilby;

Yes it can be done. But first of all Microsoft's recommendations for new projects is to use Linq to Entity Framework and not Linq to SQL. The reason for this is that that are not adding new features to Linq to SQL and only doing bug fixes. Using Linq to Entity Framework it can be done as follows

// Create the DbContext object.
TheDbContextEntities db = new TheDbContextEntities();
// Find the record to be deleted from TableA by using a query like the following
var employee = db.TableAs.Where(emp => emp.Name == "Joe").FirstOrDefault();
// Because the above record is of type TableA you will need to copy the fields from it
// to a record of type TableB. Note in this new record I did not copy the Primary key
// this will be added by TableB when inserted.
TableB moveEmployee = new TableB { Name = employee.Name, Age = employee.Age, ... };
// Add the new record to TableB 
db.TableBs.Add(moveEmployee);
// Delete the record from TableA
db.TableAs.Remove(employee);
// Save the changes.
db.SaveChanges();

Select allOpen in new window

Thank you for the info regarding Linq To SQL, will keep that in mind for any new projects.

I would like for this project to finish it off using Linq To SQL - is it possible to make the movement of a row with Linq To SQL ?

Are the two tables, TableA and TableB, have the exact same schema?

yes both tables have the same schema

Great, worked perfect thank you very much

Not a problem dkilby, glad I was able to help.