How to: Represent Tables as Classes

Use the LINQ to SQL TableAttribute attribute to designate a class as an entity class associated with a database table.

To map a class to a database table

• Add the TableAttribute attribute to the class declaration.

Example

The following code establishes the Customer class as an entity class that is associated with the Customers database table.

[Table(Name = "Customers")]
public class Customer
{
    // ...
}

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

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

• The LINQ to SQL Object Model
• How to: Customize Entity Classes by Using the Code Editor