Home Page Icon
Home Page
Table of Contents for
Fitting it in
Close
Fitting it in
by Rebecca M. Riordan
Fluent Entity Framework
Title Page
Copyright Page
Acknowledgements
Contents
Tell Us What you Think!
Getting Started
Introduction
Fluent learning because...
This book isn’t for everyone
What you’ll learn
What you’ll need
How it works
1. Why Bother?
Information architecture in the kitchen
Who are you?
Task list
The impedance mismatch
The database side
Fixing a schema
Relationships
Integrity constraints
The OOP side
OOA&D
Relational objects
The proof of the pudding...
Review
2. Hello, EF
Fitting it in
Task list
Setting up
Installing nuget
Create a project
Add the nuget package
Say hello
Add a model
Use the EDM wizard
Edit the model
Write some code
Say what?
What the wizard does
The EDMX
The code
The client
Review
The Designer
3. Using the Designer
Fitting it in
Task list
The designer & the EDMX
Updating the model
Review
Updating the model
Update model wizard
Update the model
Hey, what happened?
The mapping window
So what happened?
Before we move on...
Mapping functions
Review
The model browser
Review
4. Complex Models
Fitting it in
Task list
Complex types
Creating complex objects
Create a complex type
Reusing a complex type
Split & partitioned entities
Modelling split entities
Partitioning entities
Partition an entity
Review
TPT Inheritance
Establishing inheritance
TPH Inheritance
Modelling TPH
Review
5. The Object Model
Fitting it in
Task list
The objectcontext API
Objectcontext designer classes
Entity designer classes
A preview of coming attractions
The DBcontext API
DBContext designer classes
Entity designer classes
Extending the model
Review
6. Designer Options
Fitting it in
Task list
The model first workflow
Using model first
Using templates
A quick look at T4
Writing T4 templates
Adding a T4 template
Review
The Code
7. The Code First workflow
Fitting it in
Task list
Code first basics
Code first solutions
Building the data client
Review
Code first conventions
The rules
Controlling the database
Using connection strings
The database class
Initializers
Creating initializers
Review
8. Controlling The Schema
Fitting it in
Task list
Data annotations
Moving house
Code first relationships
One-to-one relationships
Multiple relationships
Review
The fluent API
Code first fluent api syntax
Things to note
Fluent methods
Model builder configurations
Using fluent configurations
Review
Working with Entities
9. Querying Models
Fitting it in
Task list
What is a query, exactly?
Basic LINQ
Method syntax
Query execution
Lazy loading
Including related entities
Loading related entities
Query results
LINQ Projections
Entity SQL
Entity SQL syntax
Literal values in entity SQL
Parameterized queries
Pros & cons
Review
API-Specific queries
Working locally
Finding entities
Executing SQL directly
Executing queries directly
Review
10. Working with Entities
Fitting it in
Task list
Crud operations
Adding entities
Updating & deleting entities
Review
Entity state
Retrieving state entities
Entity undo
Change detection
Creating change proxies
Review
DBcontext validation
Validation annotations
Creating custom attributes
Ivalidatable object
Review
Final Project
11. On Your Own
Fitting it in
Task list
Determine the requirements
Requirement list
Choose a platform
Choose an architecture
Choose a workflow & API
Build the model
Refining the model
Build the client
Be proud of yourself
Moving on
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
8. Controlling The Schema
Next
Next Chapter
Task list
Fitting it in
Here’s how this chapter fits in to the book as a whole...
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset