Using Linq to Sql, does not update, but does not throw exception

Question

Running .net 2008, asp.net, Linq to sql, sql server 2008 express

Foo f = db.Foo.First(x => x.ID == id);
f.IsValid = true;
db.SubmitChanges();

I have a very basic table, which has several fields, and no FK constraints. None of the data saves when I call .SubmitChanges(), but no error is thrown. Any ideas?

Not using any explicit transaction scope, fields are not autogenerated, and no triggers on the server.

Community · Accepted Answer · 2017-05-23 12:32:58Z

4

Tyop aside, the first thing to try is setting db.Log = Console.Out; to see if any TSQL is issues (or better: run a SQL trace). If nothing is getting sent then maybe IsValid was already true - it won't re-save such changes unless it has to (unless you force it).

Less likely, you could perhaps have accidentally turning off object-tracking (db.ObjectTrackingEnabled).

Other common mistakes include:

not calling Complete() when using TransactionScope (if you are using TransactionScope)
with database files (rather than a separate server), checking in the original file (in the solution) rather than in the build output (typically /bin/debug or /bin/release).

I'm also assuming that IsValid is actually a db-mapped property (they don't have to be)

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Mar 22, 2010 at 16:33

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

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

3 Comments

Russell Steen Over a year ago

Marking this as the solution, since it led me to the solution.

Doctor Jones Over a year ago

@Marc this issue can also be caused by the table not having a PK defined. In this case LINQ to SQL will silently ignore changes.

Pasindu Over a year ago

And for those who using Entity Framework 6 db.Database.Log = Console.Write

Klaus Byskov Pedersen · Accepted Answer · 2010-03-22 15:57:27Z

2

You need to set IsValid on f and not on x.

Foo f = db.Foo.First(x => x.ID == id); 
f.IsValid = true; 
db.SubmitChanges();

And remember to call Complete on your TransactionScope if you are using one.

answered Mar 22, 2010 at 15:57

Klaus Byskov Pedersen

122k31 gold badges192 silver badges222 bronze badges

1 Comment

Russell Steen Over a year ago

that was a typo. x.IsValid wouldn't compile, much less not throw an exception ;) Thanks for the catch

tvanfosson · Accepted Answer · 2010-03-22 16:01:46Z

2

Is IsValid marked as an AutoGenerated field in the designer? If so, no changes that you make will be propagated back to the server. Also, is it possible that you have a DB trigger that may be running on update, instead of say on insert, that is setting it to a default value of 0 (false)?

answered Mar 22, 2010 at 16:01

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

Comments

Russell Steen · Accepted Answer · 2010-03-22 16:35:03Z

1

Turns out that the primary key had been dropped from the DB since the last time I was working with this application. When I regenerated the .dbml recently it generated with no primary key. Adding that back in has fixed the problem.

answered Mar 22, 2010 at 16:35

Russell Steen

6,6126 gold badges40 silver badges57 bronze badges

Collectives™ on Stack Overflow

Using Linq to Sql, does not update, but does not throw exception

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related