Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Sergey Barskiy
Code-First Development with Entity Framework
Code-First Development with Entity Framework
Table of Contents
Code-First Development with Entity Framework
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Introducing Entity Framework
What is ORM?
A brief history of Entity Framework
The capabilities of Entity Framework
The Entity Framework architecture
Self-test questions
Summary
2. Your First Entity Framework Application
Creating a new project that uses Entity Framework
Creating a new database based on .NET classes
Saving a new record to the database
Querying data in a database
Updating a record
Deleting a row from the database
Introduction to schema changes
Self-test questions
Summary
3. Defining the Database Structure
Creating table structures
Mapping .NET types to SQL types
Configuring primitive properties
Handling nullable properties
Defining relationships
The One-to-Many relationship
The Many-to-Many relationship
The One-to-One relationship
Self-test questions
Summary
4. Querying, Inserting, Updating, and Deleting Data
The basics of LINQ
Filtering data in queries
Sorting data in queries
Exploring LINQ functions
Element operations
Quantifiers
Working with related entities
Filtering based on related data
Lazy and eager loading
Inserting data into the database
Updating data in the database
Deleting data from the database
Working with in-memory data
Self-test questions
Summary
5. Advanced Modeling and Querying Techniques
Advanced modeling techniques
Complex types
Using an explicit table and column mappings
Adding supporting columns
Enumerations
Using multiple tables for a single entity
Advanced querying techniques
Projections
Aggregations and grouping
Advanced query construction
Paging data with windowing functions
Using joins
Groupings and left outer joins
Set operations
Self-test questions
Summary
6. Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
Working with views
Working with stored procedures
Create, update, and delete entities with stored procedures
The asynchronous API
Handling concurrency
Self-test questions
Summary
7. Database Migrations and Additional Features
Enabling and running migrations
Using the migrations API
Applying migrations
Applying migrations via a script
Applying migrations via migrate.exe
Applying migrations via an initializer
Adding migrations to an existing database
Additional Entity Framework features
Custom conventions
Geospatial data
Dependency injection and logging
Startup performance
Multiple contexts per database
Self-test questions
Summary
A. Answers to Self-test Questions
Chapter 1: Introducing Entity Framework
Chapter 2: Your First Entity Framework Application
Chapter 3: Defining the Database Structure
Chapter 4: Querying, Inserting, Updating, and Deleting Data
Chapter 5: Advanced Modeling and Querying Techniques
Chapter 6: Working with Views, Stored Procedures, the Asynchronous API, and Concurrency
Chapter 7: Database Migrations and Additional Features
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
Next
Next Chapter
Table of Contents
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