Index
A
- ACID properties
- atomic / Atomic
- consistent / Consistent
- isolation / Isolation
- durability / Durability
- actual loggers / How it works…
- Application Programming Interface (API) / Single Responsibility Principle
- asynchronous operations
- using / Using asynchronous operations, How to do it…
- queries, performing for data retrieval / Queries
- existing data, modifying / Modifications
- atomic / Atomic
- audit data
- capturing / Capturing the audit data, How to do it…, How it works…
- Azure Table Storage / Provider Model
C
- C# POCO entities
- generating / How to do it…
- cache
- using / Using the cache, How to do it…, How it works…
- caching mechanism, in repository pattern / Repository and caching
- cascade delete
- reference / See also
- about / There's more…
- cascading entity deletes
- issue / Problem
- solving / How to solve it…
- client-side functions
- executing, in LINQ queries / Executing client-side functions in LINQ queries, Getting ready, How to do it…, How it works…
- code
- databases, creating from / Creating databases from code, Getting ready, How to do it…
- code first approach
- used, for improving Entity Framework / Improving Entity Framework by using a code-first approach, Getting ready, How to do it…
- composite primary keys
- issue / Problem
- solving / How to solve it…
- consistent / Consistent
- convention over configuration approach / Convention over configuration
- custom conventions
- creating / Creating custom conventions, How to do it…, How it works…
- custom SQL operations
- transactions, using in / Using transactions in custom SQL operations, How to do it…, How it works…
D
- DataAnnotations validations
- reference / See also
- database
- updating, from model changes / Updating the database from model changes, How to do it…
- entities, generating from / Generating entities from the database, How to do it…, How it works…
- database-agnostic way
- optimistic concurrency, implementing in / Getting ready, How to do it…, How it works…
- database initializers / There's more…
- database null semantics
- issue / Problem
- solving / How to solve it…
- database profiler
- about / Database profiler
- databases
- creating, from code / Creating databases from code, Getting ready, How to do it…
- using / Using other databases, How to do it…
- Data Transfer Objects (DTOs)
- about / Introduction
- date/time operations, not supported
- issue / Problem
- solving / How to solve it…
- DbFunctions
- reference / Problem
- Dependency Injection (DI) / How to do it.…
- Dependency Inversion Principle / Dependency Inversion Principle
- Domain-Driven Design (DDD)
- about / Introduction
- Domain Driven Design (DDD) / Generating entities from the database
- durability / Durability
- dynamic LINQ
- using / Using dynamic LINQ, How to do it…, How it works…
E
- eager loading / Eager loading, How to do it…, How it works…
- entities
- state, setting of / Setting the state of an entity, How to do it…, How it works…
- inserting, with stored procedures / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- updating, with stored procedures / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- deleting, with stored procedures / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- obtaining, from local cache / Getting entities from the local cache, Getting ready, How to do it…, How it works…
- generating, from database / Generating entities from the database, How to do it…, How it works…
- Entity Framework
- about / Introduction
- improving, code first approach used / Improving Entity Framework by using a code-first approach, Getting ready, How to do it…
- Entity Framework Core
- reference / See also
- EntityFrameworkCore.SqlServerCompact40
- reference / Using other databases
- Entity Framework Core 1.0, workflows
- code first / Generating entities from the database
- database first / Generating entities from the database
- Entity Framework Core site
- reference / Using other databases
- entity framework validation
- MVC UI, improving with / Improving MVC UI with entity framework validation, How to do it…, How it works…
- entity metadata
- retrieving / Retrieving entity metadata, How to do it…, How it works…
- Entry method, states
- EntityState.Unchanged / How it works…
- EntityState.Modified / How it works…
- EntityState.Added / How it works…
- EntityState.Deleted / How it works…
- EntityState.Detached / How it works…
- explicit transactions
- Express Profiler
- reference / Database profiler
- using / Database profiler
- extension methods / Extension methods
F
- filtered collections
- creating / Creating filtered collections, How to do it…, How it works…
- First Level Cache / There's more…, Problem
G
- Glimpse
- about / Real time monitoring
- reference / Real time monitoring
- GroupBy executes, on client side
- issue / Problem
- fixing / How to fix it…
- groups of entities
- validating / Validating groups of entities, How to do it…, How it works…
- GUID primary keys
- about / How it works…
- reference / There's more…
- GUIDs
- using, as keys / Using GUIDs as keys, How to do it…, How it works…
H
- High-Low algorithm
- about / Using sequence key generators
- reference / See also
- HTML helper / Understanding the HTML helper
I
- Identity Map / There's more…, Problem
- infrastructure services
- hooking / Hooking infrastructure services
- inheritance
- implementing / Implementing inheritance – Table per Class hierarchy, How to do it…, How it works…
- Table Per Hierarchy/Single Table Inheritance / Implementing inheritance – Table per Class hierarchy
- Table Per Type/Class Table Inheritance / Implementing inheritance – Table per Class hierarchy
- Table Per Concrete Type/Concrete Table Inheritance / Implementing inheritance – Table per Class hierarchy
- integration tests / Integration tests
- interfaces
- mapping / Mapping interfaces, How to do it…, How it works…
- Interface Segregation Principle / Interface Segregation Principle
- Inversion of Control (IoC) / How to do it.…
- isolation / Isolation
K
- keys
- GUIDs, using as / Using GUIDs as keys, How to do it…, How it works…
L
- lazy loading / Problem
- LINQ
- about / LINQ
- LINQPad / Testing
- LINQ queries
- client-side functions, executing in / Executing client-side functions in LINQ queries, Getting ready, How to do it…, How it works…
- SQL, mixing with / Mixing SQL with LINQ queries, How to do it…
- local cache
- entities, obtaining from / Getting entities from the local cache, Getting ready, How to do it…, How it works…
- logger factories / How it works…
- logger providers / How it works…
- logging
- adding / Getting ready, How it works…
- about / Logging
- logging entry
- Log Level / How it works…
- Event Id / How it works…
- State / How it works…
- Exception / How it works…
- Formatter / How it works…
- logging providers, .NET Core
- MICROSOFT.EXTENSIONS.LOGGING / There's more…
- Lolita code, GitHub
- reference / There's more…
M
- many-to-many maps
- creating / Creating many-to-many maps, How to do it…, How it works…
- many-to-one relationship / Eager loading
- mapping discriminator columns issue
- about / Problem
- solving / How to solve it…
- maximum string length issue
- about / Problem
- solving / How to solve it…
- Microsoft ASP.NET MVC / Model-View-Controller
- migrations and contexts, with parameterized constructors
- issue / Problem
- solving / How to solve it…
- migrations API / There's more…
- migrations with contexts, in different projects
- issue / Problem
- solving / How to solve it…
- mock database connections
- creating / Creating mock database connections, How to do it…, How it works…
- mocking / Mocking
- mocks / Mocking
- Model-View-Controller / Model-View-Controller
- model changes
- database, updating from / Updating the database from model changes, How to do it…
- Moq framework / How it works…
- Multiple Active Result Sets (MARS) / Queries
- multitenancy
- about / Implementing multitenancy
- achieving, techniques / Implementing multitenancy
- implementing / Getting ready, How to do it…, How it works…
- MVC applications
- improving / Improving MVC applications, How to do it.…
- MVC UI
- improving, with entity framework validation / Improving MVC UI with entity framework validation, How to do it…, How it works…
N
- naming conflict / Naming conflict
- non-public members
- mapping / Mapping non-public members, How to do it…, How it works…
- NuGet package
- reference / How it works…
O
- Object-Relational Mapper (ORM) / Getting entities from the local cache
- Object-Relational Mapper (ORM), models
- POCO model / Shadow properties
- database model / Shadow properties
- mapping model / Shadow properties
- Object-Relational Mappers (ORMs) / Problem
- one-to-many maps
- creating / Creating one-to-many maps, How to do it…, How it works…
- one-to-many relationship / Eager loading
- one-to-one maps
- creating / Creating one-to-one maps, How to do it…, How it works…
- one-to-one relationship / Eager loading
- one class under test / One class under test
- optimistic concurrency
- implementing, in SQL Server / Implementing optimistic concurrency in SQL Server, How to do it…, How it works…
- implementing, in database-agnostic way / Getting ready, How to do it…, How it works…
- optimistic concurrency checks
- about / There's more…
- optimistic concurrency control failure, solutions
- database wins / Database wins
- client wins/last one wins / Client wins/last one wins
P
- paging, in SQL Server
- issue / Problem
- solving / How to solve it…
- paging techniques
- reference / How to solve it…
- performance
- improving, of queries / Improving the performance of queries, Getting ready
- Plain Old CLR Object (POCO) / Generating entities from the database
- Plain Old CLR Objects (POCOs) / Introduction
- projects, available for code-first approach
- property changes
- intercepting / Intercepting property changes, How to do it…, How it works…
- Provider Model / Provider Model
Q
- queries
- performance, improving of / Improving the performance of queries, Getting ready
- testing / Testing and profiling queries, How to do it…
- profiling / Testing and profiling queries, How to do it…
- Query Object pattern
- implementing / Implementing the query object pattern, How to do it…, How it works…
- query performance, improving ways
- modifications / Modifications
- queries / Queries
R
- real time monitoring / Real time monitoring
- Redis / Provider Model
- refactor / Refactoring
- references not eagerly fetched are lost issue
- about / Problem
- solving / How to solve it…
- refreshing entities
- issue / Problem
- solving / How to solve it…
- relationships
- reference / See also
- repository pattern
- implementing / Implementing the repository pattern, How to do it…, How it works…
- caching mechanism / Repository and caching
- reference / See also
- reusable queries
- creating / Creating reusable queries, How to do it…, How it works…
S
- saving changes
- intercepting / Intercepting saving changes, How to do it…, How it works…
- scaffolding / Generating entities from the database
- SELECT N+1 problem / Eager loading
- sequence key generators
- server-generated GUIDs
- using / There's more…
- Server Process ID (SPID) / Database profiler
- service provider access
- issue / Problem
- solving / How to solve it…
- shadow properties
- about / Shadow properties, How to do it…
- working / How it works…
- reference / See also
- querying / Querying shadow properties, How to do it…, How it works…
- simple properties
- validating / Validating simple properties, How to do it…, How it works…
- Single Responsibility Principle (SRP) / Single Responsibility Principle
- soft deletes
- handling / Getting ready, How to do it…, How it works…
- SOLID principles / Single Responsibility Principle
- SQL
- mixing, with LINQ queries / Mixing SQL with LINQ queries, How to do it…
- about / SQL
- SQL script
- dumping, for database creation / Dumping the SQL script for the database creation, How to do it…
- SQL Server
- optimistic concurrency, implementing in / Implementing optimistic concurrency in SQL Server, How to do it…, How it works…
- state
- setting, of entities / Setting the state of an entity, How to do it…, How it works…
- stored procedures
- entities, inserting with / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- entities, updating with / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- entities, deleting with / Inserting, updating, and deleting entities with stored procedures, How to do it…, How it works…
- strongly typed bulk operations
- about / Strongly typed bulk operations, Getting ready, How to do it…
- deletes / How it works…
- updates / How it works…
- stubbing / Mocking
T
- table per class hierarchy, requiring nullable columns for derived class
- issue / Problem
- solving / How to solve it…
- Table Per Class Hierarchy/Single Table Inheritance pattern / Problem
- Table Per Concrete Type/Concrete Table Inheritance / Implementing inheritance – Table per Class hierarchy
- Table Per Hierarchy/Single Table Inheritance / Implementing inheritance – Table per Class hierarchy
- Table Per Type/Class Table Inheritance / Implementing inheritance – Table per Class hierarchy
- testing / Testing
- transactions
- using, in custom SQL operations / Using transactions in custom SQL operations, How to do it…, How it works…
- transactions, extension methods
- BeginTransaction/BeginTransactionAsync / How it works…
- UseTransaction / How it works…
- transactions, methods
- BeginTransaction/BeginTransactionAsync / How it works…
- CommitTransaction / How it works…
- RollbackTransaction / How it works…
U
- unit of work pattern
- implementing / Implementing the unit of work pattern, How to do it…
- reference / Implementing the unit of work pattern
- call per change / Call per change
- unit testing
- about / Unit testing and mocking, Getting ready, How to do it…, How it works…
- Arrange, Act, Assert / Arrange, Act, Assert
- user interface (UI) layer
V
- validation attributes, System.ComponentModel.DataAnnotations
- CompareAttribute / There's more…
- CreditCardAttribute / There's more…
- CustomValidationAttribute / There's more…
- DataTypeAttribute / There's more…
- EmailAddressAttribute / There's more…
- EnumDataTypeAttribute / There's more…
- FileExtensionsAttribute / There's more…
- MaxLengthAttribute / There's more…
- MinLengthAttribute / There's more…
- PhoneAttribute / There's more…
- RangeAttribute / There's more…
- RegularExpressionAttribute / There's more…
- RequiredAttribute / There's more…
- StringLengthAttribute / There's more…
- UrlAttribute / There's more…
W
- where generic constraint / Where generic constraint
- whole entity
- validating / Validating the whole entity, How to do it…, How it works…
- workflows, for working with Object-Relational Mapper (ORM)
- database first / Introduction
- code first / Introduction
X
- xUnit runner / How to do it…
Z
- Z.EntityFramework.Plus package / There's more…