tags:

views:

187

answers:

1
Q: 

Linq: How to verify dbcontext.SubmitChanges() for updates/inserts succeeded?

How do you verify that SubmitChanges() worked for inserts and updates? The method doesn't return a bool or int value.

+1  A: 

If an insert fails it will throw a SqlException. I think it may do the same for failed updates.

jrummell  2009-09-25 16:51:18
I guess i'll just wrap the call with a try and catch
burnt1ce  2009-09-25 18:06:39
Throwing an exception on error is typically recommended over returning a boolean or affected row count. So I would recommend only catching the exception if you can do something about it (like log and rethrow).
jrummell  2009-09-25 18:49:02

related questions

How to find an implementation of a C# interface in the current assembly with a specific name?
Learning about LINQ
LINQ to SQL Mapping From Money to Double
SQL Server 2008 vs 2005 Linq integration
Aging Data Structure in C#
LINQ-to-SQL vs stored procedures?
LINQ, entity that implements Interface and exception in mapping
How can I remove nodes from a SiteMapNodeCollection?
Conditional Linq Queries
LINQ query on a DataTable
Expression.Invoke in Entity Framework?
How to return a page of results from SQL?
Import Namespace System.Query
Has anyone run performance benchmarks comparing LINQ
Beginners Guide to LINQ
Querying like Linq when you don't have Linq.
Linq to objects - select first object
C# 3.0 Where extension method with lambda vs LINQtoObjects to filter in memory collections.
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
LINQ on the .NET 2.0 Runtime
How do I most elegantly express left join with aggregate SQL as LINQ query
How do you page a collection with LINQ?
How do I get a distinct, ordered list of names from a DataTable using Linq
How do I fill a DataSet or a DataTable from a LINQ query resultset ?