The Table
attribute is applied to an entity to specify the name of the database table that the entity should map to. The following example specifies that the Book
entity should map to a database table named tbl_Book
:
language-csharp
|
[Table("tbl_book")]
public class Book
{
public int BookId { get; set; }
public string Title { get; set; }
public Author Author { get; set; }
}
If the table that the entity maps to belongs to a non-default schema, the Table
attribute provides a way to specify the name of the schema through the Schema
property:
language-csharp
|
[Table("Books", Schema="library")]
public class Book
{
public int BookId { get; set; }
public string Title { get; set; }
public Author Author { get; set; }
}
Fluent API
The Fluent API equivalent to the Table
attribute is the ToTable method.