DBML - DataContext - How to insert?

[Matthias S.]

Hi there,

I have added a database model to my application and dragged a couple of
tables on it. Then I wrote a couple of selects using LINQ to SQL and
everything works fine.

But I can't fingure out how to add new items. For example, I have a
table named ServiceLog. I thought I could just go like:

MyDataContext db = new MyDataContext();
db.ServiceLog.Add(new ServiceLog() {...});

But there is no such Add method. Either I've got complete wrong
expectations about how entities for the model are generated, or I made
a mistake. Can anyone help? Thanks in advance.

Matthias
--

 

[Marc Gravell]

look for InsertOnSubmit; it is perhaps ironic that there used to be an
Add etc, but is was renamed because it was causing confusion (i.e.
peopele were confused when it didn't get added until SubmitChanges was
called).

Marc\

 

[Matthias S.]

Hey Marc,

thanks a lot for your reply. Works perfectly. I was just looking in the
forest for trees

Kind Regards. Matthias

 

[Michael S]

MyDataContext db = new MyDataContext();
db.ServiceLog.Add(new ServiceLog() {...});

db.ServiceLog.InsertOnSubmit(...) and db.SubmitChanges();

- Michael Starberg