Entity Framework Notes For Professionals. 80+ pages of professional hints and tricks

Content list
About
Chapter 1: Getting started with Entity Framework
	Section 1.1: Installing the Entity Framework NuGet Package
	Section 1.2: Using Entity Framework from C# (Code First)
	Section 1.3: What is Entity Framework?
Chapter 2: Code First Conventions
	Section 2.1: Removing Conventions
	Section 2.2: Primary Key Convention
	Section 2.3: Type Discovery
	Section 2.4: DecimalPropertyConvention
	Section 2.5: Relationship Convention
	Section 2.6: Foreign Key Convention
Chapter 3: Code First DataAnnotations
	Section 3.1: [Column] attribute
	Section 3.2: [DatabaseGenerated] attribute
	Section 3.3: [Required] attribute
	Section 3.4: [MaxLength] and [MinLength] attributes
	Section 3.5: [InverseProperty(string)] attribute
	Section 3.6: [ComplexType] attribute
	Section 3.7: [ForeignKey(string)] attribute
	Section 3.8: [Range(min,max)] attribute
	Section 3.9: [NotMapped] attribute
	Section 3.10: [Table] attribute
	Section 3.11: [Index] attribute
	Section 3.12: [Key] attribute
	Section 3.13: [StringLength(int)] attribute
	Section 3.14: [Timestamp] attribute
	Section 3.15: [ConcurrencyCheck] Attribute
Chapter 4: Entity Framework Code First
	Section 4.1: Connect to an existing database
Chapter 5: Entity framework Code First Migrations
	Section 5.1: Enable Migrations
	Section 5.2: Add your first migration
	Section 5.3: Doing "Update-Database" within your code
	Section 5.4: Seeding Data during migrations
	Section 5.5: Initial Entity Framework Code First Migration Step by Step
	Section 5.6: Using Sql() during migrations
Chapter 6: Inheritance with EntityFramework (Code First)
	Section 6.1: Table per hierarchy
	Section 6.2: Table per type
Chapter 7: Code First - Fluent API
	Section 7.1: Mapping models
	Section 7.2: Composite Primary Key
	Section 7.3: Maximum Length
	Section 7.4: Primary Key
	Section 7.5: Required properties (NOT NULL)
	Section 7.6: Explict Foreign Key naming
Chapter 8: Mapping relationship with Entity Framework Code First: One-to-one and variations
	Section 8.1: Mapping one-to-zero or one
	Section 8.2: Mapping one-to-one
	Section 8.3: Mapping one or zero-to-one or zero
Chapter 9: Mapping relationship with Entity Framework Code First: One-to-many and Many-to-many
	Section 9.1: Mapping one-to-many
	Section 9.2: Mapping one-to-many: against the convention
	Section 9.3: Mapping zero or one-to-many
	Section 9.4: Many-to-many
	Section 9.5: Many-to-many: customizing the join table
	Section 9.6: Many-to-many: custom join entity
Chapter 10: Database first model generation
	Section 10.1: Generating model from database
	Section 10.2: Adding data annotations to the generated model
Chapter 11: Complex Types
	Section 11.1: Code First Complex Types
Chapter 12: Database Initialisers
	Section 12.1: CreateDatabaseIfNotExists
	Section 12.2: DropCreateDatabaseIfModelChanges
	Section 12.3: DropCreateDatabaseAlways
	Section 12.4: Custom database initializer
	Section 12.5: MigrateDatabaseToLatestVersion
Chapter 13: Tracking vs. No-Tracking
	Section 13.1: No-tracking queries
	Section 13.2: Tracking queries
	Section 13.3: Tracking and projections
Chapter 14: Transactions
	Section 14.1: Database.BeginTransaction()
Chapter 15: Managing entity state
	Section 15.1: Setting state Added of a single entity
	Section 15.2: Setting state Added of an object graph
Chapter 16: Loading related entities
	Section 16.1: Eager loading
	Section 16.2: Explicit loading
	Section 16.3: Lazy loading
	Section 16.4: Projection Queries
Chapter 17: Model Restraints
	Section 17.1: One-to-many relationships
Chapter 18: Entity Framework with PostgreSQL
	Section 18.1: Pre-Steps needed in order to use Entity Framework 6.1.3 with PostgresSql using Npgsqlddexprovider
Chapter 19: Entity Framework with SQLite
	Section 19.1: Setting up a project to use Entity Framework with an SQLite provider
Chapter 20: .t4 templates in entity framework
	Section 20.1: Dynamically adding Interfaces to model
	Section 20.2: Adding XML Documentation to Entity Classes
Chapter 21: Advanced mapping scenarios: entity splitting, table splitting
	Section 21.1: Entity splitting
	Section 21.2: Table splitting
Chapter 22: Best Practices For Entity Framework (Simple & Professional)
	Section 22.1: 1- Entity Framework @ Data layer (Basics)
	Section 22.2: 2- Entity Framework @ Business layer
	Section 22.3: 3- Using Business layer @ Presentation layer (MVC)
	Section 22.4: 4- Entity Framework @ Unit Test Layer
Chapter 23: Optimization Techniques in EF
	Section 23.1: Using AsNoTracking
	Section 23.2: Execute queries in the database when possible, not in memory
	Section 23.3: Loading Only Required Data
	Section 23.4: Execute multiple queries async and in parallel
	Section 23.5: Working with stub entities
	Section 23.6: Disable change tracking and proxy generation
Credits
You may also like