Book Image

Entity Framework Tutorial (Update) - Second Edition

By : Joydip Kanjilal
Book Image

Entity Framework Tutorial (Update) - Second Edition

By: Joydip Kanjilal

Overview of this book

The ADO.NET Entity Framework from Microsoft is a new ADO.NET development framework that provides a level of abstraction for data access strategies and solves the impedance mismatch issues that exist between different data models This book explores Microsoft’s Entity Framework and explains how it can used to build enterprise level applications. It will also teach you how you can work with RESTful Services and Google’s Protocol Buffers with Entity Framework and WCF. You will explore how to use Entity Framework with ASP.NET Web API and also how to consume the data exposed by Entity Framework from client applications of varying types, i.e., ASP.NET MVC, WPF and Silverlight. You will familiarize yourself with the new features and improvements introduced in Entity Framework including enhanced POCO support, template-based code generation, tooling consolidation and connection resiliency. By the end of the book, you will be able to successfully extend the new functionalities of Entity framework into your project.
Table of Contents (16 chapters)
Entity Framework Tutorial Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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)
    • about / What is the ADO.NET Entity Framework?
  • ADO.NET Entity Framework 6
    • enhancements / System requirements, Support for T4 code generation, Support for POCO change tracking, Support for code-first, model-first, and database-first approaches, Support for model-defined functions, Enum support, Spatial data types support, Other enhancements
  • aggregate canonical functions, E-SQL / Aggregate functions
  • Association
    • about / What is an entity?
  • associations
    • about / Association sets, associations, containment, and multiplicity
  • association sets
    • about / Association sets, associations, containment, and multiplicity
  • Atom Publishing Protocol (AtomPub)
    • about / What is the OData Protocol?
  • auto-compiled queries
    • about / Performance improvements in Entity Framework 6

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
    • about / Creating a database using model-first development, Understanding the code-first, model-first, and database-first approaches to domain design
    • using / Using the 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
    • about / Entity Framework architectural components
  • 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
    • about / Change tracking and identity resolution using ObjectContext
  • containment
    • about / Association sets, associations, containment, and multiplicity
  • 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)
    • about / A comparative analysis of Entity Framework and other ORM tools
  • database
    • creating, model-first development used / Creating a database using model-first development
  • database-first approach
    • about / Creating a database using model-first development, Understanding the code-first, model-first, and database-first approaches to domain design
    • using / Using the 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
    • creating / Extending the existing entity types to create derived entity types
  • Django REST
    • about / Django REST
    • URL / Django REST
  • domain-driven design (DDD)
    • about / Creating a database using model-first development
  • domain modeling
    • about / A comparative analysis of Entity Framework and other ORM tools
  • 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
    • options / Creating Entity Data Model using the EdmGen 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
    • about / Entities, entity types, and relationships in the EDM
  • entity classes
    • about / LINQ to SQL and .dbml files, 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
    • extending / Extending the existing entity types to create derived entity types
  • Enum support / Enum support
  • explicit loading
    • about / Reading objects from the Security database
  • 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
    • about / Is Entity Framework just another ORM?
  • Flickr REST API
    • about / The Flickr REST API
    • URL / The Flickr REST API
  • Fluent NHibernate
    • about / A comparative analysis of Entity Framework and other ORM tools
  • 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
    • DELETE / HTTP methods, request, and response codes
    • GET / HTTP methods, request, and response codes
    • HEAD / HTTP methods, request, and response codes
    • OPTIONS / HTTP methods, request, and response codes
    • POST / HTTP methods, request, and response codes
    • PUT / HTTP methods, request, and response codes
  • 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
    • simple / Identifiers, variables, parameters, and types in E-SQL
    • quoted / Identifiers, variables, parameters, and types in E-SQL
  • identity management
    • about / State management, identity management, and relationship 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
    • about / Support for lazy loading, Deferred, eager, and lazy loading
    • URL / Support for lazy loading
    • example / Deferred, eager, and 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
    • about / Understanding the LINQ architecture
  • LinqDataSource control
    • about / The LinqDataSource control
  • LINQ to DataSet
    • about / A comparative analysis of Entity Framework and other ORM tools
  • 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
    • about / A comparative analysis of Entity Framework and other ORM tools
  • LINQ to Objects / LINQ to Objects
  • LINQ to SQL / LINQ to SQL
    • about / Looking back, A comparative analysis of Entity Framework and other ORM tools, LINQ to SQL and .dbml files
    • versus LINQ to Entities / Differences between LINQ to Entities and LINQ to SQL
  • LINQ to XML
    • about / A comparative analysis of Entity Framework and other ORM tools, LINQ to XML
  • Logical Model Layer
    • about / Entity Framework architectural components

M

  • Mapping Details window, Security EDM
    • about / The Mapping Details window
  • Mapping Layer
    • about / Entity Framework architectural components
  • 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
    • about / Support for code-first, model-first, and database-first approaches
  • model-first approach
    • about / Creating a database using model-first development, Understanding the code-first, model-first, and database-first approaches to domain design
    • using / Using the 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
    • about / Association sets, associations, containment, and multiplicity

N

  • native SQL
    • retrieving, from EntityCommand / Retrieving native SQL from EntityCommand
  • new features, Entity Framework 7 / New features in Entity Framework 7
  • NHibernate
    • about / A comparative analysis of Entity Framework and other ORM tools
  • 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
    • creating / Working with OData Services using WCF and ASP.NET MVC Framework
  • 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
    • about / Support for persistence ignorance
  • Plain Old CLR Objects (POCO)
    • about / Support for persistence ignorance
  • 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
    • about / Association sets, associations, containment, and multiplicity
  • relationship management
    • about / State management, identity management, and relationship management
  • Relationship Types
    • about / What is an entity?
  • Remote Data Objects (RDO)
    • about / A comparative analysis of Entity Framework and other ORM tools
  • resource-oriented architecture (ROA)
    • about / REST-based Web Services
  • resources, REST-based architecture
    • about / Resources in REST-based architecture
  • REST
    • about / What is Representational State Transfer (REST)?, REST and REST-based service frameworks
    • need for / Why do we need REST?
    • goals / REST and REST-based service frameworks
  • 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
    • about / What is Representational State Transfer (REST)?
  • RESTful Web API
    • about / REST and REST-based service frameworks
  • Restlet
    • about / Restlet
    • benefits / Restlet
    • URL / 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
    • about / Serializing and deserializing entity instances
  • 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
    • URL / Spatial data types support
  • SQL
    • about / From T-SQL to E-SQL
  • SqlDataSource control
    • about / The SqlDataSource control
    • reference link / The SqlDataSource control
  • state management
    • about / State management, identity management, and relationship 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
    • about / Identifiers, variables, parameters, and types in E-SQL
  • Visual Studio
    • Protobuf.NET, integrating with / Integrating Protobuf.NET with Visual Studio

W

  • WCF Data Service
    • creating / Working with OData Services using WCF and ASP.NET MVC Framework
    • hosting / Working with OData Services using WCF and ASP.NET MVC Framework
  • 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