ColumnAttribute.Expression Property
Gets or sets whether a column is a computed column in a database.
Assembly: System.Data.Linq (in System.Data.Linq.dll)
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".
Note |
|---|
LINQ to SQL does not support computed columns as primary keys. |
| Topic | Location |
|---|---|
| How to: Represent Computed Columns (LINQ to SQL) | |
| How to: Represent Computed Columns (LINQ to SQL) | LINQ to SQL |
[Column(Storage="_UnitPrice", DbType="Money",Expression="UnitPrice + 1.00")] public System.Nullable<decimal> UnitPrice { get { return this._UnitPrice; } set { if ((this._UnitPrice != value)) { this.OnUnitPriceChanging(value); this.SendPropertyChanging(); this._UnitPrice = value; this.SendPropertyChanged("UnitPrice"); this.OnUnitPriceChanged(); } } }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Note