Export (0) Print
Expand All

RefreshMode Enumeration

Defines how the Refresh method handles optimistic concurrency conflicts.

Namespace:  System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

'Declaration
Public Enumeration RefreshMode
'Usage
Dim instance As RefreshMode

Member nameDescription
KeepCurrentValuesForces the Refresh method to swap the original value with the values retrieved from the database. No current value is modified.
KeepChangesForces the Refresh method to keep the current value that has been changed, but updates the other values with the database values.
OverwriteCurrentValuesForces the Refresh method to override all the current values with the values from the database.

The following example overwrites current values with values from the database.

Dim db As New Northwnd("...")

Try
    db.SubmitChanges(ConflictMode.ContinueOnConflict)

Catch ex As ChangeConflictException
    Console.WriteLine(ex.Message)

    For Each occ As ObjectChangeConflict In db.ChangeConflicts
        ' All database values overwrite current values.
        occ.Resolve(Data.Linq.RefreshMode.OverwriteCurrentValues)
    Next 

End Try

The following example shows how to swap the original value with the values retrieved from the database. No current value is modified.

Try
    db.SubmitChanges(ConflictMode.ContinueOnConflict)

Catch ex As ChangeConflictException
    Console.WriteLine(ex.Message)

    For Each occ As ObjectChangeConflict In db.ChangeConflicts
        ' No database values are merged into current.
        occ.Resolve(Data.Linq.RefreshMode.KeepCurrentValues)
    Next 

End Try

The following example keeps the current values that have been changed, but updates the other values with database values.

Try
    db.SubmitChanges(ConflictMode.ContinueOnConflict)

Catch ex As ChangeConflictException
    Console.WriteLine(ex.Message)

    For Each occ As ObjectChangeConflict In db.ChangeConflicts
        ' Automerge database values into current for members 
        ' that client has not modified.
        occ.Resolve(Data.Linq.RefreshMode.KeepChanges)
    Next 

End Try 

' Submit succeeds on second try.
db.SubmitChanges(ConflictMode.FailOnFirstConflict)

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5

Community Additions

ADD
Show:
© 2014 Microsoft