Connecting to and reading from a database

  • Inheriting Core DbContext objects
  • Correlating entity classes and data tables
  • Executing stored procedures and table-valued functions

Object Relational Mapping

  • Employing code-first and database first mapping to generate entity classes
  • Optimizing complex mapping including many to many and database inheritance

Updating a database

  • Inserting, updating and deleting data when Core is integrated with .NET Framework
  • Error handling and exceptions
  • Committing and rolling back transactions