ColumnAttribute Class

ColumnAttribute Class

 

Associates a class with a column in a database table.

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

System.Object
  System.Attribute
    System.Data.Linq.Mapping.DataAttribute
      System.Data.Linq.Mapping.ColumnAttribute

[AttributeUsageAttribute(AttributeTargets.Property | AttributeTargets.Field, 
	AllowMultiple = false)]
public sealed class ColumnAttribute : DataAttribute

NameDescription
System_CAPS_pubmethodColumnAttribute()

Initializes a new instance of the ColumnAttribute class.

NameDescription
System_CAPS_pubpropertyAutoSync

Gets or sets the AutoSync enumeration.

System_CAPS_pubpropertyCanBeNull

Gets or sets whether a column can contain null values.

System_CAPS_pubpropertyDbType

Gets or sets the type of the database column.

System_CAPS_pubpropertyExpression

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

System_CAPS_pubpropertyIsDbGenerated

Gets or sets whether a column contains values that the database auto-generates.

System_CAPS_pubpropertyIsDiscriminator

Gets or sets whether a column contains a discriminator value for a LINQ to SQL inheritance hierarchy.

System_CAPS_pubpropertyIsPrimaryKey

Gets or sets whether this class member represents a column that is part or all of the primary key of the table.

System_CAPS_pubpropertyIsVersion

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

System_CAPS_pubpropertyName

Gets or sets the name of a column.(Inherited from DataAttribute.)

System_CAPS_pubpropertyStorage

Gets or sets a private storage field to hold the value from a column.(Inherited from DataAttribute.)

System_CAPS_pubpropertyTypeId

When implemented in a derived class, gets a unique identifier for this Attribute.(Inherited from Attribute.)

System_CAPS_pubpropertyUpdateCheck

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

NameDescription
System_CAPS_pubmethodEquals(Object)

This API supports the product infrastructure and is not intended to be used directly from your code. Returns a value that indicates whether this instance is equal to a specified object.(Inherited from Attribute.)

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from Attribute.)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodIsDefaultAttribute()

When overridden in a derived class, indicates whether the value of this instance is the default value for the derived class.(Inherited from Attribute.)

System_CAPS_pubmethodMatch(Object)

When overridden in a derived class, returns a value that indicates whether this instance equals a specified object.(Inherited from Attribute.)

System_CAPS_pubmethodToString()

Returns a string that represents the current object.(Inherited from Object.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethod_Attribute.GetIDsOfNames(Guid, IntPtr, UInt32, UInt32, IntPtr)

Maps a set of names to a corresponding set of dispatch identifiers.(Inherited from Attribute.)

System_CAPS_pubinterfaceSystem_CAPS_privmethod_Attribute.GetTypeInfo(UInt32, UInt32, IntPtr)

Retrieves the type information for an object, which can be used to get the type information for an interface.(Inherited from Attribute.)

System_CAPS_pubinterfaceSystem_CAPS_privmethod_Attribute.GetTypeInfoCount(UInt32)

Retrieves the number of type information interfaces that an object provides (either 0 or 1).(Inherited from Attribute.)

System_CAPS_pubinterfaceSystem_CAPS_privmethod_Attribute.Invoke(UInt32, Guid, UInt32, Int16, IntPtr, IntPtr, IntPtr, IntPtr)

Provides access to properties and methods exposed by an object.(Inherited from Attribute.)

Use this attribute to designate a member of an entity class to represent a column in a database table. You can apply this attribute to any field or property that is public, private, or internal.

Only those entity class members identified as columns are persisted when LINQ to SQL saves changes to the database.

Use commas to separate multiple properties on the attribute.

[Table(Name="Employees")]
public class Employees
{
    private string _LastName;    
    // …
    [Column(Storage="_LastName", DbType="NVarChar(20) NOT NULL", 
        CanBeNull=false)]
    public string LastName
    {
        get
        {
            return this._LastName;
        }
        set
        {
            if ((this._LastName != value))
            {
                this.OnPropertyChanging("LastName");
                this._LastName = value;
                this.OnPropertyChanged("LastName");
            }
        }
    }
}

.NET Framework
Available since 3.5
Windows Phone Silverlight
Available since 7.1

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft