This documentation is archived and is not being maintained.

ColumnAttribute.Expression Property

Gets or sets whether a column is a computed column in a database.

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

public string Expression { get; set; }

Property Value

Type: System.String
Default = empty.

Use this property when you use CreateDatabase to define a column as containing computed values.

For example, if you want to create a column defined in SQL as InventoryVal AS UnitPrice * UnitsInStock, use the following expression string: "UnitPrice * UnitsInStock".


LINQ to SQL does not support computed columns as primary keys.

	[Column(Storage="_UnitPrice", DbType="Money",Expression="UnitPrice + 1.00")]
	public System.Nullable<decimal> UnitPrice
			return this._UnitPrice;
			if ((this._UnitPrice != value))
				this._UnitPrice = 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.