Updating multiple tables with LINQ and ASP.NET MVC

Question

Just a quick one really, I'm just looking for a bit of clarification.

I'm looking to update multiple tables from one "Create" action, before I try it, I was just wondering if it's possible to simply just do the following:

db.hdCalls.InsertOnSubmit(a)
db.hdCustomers.InsertOnSubmit(b)
db.hdAssign.InsertOnSubmit(c)
db.SubmitChanges()

Or is it slightly more complicated than that?

JustLoren · Accepted Answer · 2009-10-21 15:59:21Z

4

Yes, SubmitChanges will then call 3 inserts.

answered Oct 21, 2009 at 15:59

JustLoren

3,2343 gold badges31 silver badges34 bronze badges

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

Comments

Martin at Mennt · Accepted Answer · 2010-01-18 20:33:50Z

1

A small question even if this post is old.

What if one of the inserts fails, will all the other inserts rollback? Because if one fail, I sure does not want any of the other inserts to commit.

How is this handled?

answered Jan 18, 2010 at 20:33

Martin at Mennt

5,73714 gold badges64 silver badges90 bronze badges

1 Comment

LiamGu Over a year ago

It's my understanding that if any of those fail under db.SubmitChanges() the whole insert fails, not just one.

Collectives™ on Stack Overflow

Updating multiple tables with LINQ and ASP.NET MVC

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related