Add()method

ADO.NET Entity Data Model

Age() function

@Amount parameter

AnyElement operator

App.Config class

Application_Start() event handler

Application_Start method

AsNoTracking method

ASP.NET MVC

    building CRUD operations

        adding view

        ADO.NET Entity Data Model

        App_Data folder

        application’s category name and description

        CategoryController

        Category entity

        Category model

        create view code

        DbContext class

        index view code

        MDF file-based database

        MyStore.mdf file

        SQL Server Database file selection

        Visual Studio 2012

        Visual Studio IDE

        Web application

    building search query

        Customer entity

        Customer entity data model

        formatting query field

        Linq-to-entities

        Razor view

        rendered view

        testing controller code

        WebGrid control

    filtering with URL

        category name

        Cooking Equipment category

        Global.asax

        index view code

        products and categories model

        Search engine optimization

        Tents category

<AssociationSetMapping>

Athlete entity

AthleteId property

Buil-in functions

    IsNull function

    storage layer

    WebProduct entity

Canonical functions

    eSQL

        customers and order

        definition of

        Sum(), Count(), and Avg() Functions

    LINQ

        MovieRental entity

        movies retrieval

Change-tracking proxies

Cleanup() method

Clear() method

Client.DeleteAsync method

CollectionChangedEventArgs

Collection() method

CollisionAvoidance property

CommentText property

Conceptual Schema Definition Language (CSDL)

Concurrency

    DbEntityEntry

    DbEntityEntry class

    DbUpdateConcurrencyException

    DbUpdateConcurrencyException object

    DDL

    EnrollmentDate property

    Entity Framework Updates

    ExecuteSqlCommand() method

    ForumPost entity

    ForumPost object

    “Last Record Wins” strategy

    optimistic concurrency

        product entity

        Table per Type inheritance

    OptimisticConcurrencyException

    OriginalValues property

    reading uncommitted data

        Employee entity

        IsolationLevel

        NOLOCK query hint

        System.Transactions

        TransactionScope class

    RowVersion

    SaveChanges()

    stored procedures

        account entity

        affected rows

        Agent Model

        DbContext.OnModelCreating()

        DbUpdateConcurrencyException

        DeleteAgent() procedure

        Entity Framework

        ExecuteNonQuery()

        ExecuteSqlCommand() method

        InsertAgent() procedure

        insert, update, and delete actions

        MapToStoredProcedures()

        OnModelCreating method

        Original Value check box

        Parameter check boxes

        SaveChanges() method

        UpdateAccount() procedure

        UpdateAgent() procedure

    StoreGeneratedPattern property

    T4 Template

    Timestamp Column, Model First

    TimeStamp property

    TimeStamp value

Contains clause

Context.Configuration

Count() method

CreateContext() method

CreateDatabase()

CreateProxyTypes() method

CreateQuery() method

Create, read, update, and delete (CRUD) operations

    adding view

    ADO.NET Entity Data Model

    App_Data folder

    application’s category name and description

    CategoryController

    Category entity

    Category model

    create view code

    DbContext class

    index view code

    MDF file-based database

    MyStore.mdf file

    SQL Server Database file selection

    Visual Studio 2012

    Visual Studio IDE

    Web application

CustomerEmail

Customer POCO Model

CustomerType

Database functions

    LINQ

        Appointment entity

        StartsAt property

    WebCustomer and Zip entity

DbChangeTracker

DbContext class

DbContext.Database.SqlQuery<T>()

DbContext object

DefaultIfEmpty() method

DeleteAuthorBook stored procedure

DeletePayment() method

DiffDays() function

Dispose() method

DropDatabase()

Eager loading

    Customeremail

    CustomerEmail

    Customertype

    CustomerType

    definition

    model

EmployeeAddress complex type

Entities

    deferred loading of related entities

        Connection String

        Context Class

        Entity Classes

        model

    entity collection

    entity reference

    executing aggregate operations on related entities

    filtering and ordering related entities

    filtering an eagerly loaded entity collection

    independent associations

    loading of related entities

        complete object graph

        eager loading

        Include() method

        Include() method, LINQ query operators

        JobSite entity

        JobSite type

        lazy loading

        Navigation Properties, derived types

        Plumber entity

        querying in-memory entities (see Querying in-memory entities)

    loading related entities explicitly

    modifying foreign key associations

    single entities

        Club entity class

        Club entity objects

        Connection String

        context class

        Find() method

        SQL query

Entity data model

    complex type

    conceptual model

        ADO.NET Entity Data Model

        bidirectional model development

        database connection

        Database Schema Name

        database script

        Dispose() method

        entity type

        Person entity type

        scalar property

        using() statement

    eSQL (see Entity SQL (eSQL))

    existing database

        Add() method

        Foreign Key Columns

        navigation property

        object graph building

        poet, poem, and meter entity types

        relationships

        scalar property

        vwLibrary view

    Is-a and Has-a relationships

    LINQ

        Associate and AssociateSalary Entity Types

        bitwise operators

        Cleanup() method

        DbContext Object

        flattening query results

        LoadData() method

        multiple properties

        output

        remove, load, and fetch data

        SaveChangesAsync() method

        ToList() and SingleOrDefault() method

    many-to-many relationship (see Many-to-many relationship)

    native SQL statements

        @Amount parameter

        ASP.NET TextBox control

        DbContext object

        ExecuteSqlCommand() method

        ExecuteStoreQuery() method

        payment entity

        payment table

        reuse method

        SaveChanges() method

        SQL injection attacks

        SqlQuery() method

        student entity class

        student entity type

        @Vendor parameter

    ObjectSet

    self-referencing relationship

        association type

        creation

        DbContext Subclass

        degree

        multiplicity

        PictureCategory

        Print() method

        root node

    table per hierarchy inheritance

        Abstract Employee

        EmployeeType property

        FullTimeEmployee

        HourlyEmployee

        is not null condition

        mapping conditions

        OfType<>() method

        OnModelCreating method

        UnclassifiedEmployee

    table per type inheritance

        Add() method

        business table

        concrete type

        eCommerce table

        insert and retrieve entities

        table per hierarchy

    tables

        binary large object

        DbContext Subclass

        HighResolutionBits column

        lazy loading

        OnModelCreating method

        photograph

        PhotographFullImage

        Product and ProductWebInfo

        Product Entity Type

        product POCO entity

        vertical splitting

Entity Framework

    ADO.NET Entity Data Model

    code

    conceptual layer

    definition

    designer

    EDM

    .edmx file

    existing database

    history of

    LINQ

    mapping layer

    SaveChanges()

    store layer

    terminology

    Visual Studio

EntityFunction class

EntityKey

Entity SQL (eSQL)

    bitwiseoperators

    CreateQuery() method

    customer entity

    DateTime property

    DbDataRecord object

    default values

    derived types

        discriminator property

        mediatype variable

        OnModelCreating method

        parent and child entity types

        TPH

    flattening query results

    left-outer join

        DefaultIfEmpty() method

        definition

        product entity type

        TopSeller navigation property

        TopSelling entity

    master-detail relationship

    multiple columns

    multiple properties

    multiple result sets

    object services and EntityClient

    paging and filtering

    Read() method

    related entity

        CreateSourceQuery() method

        DbContext object

        Include() method

        ToList() method

        worker entity class

    SaveChanges() method

    vs. LINQ

EntityState value

EntityType

Entry() method

ExecuteNonQuery() method

ExecuteSqlCommandAsync() method

ExecuteSqlCommand() method

Find() method

First() method

FirstOrDefault() method

ForEachAsync() extension method

From clause

FullName() function

<FunctionImportMapping>

Functions

    Age()

    Avg()

    built-in (see Built-in functions)

    canonical function (see Canonical functions)

    Count()

    database (see Database functions)

    DiffDays()

    EdmFunction()

    EntityFunction class

    FullName()

    GetProjectManager()

    GetSupervisor()

    model (see Model-defined function)

    overview of

    SqlFunctions class

    SqlServer namespace

    Sum()

    treat()

GetAllMedia() method

GetAllMedia Stored Procedure

GetAllPeople() method

GetAllPeople Stored Procedure

GetCustomers() method

GetCustomers stored procedure

GetDatabaseValues method

GetEmployeeAddresses() method

GetPostByTitle() method

GetProjectManager() function

GetSupervisor() function

GetVehiclesWithRentals() method

GetWithdrawals() method

Global.asax

HttpClient object

Include() method

    ConnectionStrings

    customer, creditcard, and transaction entity classes

    DbContext Object

    LINQ query operators

        Club Entity class

        Connection String

        context class

        filtering and grouping expressions

        model

    query path

Include() Method

Inheritance modeling

    base entity

    complex conditions

        member table

        SavingChanges Event

        stored procedures

        teen entity

    concrete table

        BMW and toyota entities

        car entity

        CarId column

    independent and foreign key association

        LicenseNumber column

        Model First

        referential constraint

        user and password history

        vehicles and tickets

    link table

    many-to-many association

    many-to-many relationship

        DbContext subclass

        POCO entity class

        related products collection

    multiple criteria

        conceptual model

        entity set mapping

        QueryView

        stored procedure/action mapping

        WebOrdersin

        WebOrder table

    null conditions

        AcceptedDate property

        drug table

        TPH Mapping

    self-referencing relationship

        abstract person POCO entity class

        DbContext subclass

        firefighter, teacher, and retired

        GetSubCategories()

        person table

        POCO entity class

        retrieving person entities

        self-referencing category table

    table per type inheritance

        employee table

        insert, update, and delete actions

        QueryView

        staff, principal, and instructor tables

        toy and RefurbishedToy tables

InsertAuthorBook stored procedure

InsertOrder() method

InsertPayment() method

InsertPost() method

IsActive property

IsLoaded property

IsRelationship property

Language-Integrated Query (LINQ)

Lazy loading

    CustomerEmail

    Customer entity

    CustomerType

    definition of

LazyLoadingEnabled property

LoadData() method

Load() method

Many-to-many relationship

    without payload

        artists and albums model

        EntityCollection type

        LinkTable

        SaveChanges()

    with payload

        count property

        link table

        OrderItem entity

        refactoring model

        SaveChanges() method

Mapping Specification Language (MSL)

MembersWithTheMostMessages custom function

MergeOption

Model-defined function

    anonymous type

        hotel reservations

        VisitorSummary()

    associate types

    complex type

        constructor

        GetVisitSummary()

        patient visit

    computed column

        eSQL and LINQ

        <Schema> tag

        typical properties

    entity collection filtering

        bootstrapping

        creation

        from clause

        customer and invoice

        GetInvoices() function

        Include() method

        where clause

    entity references

        events and sponsors

        <ReferenceType> element

        PlatinumSponsors() Function

    navigation properties

    query the model

    scalar value

        AnyElement operator

        AverageUnitPrice() Function

        best practices

        conceptual model

        eSQL

        LINQ query

        MyFunction class

        parameters

        products and categories

        query model

<ModificationFunctionMapping> tag

MyFunction class

NoTracking option

N-Tier applications

    concurrency

        Service Contract

        single Order entity

    definition

    deleting entities

    WCF service (see Windows Communication Foundation (WCF) service)

    Web API application

        ASP.NET MVC 4 Web Application project

        Cleanup action method

        Client.DeleteAsync method

        client-side change tracking

        Connection string for

        context class

        Customer and Phone Entity Classes

        Customer and Phone Numbers model

        Customer Web API Controller

        DeleteAsync method

        Entity Base class and TrackingState enum type

        Entity Framework Model Compatibility check

        GetAsync method

        HttpClient object

        HttpResponseMessage object

        HttpResponseMethod

        model for orders

        model for Travel Agents and Bookings

        OrderController

        order entity class

        Post Action Method

        PostAsync method

        PutAsJsonAsync method

        Retrieve Action Method

        RouteConfig Class, RPC-Style Routing

        SaveChanges method

        single disconnected entities

        steps

        Travel Agent and Booking Entity Classes

        Travel Agent Web API Controller

        UpdateCustomer Action Method

        Windows Console Application, test client

NuGet Package Manager

Object Relational Mapping (ORM)

Objects customization

    code execution

        DbContext

        job applicant model

        Resume File deletion

        SaveChanges()

    default value assignment

        attribute

        Paid property

        PurchaseOrder table

        SaveChanges event

        store layer

    entity deletion

        cascade rule

        Course, Class, and Enrollment tables

        DbContext

        generic way

        SQL Server Management Studio

    entity validation

        business rules

        customers and orders

        IValidatable interface

        ObjectContext

        SaleOrder

    logging database connection

    original association

        fulfillment steps for order

        IsRelationship

        ObjectContext

        Order and OrderStatus

    original value retrieval

        ApplicationException

        business rule

        employee entity

        overridden event

    property validation

        IsActive property

        monitoring the change

        OnUserNameChanging() method

        partial methods

        PropertyChanging and PropertyChanged events

        User entity

    property value recalculation

        AssociationChanged event

        CartItems collection

        cart model

        CollectionChangedEventArgs

        EntityCollection and EntityReference

        Sum() method

    server-generated value

        ParkingTicket entity

        ParkingTicket table

        Populated Back

        StoreGeneratedPattern

        trigger

    XML data retrieval

        candidate entity

        CandidateResume Property

        Changed event

        Resume property

        scalar property

Object services

    command line

    connection string

    database context

    database table

    dependent entity

    deployment

    pluralization service

    query method

    SaveAccountTransactionsAsync() call

    tracker changing

OfType<>() method

OfType<Plumber>() method

OnModelCreating method

OnUserNameChanged()

Optimistic concurrency

    Concurrency Mode property

    Product entity

    Table per Type inheritance

OrderBy() method

OverwriteChanges option

Performance improvement

    auto-caching LINQ query

    CreateProxyTypes() method

    Include() method

        ConnectionStrings

        customer, creditcard, and transaction entity classes

        DbContext Object

    POCO

    properties

    read-only access

    resume entity, body property

    search query

        ConnectionStrings

        DbContext object

        keyword and explicit condition

        LINQ/SQL query

        reservation entity

    single entity retrieval

        ConnectionStrings

        DbContext object

        Find() method

        LINQ query

        painting entity type

    Table per Type inheritance model

PhonePlan

Plain Old CLR Objects (POCO)

    Change Tracker

        Change-tracking proxies

        DetectChanges() method

        SaveChanges() method

        snapshot change tracking

        working principle

    change-tracking proxies

        benefits

        donors and donations

        requirements

        virtual and ICollection<T> type

        working principle

    complex types

        delete/update entity

        employee model

        Name class

        rules

        working principle

    database model

    Entity Framework model

        classes

        DbContext

        steps involved

        working principle

    integration testing

        BookRepository Class

        working principle

    lazy loading

        Entity Classes Generation and Properties

        traffic tickets, offending vehicles and violation details

        working principle

    load related entities

        Eager Loading

        Explicit Loading

        Include() method

        lazy loading

        venues, events, and competitors

        working principle

    retrieve object

        Entry() Method

        single Item entity

        working principle

    unit testing

        Fake Object Set and Fake Object Context

        IReservationContext

        IReservationRepository class

        IValidate Interface

        reservations, schedules and trains

        SaveChanges() method override

        Tests project

        working principle

POCO

    CreateDatabase()

    DropDatabase()

PostAsJsonAsync method

PostAsync method

PreserveChanges option

Print() method

ProductId property

PromoteToMedicine()method

PropertyEventArgs parameter

ProxyDataContractResolver class

Querying in-memory entities

    Club Entity Class

    Connection String

    Context Class

    DbSet Object

    model

Query() method

Read() method

Recipe1Context

Recipe1.Service project

Reference() method

RelatedEnd

Reload() method

RunForEachAsyncExample() method

SaveAccountTransactionsAsync() call

SaveChanges()

SaveChangesAsync() method

SaveChanges() method

SaveChanges() operation

Schema Definition Language (SSDL)

Search engine optimization

SelectMany()method

Select statement

Service1.svc.cs file

SingleOrDefault() method

Skip() and Take() methods

Snapshot change tracking

Solution Explorer

SqlFunctions class

SQL query

    context object

    Desert Sun Club

    Include() method

    local collection

    Star City Club

SqlQuery<T>() generic method

SqlQuery() method

StateChange event

Stored procedures

    complex type

    custom function

    definition

    entity collection, code second approach

    insert, update, and delete actions

        Athlete entity

        code

        many-to-many association

        Table per Hierarchy inheritance

    output parameters

    single scalar value

    Table per Hierarchy inheritance model

    Table per Type inheritance model

StringBuilder class

SubmitPost() method

Sum()

Table per Hierarchy inheritance (TPH)

Text Template Transformation Toolkit

ToList() method

Transitive relationship

Translate() method

Treat() function

Truncate() function

Update Action Method

UpdateCustomer action method

UpdateCustomer method

UpdateOrderWithoutRetrieving()

User entity

@Vendor parameter

VisitorSummary() function

Visual Studio solution

vwLibrary entity

Where clause

Where() method

Windows Communication Foundation (WCF) service

    ADO.NET Entity Data Model

    blog posts and comments, model for

    Connection String

    DbContext object

    payments on invoices, model for

    POCO Classes

    Recipe2 project

    serialization of the proxy

        client entity

        client POCO Class

        custom operation behavior attribute

        DataContractResolver

        DataContractSerializer

        GetClient() method

        GetClient() service method

        IService1 Interface

        Windows console application test client

    Service Contract

    service library

    Simple Console Application

    WCF Service Library

    Windows Console Application

Windows Console Application

XElement class