Updating an entity with linq to sql, do I need to call attach first?

Question

My code looks like:

Entity e = new Entity();

e.name = "...";
e.blah = 234;

MyDb.UpdateEntity(e);


public static void UpdateEntity(Entity e)
{
    using(MyDatacontext dc = new MyDataContext())
    {

          dc. ?????????
    }

}

So what do I do here to update the entity?

note: i just called it entity here, its something else in my project.

Answer 1

dc.GetTable<Entity>().InsertOnSubmit(e);
dc.SubmitChanges();

http://msdn.microsoft.com/en-us/library/bb763516.aspx

Answer 2

It really depends on your data context. Normally you will have an object for each table in your database. So for example if you have a database that has an orders table you will have an Orders object in your DataContext (created by dragging the table into your dbml file in the designer).

So for a new order you woud do the following:

using (var ctx = new MyDataContext()) {
    ctx.Orders.InsertOnSubmit(order);

    ctx.SubmitChanges();
}

And to save an order passed to your client and modified ther you do:

using (var ctx = new MyDataContext()) {
    ctx.Orders.Attach(order, true);

    ctx.SubmitChanges();
}