Index
A
- actual migration code
- about / Using the migrations API
- ADO.NET
- about / What is ORM?
- advanced modeling techniques
- about / Advanced modeling techniques
- complex types / Complex types
- explicit table, using / Using an explicit table and column mappings
- column mappings / Using an explicit table and column mappings
- supporting columns, adding / Adding supporting columns
- enumerations / Enumerations
- multiple tables, using for single entity / Using multiple tables for a single entity
- advanced querying techniques
- about / Advanced querying techniques
- projections / Projections
- aggregations / Aggregations and grouping
- grouping / Aggregations and grouping, Groupings and left outer joins
- example / Advanced query construction
- data, paging with windowing functions / Paging data with windowing functions
- joins, using / Using joins
- left outer joins / Groupings and left outer joins
- set operators / Set operations
- aggregations
- about / Aggregations and grouping
- Count method / Aggregations and grouping
- Sum method / Aggregations and grouping
- Min method / Aggregations and grouping
- Max method / Aggregations and grouping
- Average method / Aggregations and grouping
- American National Standards Institute (ANSI)
- about / What is ORM?
- anonymous types, class
- about / Projections
- association properties
- about / Projections
- asynchronous API
- about / The asynchronous API
- Average method
- about / Aggregations and grouping
B
- Binary Large OBjects (BLOBs)
C
- CodePlex
- column mappings
- complex types
- about / Complex types
- composite primary keys
- about / Updating data in the database
- concurrency
- about / Handling concurrency
- handling / Handling concurrency
- pessimistic concurrency / Handling concurrency
- optimistic concurrency / Handling concurrency
- configuration conventions
- about / Custom conventions
- Count method
- about / Aggregations and grouping
- CRUD
- about / What is ORM?
- custom conventions
- about / Custom conventions
D
- data
- filtering, in queries / Filtering data in queries
- sorting, in queries / Sorting data in queries
- paging, with windowing functions / Paging data with windowing functions
- database
- creating, based on .NET classes / Creating a new database based on .NET classes
- record, saving / Saving a new record to the database
- data, querying / Querying data in a database
- record, updating / Updating a record
- row, deleting / Deleting a row from the database
- schema changes / Introduction to schema changes
- data, inserting / Inserting data into the database
- data, updating / Updating data in the database
- data, deleting / Deleting data from the database
- in-memory data, working with / Working with in-memory data
- migrations, adding / Adding migrations to an existing database
- Data Definition Language (DDL)
- about / Using the migrations API
- Data Manipulation Language (DML)
- about / Using the migrations API
- dependency injection
- about / Dependency injection and logging
- reference link / Dependency injection and logging
- descending keyword
- about / Sorting data in queries
- Distinct operator
- about / Set operations
E
- eager loading
- EDMX file
- element operations
- about / Element operations
- Entity Framework
- history / A brief history of Entity Framework
- Model First approach / A brief history of Entity Framework
- Code First approach / A brief history of Entity Framework
- capabilities / The capabilities of Entity Framework
- architecture / The Entity Framework architecture
- new project, creating / Creating a new project that uses Entity Framework
- features / Additional Entity Framework features
- Entity Framework Power Tools
- Entity Framework Tools
- entity splitting
- about / Using multiple tables for a single entity
- versus table splitting / Using multiple tables for a single entity
- EntityState enumeration, states
- Added / Inserting data into the database
- Deleted / Inserting data into the database
- Detached / Inserting data into the database
- Modified / Inserting data into the database
- Unchanged / Inserting data into the database
- enumerations
- about / Enumerations
- Except operator
- about / Set operations
- explicit table
F
- features, Entity Framework
- custom conventions / Custom conventions
- geo spatial data / Geospatial data
- dependency injection / Dependency injection and logging
- logging / Dependency injection and logging
- startup performance / Startup performance
- multiple contexts per database / Multiple contexts per database
G
- geo spatial data
- about / Geospatial data
- grouping
I
- immediate execution
- about / Lazy and eager loading
- impedance mismatch
- about / What is ORM?
- in-memory data
- working with / Working with in-memory data
- Intersect operator
- about / Set operations
J
- join keyword
- about / Using joins
- joins
- using / Using joins
- junction table
- about / The Many-to-Many relationship
L
- Language INtegrated Query (LINQ)
- about / What is ORM?
- lazy loading
- left outer joins
- about / Groupings and left outer joins
- LINQ
- about / The basics of LINQ
- query syntax / The basics of LINQ
- method syntax / The basics of LINQ
- LINQ functions
- about / Exploring LINQ functions
- element operations / Element operations
- quantifiers / Quantifiers
- LINQ to SQL
- logging
- about / Dependency injection and logging
M
- Many-to-Many relationship
- about / The Many-to-Many relationship
- mappings, .NET types
- reference link / Mapping .NET types to SQL types
- Max method
- about / Aggregations and grouping
- method syntax
- about / The basics of LINQ
- migrate.exe
- migrations
- about / The capabilities of Entity Framework
- enabling / Enabling and running migrations
- running / Enabling and running migrations
- applying / Applying migrations
- applying, via script / Applying migrations via a script
- applying, via migrate.exe / Applying migrations via migrate.exe
- applying, via initializer / Applying migrations via an initializer
- adding, to existing database / Adding migrations to an existing database
- migrations API
- using / Using the migrations API
- Min method
- about / Aggregations and grouping
- multiple contexts per database
- about / Multiple contexts per database
- multiple tables
- using, for single entity / Using multiple tables for a single entity
N
- .NET types
- mapping, to SQL types / Mapping .NET types to SQL types
- nullable properties
- handling / Handling nullable properties
O
- Object-Relational Mapping (ORM)
- about / What is ORM?
- object graph
- about / Inserting data into the database
- One-to-Many relationship
- about / The One-to-Many relationship
- One-to-One relationship
- about / The One-to-One relationship
- optimistic concurrency
- about / Handling concurrency
- Oracle mappings
- reference link / Mapping .NET types to SQL types
- Overridable
- about / The One-to-Many relationship
P
- pessimistic concurrency
- about / Handling concurrency
- primitive properties
- configuring / Configuring primitive properties
- projections
- about / Projections
Q
- quantifiers
- about / Quantifiers
- Any operation / Quantifiers
- All operation / Quantifiers
- query
- about / The basics of LINQ
- query syntax
- about / The basics of LINQ
R
- related entities
- about / Working with related entities
- filtering / Filtering based on related data
- lazy loading / Lazy and eager loading
- eager loading / Lazy and eager loading
- Relational Database Management System (RDBMS)
- about / What is ORM?
- relationships
- defining / Defining relationships
- One-to-Many / Defining relationships, The One-to-Many relationship
- One-to-One / Defining relationships, The One-to-One relationship
- Many-to-Many / Defining relationships, The Many-to-Many relationship
- resource file
- about / Using the migrations API
S
- schema changes
- about / Introduction to schema changes
- set operators
- about / Set operations
- Distinct / Set operations
- Union / Set operations
- Intersect / Set operations
- Except / Set operations
- SQL injection
- about / Working with views
- SQL Server Data Tools (SSDT)
- SQL Server Management Studio (SSMS)
- SQL types
- .NET types, mapping / Mapping .NET types to SQL types
- startup performance
- about / Startup performance
- stored procedures
- about / Working with stored procedures
- entities, creating / Create, update, and delete entities with stored procedures
- entities, updating / Create, update, and delete entities with stored procedures
- entities, deleting / Create, update, and delete entities with stored procedures
- Structured Query Language (SQL)
- about / What is ORM?
- Sum method
- about / Aggregations and grouping
- supporting columns
- adding / Adding supporting columns
T
- table splitting
- versus entity splitting / Using multiple tables for a single entity
- table structures
- creating / Creating table structures
- .NET types, mapping to SQL types / Mapping .NET types to SQL types
- primitive properties, configuring / Configuring primitive properties
- nullable properties, handling / Handling nullable properties
U
- Unicode data
- about / Configuring primitive properties
- Union operator
- about / Set operations
V
- views
- about / Working with views
- working with / Working with views
- virtual keyword
- about / The One-to-Many relationship
- Visual Studio
W
- windowing functions
- used, for paging data / Paging data with windowing functions