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

Description

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