Database table

As explained in .NET in Action, Second Edition

A table is a database structure that stores related records in rows and columns.

A database table stores related records in rows and columns. In EF Core code-first, an entity included in a DbContext can generate a table; a Book entity maps to a Books table. section 5.2

Key implementation details:

• A table commonly uses a primary key to identify rows uniquely. EF Core conventionally treats an entity’s Id property as its key; a [Key] attribute can designate another property, such as ISBN. section 5.2
• A DbSet<Book> property in a DbContext makes the Books table accessible to the application. section 5.2

Figure 5.1 Books table generated by EF Core

The generated Books table illustrates the entity-to-table mapping. section 5.2

How .NET in Action, Second Edition covers it

How deep it goes

Explains entity mapping and primary-key conventions, then demonstrates table access through DbContext.

Examples

Uses a Book entity, a Books table, and an in-memory database.

What it assumes

Assumes a C# entity class and DbContext that includes the entity.

What you can do after

Build a code-first EF Core entity-to-table mapping and access its rows through DbContext.

How it connects

Links tables to entities, primary keys, DbSet, and DbContext.

liveBookmanning.com

Read .NET in Action, Second Edition on liveBook Get the book at manning.com

Also explained in

• 

  liveBookmanning.com
  D3.js in Action, Third EditionAn HTML table is a structured HTML element that represents data in rows and columns.
• 

  liveBookmanning.com
  Data Analysis with LLMsRelational data is data organized as collections of tables whose rows and columns represent related records and attributes.
• 

  liveBookmanning.com
  Rust Servers, Services, and AppsA database table is a structured relational-data object consisting of rows organized under defined columns and constraints.
• 

  liveBookmanning.com
  Build Python Web Apps with StreamlitA table is a relational data structure consisting of rows and columns that stores records about related entities.
• 

  liveBookmanning.com
  Building Web APIs with ASP.NET CoreA database table is a relational data structure consisting of rows and named columns that store records of a particular type.
• 

  liveBookmanning.com
  BDD in Action, Second EditionA table is a structured arrangement of related values in rows and columns that can represent complex scenario data.
• 

  liveBookmanning.com
  Graph Neural Networks in ActionInformation describing how entities are connected or related to one another.
• 

  liveBookmanning.com
  Tiny CSS ProjectsA table is a structured HTML presentation of data organized into rows and columns for tabular relationships.
• 

  liveBookmanning.com
  Effective Data AnalysisA table is a structured data collection arranged in rows representing records and columns representing attributes.
• 

  liveBookmanning.com
  Amazon Web Services in Action, Third Edition: An in-depth guide to AWSA database table is a relational data structure consisting of rows and columns that stores records of a defined schema.
• 

  liveBookmanning.com
  WordPress Power Toolkit: Harness AI to build next-level websitesAn HTML table is a structured arrangement of data in rows and columns represented with HTML elements for rows, columns, and cells.

Compare how 12 books explain database table →

Related concepts

• SQLused by · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
• primary keyhas part · A primary key is a designated column or attribute, or combination of them, that uniquely identifies each row or item in a table or data store.
• tuplehas part · A tuple is a finite, ordered collection of elements treated as a single composite value or record.
• viewincludes · A view is an alternate representation or access interface for data derived from or backed by underlying storage without necessarily creating an independent copy.
• DynamoDB itemhas part · A DynamoDB item is a record of attributes stored as a single entry in a DynamoDB table.
• structured dataincludes · Structured data is information organized according to an explicit schema or predictable fields, types, records, or relationships for consistent machine processing.

This explainer was generated by Manning's knowledge graph from the text of .NET in Action, Second Edition. The section links point to the parts of the book it draws on.