How to: Represent Columns as Class Members (LINQ to SQL)

  • Article

Use the LINQ to SQL ColumnAttribute attribute to associate a field or property with a database column.

To map a field or property to a database column

Example

The following code maps the CustomerID field in the Customer class to the CustomerID column in the Customers database table.

<Table(Name:="Customers")> _
Public Class Customer
    <Column(Name:="CustomerID")> _
    Public CustomerID As String
    ' ...
End Class

[Table(Name="Customers")]
public class customer
{
    [Column(Name="CustomerID")]
    public string CustomerID;
    // ...
}

You do not have to specify the Name property if the name can be inferred. If you do not specify a name, the name is presumed to be the same name as that of the property or field.

See Also

Concepts

The LINQ to SQL Object Model

Other Resources

How to: Customize Entity Classes by Using the Code Editor (LINQ to SQL)