How do I add an object to the database using Linq to SQL?

Question

I'm trying to learn LINQ to SQL and I'm able to query the database and get back an IQueryable and manipulate the objects I retrieve from that. But I've no idea how to add a new object back into the database or into the original IQueryable.

private DataContext db;
private IQueryable<ActionType> action;

public void BuildQuery(string connection) {
    db = new DataContext(connection);
    action = db.GetTable<ActionType>().Select(a=>a);

    ActionType at = new ActionType();
    at.Name = "New Action Type";

    // What now? action.add(at) || db.GetTable<ActionType>.add(at); ??
}

It's a suprisingly hard thing to search for if you don't know the right terms. And I can't find any examples that do exactly what I want them to do.

So, how do I go about adding new objects to a query/database?

marc_s · Accepted Answer · 2009-09-04 07:35:21Z

9

To insert your newly created instance of "ActionType", you need add your object to the data context (and "add" was renamed to "InsertOnSubmit" during Linq-to-SQL beta) and then call SubmitChanges on the data context:

public void BuildQuery(string connection) {
    db = new DataContext(connection);
    action = db.GetTable<ActionType>().Select(a=>a);

    ActionType at = new ActionType();
    at.Name = "New Action Type";

    // What now? action.add(at) || db.GetTable<ActionType>.add(at); ??
    db.ActionTypes.InsertOnSubmit(at);
    db.SubmitChanges();
}

See this blog post here why you should be using InsertOnSubmit over Attach.

Marc

edited Sep 4, 2009 at 7:35

answered Sep 4, 2009 at 7:13

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tarik Over a year ago

Shouldn't it be something like this : db.ActionTypes.InsertOnSubmit(at);

Tarik · Accepted Answer · 2009-09-04 07:30:52Z

2

private DataContext db;
private IQueryable<ActionType> action;

public void BuildQuery(string connection) {
   db = new DataContext(connection);
   action = db.GetTable<ActionType>().Select(a=>a);

   ActionType at = new ActionType();
   at.Name = "New Action Type";

   //There must be a table like ActionType and it seems ActionTypes when calling it ith   // db
   db.ActionTypes.InsertOnSubmit(at);
   db.SubmitChanges();
}

You can see a nice example here : Click Here

answered Sep 4, 2009 at 7:30

Tarik

82.2k86 gold badges243 silver badges351 bronze badges

1 Comment

Tarik Over a year ago

No problem it happens sometimes :)

Robban · Accepted Answer · 2009-09-04 07:13:37Z

0

Now all you need to do is submit your changes back to the database:

db.Attach(at);
db.SubmitChanges();

answered Sep 4, 2009 at 7:13

Robban

6,8372 gold badges42 silver badges49 bronze badges

1 Comment

marc_s Over a year ago

I believe you should be using InsertOnSubmit instead of Attach

Alex · Accepted Answer · 2009-09-04 09:33:32Z

0

I'd wrap the DataContext within a using statement - it ensures it is disposed of, when the operation is complete.

Like this:

public void BuildQuery(string connection) 
{
    using (var db = new DataContext(connection))
    {
        action = db.GetTable<ActionType>().Select(a=>a);

        ActionType at = new ActionType();
        at.Name = "New Action Type";

        // What now? action.add(at) || db.GetTable<ActionType>.add(at); ??
        db.ActionTypes.InsertOnSubmit(at);
        db.SubmitChanges();
    }
}

answered Sep 4, 2009 at 9:33

Alex

38.6k55 gold badges217 silver badges340 bronze badges

1 Comment

Josh Smeaton Over a year ago

I'm going to be using the datacontext in future operations. It's instantiated in the contructor. For the purpose of this question, I rearranged things so it was all visible. But thanks for the heads up in the future.

Collectives™ on Stack Overflow

How do I add an object to the database using Linq to SQL?

4 Answers 4

1 Comment

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest