Index
A
- ADO.NET Entity Client
- working with / Working with the ADO.NET Entity Client, Let's get into action
- connection string, building / Building the connection string
- entity connection string, building / Creating an entity connection
- connection, opening / Opening the connection, Closing the connection
- queries, executing with entity command / Executing queries using the entity command
- ADO.NET Entity Data Model Designer
- used, for creating EDM / Creating the Entity Data Model using the ADO.NET Entity Data Model Designer
- ADO.NET Entity Framework
- versus ORM tools / Is Entity Framework just another ORM?
- components / Entity Framework architectural components
- benefits / Features and benefits at a glance
- features / Features and benefits at a glance
- system requisites / System requirements
- ADO.NET Entity Framework (EF)
- ADO.NET Entity Framework 6
- aggregate canonical functions, E-SQL / Aggregate functions
- Association
- about / What is an entity?
- associations
- association sets
- Atom Publishing Protocol (AtomPub)
- about / What is the OData Protocol?
- auto-compiled queries
B
- bitwise canonical functions, E-SQL / Bitwise functions
C
- canonical functions, E-SQL
- about / Canonical functions in E-SQL
- mathematical / Canonical functions in E-SQL, Mathematical functions
- aggregate / Canonical functions in E-SQL, Aggregate functions
- string / Canonical functions in E-SQL, String functions
- bitwise / Canonical functions in E-SQL, Bitwise functions
- date and time / Canonical functions in E-SQL, Date and time functions
- code-first approach
- collection
- about / Collections
- complex joins
- avoiding, Entity SQL used / Avoiding complex joins
- complex types
- implementing, in EDM / Implementing complex types in the EDM
- components, ADO.NET Entity Framework
- Entity Data Model (EDM) / The Entity Data Model
- Object Model (O-Space) / The Object Model (O-Space)
- LINQ to Entities / LINQ to Entities
- Entity client / Entity Client
- Entity SQL / Entity SQL
- Object Services Layer / The Object Services Layer
- components, REST request
- endpoint URL / Resources in REST-based architecture
- DeveloperCaller ID / Resources in REST-based architecture
- parameters / Resources in REST-based architecture
- desired action / Resources in REST-based architecture
- Conceptual Model Layer
- Conceptual Schema Definition Language (.CSDL)
- about / How is the EDM represented?
- Conceptual Schema Definition Language (CSDL) / The CSDL schema
- concurrency, WCF Data Services
- reference link / Why use WCF Data Services?
- concurrency conflicts
- containment
- Containment
- about / What is an entity?
- create function
- mapping, to entities / Mapping the create, update, and delete functions to entities in the EDM
- CRUD operations
- performing, on objects / Performing CRUD operations on objects
- Custom Search JSON/Atom API / The Google API
D
- .dbml files
- about / LINQ to SQL and .dbml files
- data
- querying, LINQ to Entities used / Querying data using LINQ to Entities
- querying, LINQ used / Querying data using LINQ
- querying, as in-memory objects / Querying data as in-memory objects
- data-centric applications
- about / Looking back
- Data Access Objects (DAO)
- database
- creating, model-first development used / Creating a database using model-first development
- database-first approach
- data binding
- about / The DataSource controls
- data model
- about / Looking back
- data paging, E-SQL / Data paging using E-SQL
- DataSource controls
- about / The DataSource controls
- ObjectDataSource control / The ObjectDataSource control
- SqlDataSource control / The SqlDataSource control
- SiteMapDataSource control / The SiteMapDataSource control
- XMLDataSource control / The XMLDataSource control
- LinqDataSource control / The LinqDataSource control
- EntityDataSource control / The EntityDataSource control
- date and time canonical functions, E-SQL / Date and time functions
- DbContext class, SecurityDbEntity / The SecurityDbEntity's DbContext class
- DbContext Fluent Generator
- URL, for downloading / Entity classes
- deferred execution / Immediate and deferred query execution
- deferred loading / Support for lazy loading
- delete function
- mapping, to entities / Mapping the create, update, and delete functions to entities in the EDM
- derived entity types
- Django REST
- about / Django REST
- URL / Django REST
- domain-driven design (DDD)
- domain modeling
- domain modeling approaches, Entity Framework
- code-first approach / Creating a database using model-first development
- model-first approach / Creating a database using model-first development
- database-first approach / Creating a database using model-first development
- Dynamic LINQ (DLINQ) / LINQ to SQL
E
- E-SQL
- about / An overview of the E-SQL language, From T-SQL to E-SQL
- need for / Why E-SQL when I already have LINQ to Entities?
- features / Features of E-SQL
- operators / Operators in E-SQL
- expressions / Expressions in E-SQL
- identifiers / Identifiers, variables, parameters, and types in E-SQL
- variables / Identifiers, variables, parameters, and types in E-SQL
- types / Identifiers, variables, parameters, and types in E-SQL
- canonical functions / Canonical functions in E-SQL
- data paging / Data paging using E-SQL
- additional operations / Other operations with E-SQL
- used, for inserting record / Inserting a record using E-SQL
- transaction management / Transaction management in E-SQL
- eager loading
- about / Deferred, eager, and lazy loading
- example / Deferred, eager, and lazy loading
- EDM
- creating / Creating the EDM
- creating, ADO.NET Entity Data Model Designer used / Creating the Entity Data Model using the ADO.NET Entity Data Model Designer
- creating, EdmGen used / Creating Entity Data Model using the EdmGen tool
- about / Entities, entity types, and relationships in the EDM
- entity sets, deleting in / Defining entity sets in the EDM
- stored procedures, mapping to functions / Mapping stored procedures to functions in the EDM
- create function, mapping to entities / Mapping the create, update, and delete functions to entities in the EDM
- update function, mapping to entities / Mapping the create, update, and delete functions to entities in the EDM
- delete function, mapping to entities / Mapping the create, update, and delete functions to entities in the EDM
- used, for executing stored procedures / Executing stored procedures using the EDM
- complex types, implementing in / Implementing complex types in the EDM
- EdmGen
- used, for creating EDM / Creating Entity Data Model using the EdmGen tool
- EdmGen.exe command-line tool
- enhancements, ADO.NET Entity Framework 6
- about / System requirements
- support, for persistence ignorance / Support for persistence ignorance
- support, for T4 code generation / Support for T4 code generation
- support, for lazy loading / Support for lazy loading
- support, for POCO change tracking / Support for POCO change tracking
- support, for better n-tier support / Better n-tier support with self-tracking entities
- support, for code-first, model-first, and database-first approaches / Support for code-first, model-first, and database-first approaches
- support, for built-in functions / Support for built-in functions and UDF support
- support, for UDF support / Support for built-in functions and UDF support
- support, for model-defined functions / Support for model-defined functions
- spatial data types support / Spatial data types support
- other enhancements / Other enhancements
- task-based asynchronous operation / Other enhancements
- support, for stored procedures and functions in code first / Other enhancements
- support, for custom code first conventions / Other enhancements
- entities
- create function, mapping to / Mapping the create, update, and delete functions to entities in the EDM
- update function, mapping to / Mapping the create, update, and delete functions to entities in the EDM
- delete function, mapping to / Mapping the create, update, and delete functions to entities in the EDM
- entity
- about / What is an entity?
- properties / What is an entity?
- Entity-Relationship model
- entity classes
- Entity client
- about / Entity Client
- EntityCommand
- native SQL, retrieving from / Retrieving native SQL from EntityCommand
- entity containers
- about / What are entity containers?
- entity data
- retrieving, from Security database / Retrieving entity data from the Security database
- Entity Data Model
- creating, EdmGen used / Creating Entity Data Model using the EdmGen tool
- Entity Data Model (EDM)
- about / What is the ADO.NET Entity Framework?, The Entity Data Model
- layers / The Entity Data Model
- representation / How is the EDM represented?
- EntityDataSource control
- about / The EntityDataSource control
- reference link / The EntityDataSource control
- Entity Framework
- used, for implementing application / Implementing our first application using the Entity Framework
- and LINQ to Entities / LINQ to Entities and Entity Framework
- working with / Working with WCF Data Services and Entity Framework
- online resources / Suggested reading
- Entity Framework, and other ORM tools
- comparative analysis / A comparative analysis of Entity Framework and other ORM tools
- Entity Framework 6
- performance improvements / Performance improvements in Entity Framework 6
- Entity Framework 6.0
- URL, for downloading / System requirements
- Entity Framework 6.x
- about / What you should know
- Entity Framework 7
- new features / New features in Entity Framework 7, New features in Entity Framework 7
- using / Using Entity Framework 7
- providers / Using Entity Framework 7
- entity instances
- serializing / Serializing and deserializing entity instances
- deserializing / Serializing and deserializing entity instances
- EntityKey
- about / What is an entity?
- Entity Model browser, Security EDM
- about / The Entity Model browser
- entity sets
- deleting, in EDM / Defining entity sets in the EDM
- Entity SQL
- about / Entity SQL
- used, for avoiding complex joins / Avoiding complex joins
- EntityType
- about / What is an entity?
- entity types
- Enum support / Enum support
- explicit loading
- expressions, E-SQL
- about / Expressions in E-SQL
- query / Query expressions in E-SQL
- expressions, LINQ to Entities
- about / Expressions in LINQ to Entities
- constant expressions / Constant expressions
- comparison expressions / Comparison expressions
- initialization expressions / Initialization expressions
- null comparisons / Null comparisons
- navigation properties / Navigation properties
- deferred query execution / Immediate and deferred query execution
- immediate query execution / Immediate and deferred query execution
F
- factory classes
- Flickr REST API
- about / The Flickr REST API
- URL / The Flickr REST API
- Fluent NHibernate
- foreign key constraint
- record, inserting with / Inserting a record with a foreign key constraint
- functions
- stored procedures, mapping to / Mapping stored procedures to functions in the EDM
G
- geography data type
- about / Spatial data types support
- geometry data type
- about / Spatial data types support
- Google API
- about / The Google API
- URL / The Google API
H
- HTTP error status codes / HTTP methods, request, and response codes
- HTTP methods
- HTTP methods for CRUD operations, REST architecture
- GET / Why do we need REST?
- HEAD / Why do we need REST?
- PUT / Why do we need REST?
- DELETE / Why do we need REST?
- POST / Why do we need REST?
- HTTP protocol
- resource methods / HTTP methods, request, and response codes
- HTTP redirection status codes / HTTP methods, request, and response codes
- HTTP server error status codes / HTTP methods, request, and response codes
- HTTP status codes
- purposes / HTTP methods, request, and response codes
I
- identifiers, E-SQL
- identity management
- in-memory objects
- about / What are Object Services?
- data, querying as / Querying data as in-memory objects
- inheritance, EDM
- Table-per-Hierarchy Model (TPH) / Extending the existing entity types to create derived entity types
- Table-per-Type Model (TPT) / Extending the existing entity types to create derived entity types
- Table-per-Concrete Class (TPC) / Extending the existing entity types to create derived entity types
- inheritance, Entity Framework
- about / Inheritance in Entity Framework
- Table per Hierarchy (TPH) / Inheritance in Entity Framework, Table-per-Hierarchy
- Table per Type (TPT) / Inheritance in Entity Framework, Table-per-Type
- Table per Concrete Type (TPC) / Inheritance in Entity Framework, Table-per-Concrete Type
- inheritance, Entity Framework 6
- reference link / Extending the existing entity types to create derived entity types
J
- join table
- about / Exploring the Security EDM
K
- Kilo Lines of Code (KLOC) / Features and benefits at a glance
L
- layers, Entity Data Model (EDM)
- Conceptual layer / The Entity Data Model
- C-S Mapping Layer / The Entity Data Model
- Logical layer / The Entity Data Model
- layers, Security EDM
- CSDL schema / The CSDL schema
- SSDL schema / The SSDL schema
- MSL schema / The MSL schema
- lazy loading
- LINQ
- about / A comparative analysis of Entity Framework and other ORM tools, Introducing LINQ
- forms / A comparative analysis of Entity Framework and other ORM tools
- need for / Why LINQ?
- operators / Operators in LINQ
- used, for querying data / Querying data using LINQ
- LINQ architecture
- LinqDataSource control
- about / The LinqDataSource control
- LINQ to DataSet
- LINQ to Entities
- about / A comparative analysis of Entity Framework and other ORM tools, LINQ to Entities, Why E-SQL when I already have LINQ to Entities?, LINQ to Entities
- used, for querying data / Querying data using LINQ to Entities
- and Entity Framework / LINQ to Entities and Entity Framework
- versus LINQ to SQL / Differences between LINQ to Entities and LINQ to SQL
- expressions / Expressions in LINQ to Entities
- LINQ to objects
- LINQ to Objects / LINQ to Objects
- LINQ to SQL / LINQ to SQL
- LINQ to XML
- Logical Model Layer
M
- Mapping Details window, Security EDM
- about / The Mapping Details window
- Mapping Layer
- Mapping Schema Language (.MSL)
- about / How is the EDM represented?
- mathematical canonical functions, E-SQL / Mathematical functions
- Microsoft Open Specification Promise (OSP)
- about / What is the OData Protocol?
- model-driven approach
- model-first approach
- model-first development
- used, for creating database / Creating a database using model-first development
- Model-View-Controller (MVC) / Ruby on Rails
- multiplicity
N
- native SQL
- retrieving, from EntityCommand / Retrieving native SQL from EntityCommand
- new features, Entity Framework 7 / New features in Entity Framework 7
- NHibernate
- no entity set
- stored procedures, mapping with / Mapping stored procedures with no entity set
O
- ObjectContext class
- EntityConnection instance, encapsulating / What are Object Services?
- MetadataWorkspace instance, encapsulating / What are Object Services?
- ObjectStateManager instance, encapsulating / What are Object Services?
- objects, detaching from / Attaching and detaching objects to and from ObjectContext
- objects, attaching to / Attaching and detaching objects to and from ObjectContext
- used, for modifying tracking / Change tracking and identity resolution using ObjectContext
- used, for modifying identity resolution / Change tracking and identity resolution using ObjectContext
- ObjectDataSource control
- about / The ObjectDataSource control
- object model
- about / Looking back
- Object Model (O-Space) / The Object Model (O-Space)
- Object Query object
- about / The Object Services Layer
- Object Relational Mapping (ORM)
- about / Looking back
- objects
- CRUD operations, performing on / Performing CRUD operations on objects
- attaching, to ObjectContext class / Attaching and detaching objects to and from ObjectContext
- detaching, from ObjectContext class / Attaching and detaching objects to and from ObjectContext
- reading, from Security database / Reading objects from the Security database
- inserting, from Security database / Inserting objects from the Security database
- editing, from Security database / Editing objects from the Security database
- deleting, from Security database / Deleting objects from the Security database
- Object Services
- about / What are Object Services?
- features / Features at a glance
- Object Services Layer
- about / The Object Services Layer
- OData
- exploring / Exploring OData
- URL / Exploring OData
- OData Service
- Open Data Protocol (OData)
- about / What is the OData Protocol?
- URL / What is the OData Protocol?
- HTTP verbs / What is the OData Protocol?
- operations, REST-style architecture
- HTTP method / What is Representational State Transfer (REST)?
- GET method / What is Representational State Transfer (REST)?
- POST method / What is Representational State Transfer (REST)?
- PUT method / What is Representational State Transfer (REST)?
- DELETE method / What is Representational State Transfer (REST)?
- HEAD method / What is Representational State Transfer (REST)?
- operators, E-SQL
- about / Operators in E-SQL
- arithmetic / Operators in E-SQL, Arithmetic operators
- comparison / Operators in E-SQL, Comparison operators
- logical / Operators in E-SQL, Logical operators
- reference / Operators in E-SQL, Reference operators
- type / Operators in E-SQL, Type operators
- case / Operators in E-SQL
- set / Operators in E-SQL, Set operators
- operator precedence / Operator precedence
- operators, LINQ
- about / Operators in LINQ
- aggregation / Aggregation
- projections / Projections
- ordering / Ordering
- quantifiers / Quantifiers
- restriction / Restriction
- conversion / Conversion
- element / Element
- set / Set
- Organization for the Advancement of Structured Information Standards (OASIS)
- about / What is the OData Protocol?
- ORM tools
- versus ADO.NET Entity Framework / Is Entity Framework just another ORM?
P
- Parallel Extensions Library
- about / Parallel LINQ
- Task Parallel Library (TPL) / Parallel LINQ
- Parallel LINQ (PLINQ) / Parallel LINQ
- URL / Parallel LINQ
- Parallel LINQ
- about / Parallel LINQ
- performance improvements, Entity Framework 6 / Performance improvements in Entity Framework 6
- persistence ignorance
- Plain Old CLR Objects (POCO)
- Protobuf-net objects
- creating / Creating Protobuf-net objects
- Protobuf.NET
- integrating, with Visual Studio / Integrating Protobuf.NET with Visual Studio
- Protobuf WCF Services
- working with / Working with Protobuf WCF Services
- Protobuf WCF services
- implementing / Implementing the WCF Service
- Protocol Buffers (Protobuf)
- about / Working with Protobuf WCF Services
- URL / Working with Protobuf WCF Services
- advantages / Protocol Buffers
Q
- query expressions, E-SQL
- SELECT / Query expressions in E-SQL
- FROM / Query expressions in E-SQL
- WHERE / Query expressions in E-SQL
- HAVING / Query expressions in E-SQL
- GROUP BY / Query expressions in E-SQL
- ORDER BY / Query expressions in E-SQL
- quoted identifiers / Identifiers, variables, parameters, and types in E-SQL
R
- record
- inserting, E-SQL used / Inserting a record using E-SQL
- inserting, with foreign key constraint / Inserting a record with a foreign key constraint
- reference
- about / Reference
- relational store
- about / Looking back
- relationship
- relationship management
- Relationship Types
- about / What is an entity?
- Remote Data Objects (RDO)
- resource-oriented architecture (ROA)
- about / REST-based Web Services
- resources, REST-based architecture
- REST
- REST-based architecture
- features / What is Representational State Transfer (REST)?
- benefits / What is Representational State Transfer (REST)?
- resources / Resources in REST-based architecture
- REST-based service frameworks
- Ruby on Rails / Ruby on Rails
- Restlet / Restlet
- Django REST / Django REST
- Flickr REST API / The Flickr REST API
- Google API / The Google API
- Yahoo Social REST APIs / Yahoo Social REST APIs
- REST-based Web Services
- about / REST-based Web Services
- REST-style architecture
- operations / What is Representational State Transfer (REST)?
- REST architectural constraints
- about / The REST architectural constraints
- client-server model / The client-server model
- stateless / Stateless
- cacheable / Cacheable
- code on demand / Code on demand
- uniform interface / The uniform interface
- resource management / Resource management
- REST architectural style
- design goals / Why do we need REST?
- REST attributes
- about / REST attributes
- WebServiceHost / WebServiceHost
- WebHttpBinding / WebHttpBinding
- WebHttpBehavior / WebHttpBehavior
- WebOperationContext / WebOperationContext
- WebMessageFormat / WebMessageFormat
- WebGet / The WebGet attribute
- WebInvoke / The WebInvoke attribute
- UriTemplate / UriTemplate
- RESTful services
- RESTful Web API
- Restlet
- REST request
- components / Resources in REST-based architecture
- row
- about / Row
- Ruby on Rails
- about / Ruby on Rails
- URL / Ruby on Rails
S
- Security database
- entity data, retrieving from / Retrieving entity data from the Security database
- objects, reading from / Reading objects from the Security database
- objects, inserting from / Inserting objects from the Security database
- objects, editing from / Editing objects from the Security database
- objects, deleting from / Deleting objects from the Security database
- Security database, tables
- Users / Designing the UserAuthentication database
- UsersAuthentication / Designing the UserAuthentication database
- UserAuthenticationTypes / Designing the UserAuthentication database
- UsersLoginHistory / Designing the UserAuthentication database
- UserRoles / Designing the UserAuthentication database
- Roles / Designing the UserAuthentication database
- Controls / Designing the UserAuthentication database
- ControlTypes / Designing the UserAuthentication database
- SecurityDbEntity
- DbContext class / The SecurityDbEntity's DbContext class
- Security EDM
- exploring / Exploring the Security EDM
- Mapping Details window / The Mapping Details window
- Entity Model browser / The Entity Model browser
- EDM layers / The EDM layers
- entity classes / Entity classes
- serialization
- service-oriented architecture (SOA)
- about / REST-based Web Services
- simple identifiers / Identifiers, variables, parameters, and types in E-SQL
- SiteMapDataSource control
- about / The SiteMapDataSource control
- spatial data types
- SQL
- about / From T-SQL to E-SQL
- SqlDataSource control
- about / The SqlDataSource control
- reference link / The SqlDataSource control
- state management
- stored procedures
- creating / Creating stored procedures
- mapping, to functions / Mapping stored procedures to functions in the EDM
- mapping, with no entity set / Mapping stored procedures with no entity set
- executing, EDM used / Executing stored procedures using the EDM
- mapping, that return custom entity types / Mapping stored procedures that return custom entity types
- Store Schema Definition Language (.SSDL)
- about / How is the EDM represented?
- string canonical functions, E-SQL / String functions
T
- T-SQL
- about / From T-SQL to E-SQL
- T4 code generation
- about / Support for T4 code generation
- Table per Concrete Type (TPC) / Inheritance in Entity Framework, Table-per-Concrete Type
- Table per Hierarchy (TPH) / Inheritance in Entity Framework, Table-per-Hierarchy
- Table per Type (TPT) / Inheritance in Entity Framework, Table-per-Type
- transaction
- about / Transaction management in E-SQL
- transaction management, E-SQL / Transaction management in E-SQL
- types, E-SQL
- about / Identifiers, variables, parameters, and types in E-SQL
- row / Row
- collection / Collections
- reference / Reference
U
- update function
- mapping, to entities / Mapping the create, update, and delete functions to entities in the EDM
- UriTemplate class
- about / UriTemplate
- user authentication database
- designing / Designing the UserAuthentication database
V
- variables, E-SQL
- Visual Studio
- Protobuf.NET, integrating with / Integrating Protobuf.NET with Visual Studio
W
- WCF Data Service
- WCF Data Services
- about / Introducing WCF Data Services
- versus Web Services / How do WCF Data Services and Web Services differ?
- need for / Why use WCF Data Services?
- features / The features at a glance
- data, exposing as service / Exposing data as a service using WCF Data Services
- working with / Working with WCF Data Services and Entity Framework
- WCF Protobuf-net service
- consuming / Specifying binding information
- WebGet attribute
- about / The WebGet attribute
- WebHttpBehavior attribute
- about / WebHttpBehavior
- WebHttpBinding attribute
- about / WebHttpBinding
- WebInvoke attribute
- about / The WebInvoke attribute
- WebMessageFormat attribute
- about / WebMessageFormat
- WebOperationContext attribute
- about / WebOperationContext
- WebServiceHost attribute
- about / WebServiceHost
- Web Services
- versus WCF Data Services / How do WCF Data Services and Web Services differ?
- Windows Communication Foundation (WCF) / Working with Protobuf WCF Services
X
- XLINQ / LINQ to XML
- XMLDataSource control
- about / The XMLDataSource control
Y
- Yahoo Social REST APIs
- about / Yahoo Social REST APIs
- URL / Yahoo Social REST APIs