Data Access with Entity Framework

Onderwerpen

Architecture and Data Access Technologies

• Mismatch between OO and Relational Model
• ORM
• Inheritance solutions:
  • Table per Hierarchy
  • Table per Type
  • Table per Concrete Type
• Concurrency conflicts
• Indexes

Code First

• Fundamentals of Code First
• Workflow
• Conventions
• Data annotations
• Fluent API
• ConnectionString
• Data Seeding

Querying Entity Data

• LINQ
• IQueryable
• Logging
• Reverse Engineering and scaffolding

Loading Entities and Navigation Properties

• Loading related data:
  • Eager loading
  • Explicit loading
  • Lazy loading
• Relationships

Code first migrations

• Entity Framework Tools
• Enabling migrations
• InitialCreate
• Performing migrations
• Update the database

Creating, Updating, and Deleting Entity Data

• Add a new item
• Update an item
• Delete an item
• Use Stored Procedures
• Filter queries

Working with object services

• DBContext
• ChangeTracker
• Asynchronous querying and saving
• Inject Services

Concurrency

• Concurrency problems
• Pessimistic vs. optimistic concurrency
• Resolving conflicts
• Transactional support
• Managing transactions

Testing

• Testing concepts
• Initialize
• In memory

NoSQL

• What is NoSQL?
• BASE
• Characteristics
• CosmosDB
  • APIs
  • Schema free

Improving Performance

• Asynchronous data modifications
• Change tracking
• Restriction on client evaluation
• DBFunctions

Additional features

• Table splitting
• Database scalar function mapping
• Keyless entity type
• Temporal tables