score:3
Accepted answer
SubmitChanges will send the DML statements. Commit will commit the transaction. While the transaction is not committed, other readers will not see your changes. You have no risk of saving partial changes or even making them visible for a shot period of time. You can call SubmitChanges multiple times. Without an explicit transaction SubmitChanges will use one internally.
Source: stackoverflow.com
Related Query
- Determine the source DataContext for a Linq to Sql query
- Is maintain the transaction with a static LINQ to SQL DataContext in asp.net possible?
- TransactionScope vs Transaction in LINQ to SQL
- How are people unit testing code that uses Linq to SQL
- How can you see the sql that is causing an error on SubmitChanges in LINQ to SQL?
- LINQ Source Code Available
- Linq to SQL DataContext fails to update Enum field in database for inherited objects
- Linq DataContext SubmitChanges InvalidOperationException from ZombieCheck
- Does LINQ To SQL auto update the LOCAL/CLIENT id column after a SubmitChanges call?
- LinQ DataContext - The operation cannot be performed during a call to SubmitChanges
- How to code the partial extensions that Linq to SQL autogenerates?
- Linq to SQL DataContext Lifetime Management Issue
- LINQ to SQL transaction and read ID of inserted record
- How to get SQL query into LINQ form in C# code
- Using SubmitChanges to create a LINQ Transaction
- Linq To SQL Overriding SubmitChanges Method (VB.NET)
- Multiple Database connections in a LINQ to SQL DataContext
- Linq to SQL intellisense has no knowledge of tables within the datacontext object
- creating Linq to sqlite dbml from DbLinq source code
- Can I prevent a LINQ DataContext from using a transaction when a TransactionScope is present?
- Does LINQ convert code to SQL queries
- How do i convert this linq code to inline sql
- Reuse Linq to SQL code with entityframework
- Identify source of linq to sql query
- Linq to sql as object data source - designer problem with partial classes
- isolation level in linq to sql , DataContext
- linq to sql transaction
- SQL subquery result in LINQ and Entity Framework Code First
- LINQ to SQL DataContext Is Not Updating ConnectionString
- Accessing SQL Server time in code with LINQ
More Query from same tag
- LINQ - Aggregate and calculate several parameters
- Aging Data Structure in C#
- How to convert Expression<Func<T, object>> to Expression<Func<object, object>>
- Is LINQ (or linq) a niche tool, or is it on the path to becoming foundational?
- updating multiple records in database with linq to sql without loop, is it possible?
- Getting an error when i am changing my folder location
- .ToList on IQueryable causes NullReferenceException when executed in background
- Add Role to a User just as they Register
- Flatten and group complex objects in Linq and preserve null children
- LINQ query string[] group by multiple anonymous columns
- Get sum of "quantity" when grouping by a property
- Filter result using linq to return a count of entries by remove duplicates using specific parameter
- LINQ DeleteOnSubmit without Primary key
- What's the LINQ'ish way to do this
- How to use LINQ to get data from an XML file?
- LINQ xml finding nodes returns null
- regex for phrase searching
- Parent and Child fluent Linq query in C#?
- How to Remove Range after Add Range in same operation
- Possible to do this in better than O(n^2) time?
- XElement NullReferenceException
- How can we assume a bool Property on a Generic<T> class , where T is a auto generated LINQ2SQL class
- Access Query in Linq
- Translate query with operator 'IN' in Linq
- Update list items based on months in C#
- Lambda "cannot be inferred from the usage"
- LINQ joining two tables
- EntityFunctions.AsNonUnicode equivalent for .NET Core
- how to extract xml node using LinqtoXml
- SQL Server query with subquery to LINQ query
