LINQ 2 SQL: AddObject and InsertOnSubmit

Question

I need to insert a record into Payment table. I found two methods to do it

1. AddObject
2. InsertOnSubmit

What is the difference between the two? When to use what?

    public void InsertEntity(DBML_Project.Payment payment)
    {
        //Insert the entity
        MyDataContext.GetTable<DBML_Project.Payment>().InsertOnSubmit(payment);
    }


public void InsertPayment(IPayment payment)
{
     this.AddObject(payment.GetType().Name, payment);
}

Answer 1

Here are some related questions:

• AddObject and Save Not Working
• Can't find InsertOnSubmit() method

They do roughly the same thing, but AddObject belongs to Microsoft's Entity Framework and InsertOnSubmit belongs to Microsoft's LINQ to SQL.

For either of them, you will want to commit the changes to the database when you're done adding objects. Call SaveChanges after AddObject and call SubmitChanges after InsertOnSubmit.

Since you mentioned that you're using LINQ to SQL, you probably want InsertOnSubmit.