This documentation is archived and is not being maintained.

ColumnAttribute.IsVersion Property

Gets or sets whether the column type of the member is a database timestamp or version number.

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

public bool IsVersion { get; set; }

Property Value

Type: System.Boolean
Default value = false.

Version numbers are incremented and timestamp columns are updated every time that the associated row is updated. (This property tells LINQ to SQL that a column should be updated to show that it is a new version; it is not meant to record information such as who made the update.)

Note the following when IsVersion is true:

  • Use DbType to specify the correct modifiers to designate a version number or timestamp column. If you do not specify DbType, LINQ to SQL infers the correct modifiers.

Version numbers are incremented and timestamp columns are updated every time that the associated row is updated. Members with IsVersion=true are synchronized immediately after the data row is updated. The new values are visible after SubmitChanges finishes.


[Column(Storage = "_VersionNum", DbType = "Int NOT NULL IDENTITY", IsVersion=true)]
public int VersionNum
{
    get
    {
        return this._VersionNum;
    }

    set
    {
        if ((this._VersionNum != value))
        {
            this._VersionNum = value;
        }
    }
}


.NET Framework

Supported in: 4, 3.5

.NET Framework Client Profile

Supported in: 4

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Show: