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

✍ Scribed by GoalKicker.com

• Publisher: GoalKicker.com
• Year: 2018
• Tongue: English
• Leaves: 94
• Category: Library

✦ Table of Contents

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