This documentation is archived and is not being maintained.

ColumnAttribute.UpdateCheck Property

Gets or sets how LINQ to SQL approaches the detection of optimistic concurrency conflicts.

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

public UpdateCheck UpdateCheck { get; set; }

Property Value

Type: System.Data.Linq.Mapping.UpdateCheck
Default = Always, unless IsVersion is true for a member.
Other values are Never and WhenChanged.

When this property is used with one of three enums, it determines how LINQ to SQL detects concurrency conflicts.

If no member is designed as IsVersion=true, original member values are compared with the current database state.

The following enums are available:

  • Always   Always use this column for conflict detection.

  • Never   Never use this column for conflict detection.

  • WhenChanged   Use this column only when the member has been changed by the application.

	[Column(Storage="_CustomerDesc", DbType="NText", UpdateCheck=UpdateCheck.Never)]
	public string CustomerDesc
	{
		get
		{
			return this._CustomerDesc;
		}
		set
		{
			if ((this._CustomerDesc != value))
			{
				this.OnCustomerDescChanging(value);
				this.SendPropertyChanging();
				this._CustomerDesc = value;
				this.SendPropertyChanged("CustomerDesc");
				this.OnCustomerDescChanged();
			}
		}
	}

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
Show: