• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/24

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

24 Cards in this Set

  • Front
  • Back

We architect, design and program at a conceptual level that is very different from the typical relational database system's logical and physical design, resulting in a difference in paradigms between our data and our programs. What is this paradigm difference often called?

Impedance mismatch

Entity Framework (EF) is a type of data access framework for bridging object-oriented class hierarchies and highly-normalized data known as a type of ____________________ software or simply a(n) ____ (acronym).

Object Relational Mapping or ORM

In Entity Framework (EF) (or other ORM tool), when we model real world concepts or other objects, we call them ____________

Entity Classes (or Entities) or Entity Objects

In EF, what do we call relationships between entities?

Associations

What other Microsoft tool, when used with EF, allows us to program directly against our entity classes and associations, using a concise syntax, in .NET code? ______________________ (name) or ________ (acronym)

Language-Integrated Query framework, or LINQ

The model that you create in EF is a construct known as a(n) ________________ (name) or _________ (acronym)

Entity Data Model or EDM

A. The Entity Data Model (EDM) in EF 6 will allow you to model entities to data tables in what cardinalities?


B. What is the default cardinality that EF will create between entities and data tables?

One-to-one (default)


Multiple tables to one entity


One table to multiple entities

What are the three layers of the Entity Data Model (EDM)?

1. Conceptual layer


2. Store


3. Mapping layer

The syntax for the conceptual layer of the EDM is defined in the ___________________ (name) or _______ (acronym).

Conceptual Schema Definition Language (CSDL)

The syntax for the store layer of the EDM is defined in the _______________________ (name) or _______ (acronym).

Store Schema Definition Language (SSDL)

The syntax for the mapping layer of the EDM is defined in the ________________________ (name) or _______ (acronym).

Mapping Specification Language (MSL)

The mapping layer of the EDM defines the mapping between what other EDM layers?

Conceptual layer and store layers

What term represents a class in your domain model in EF or other ORM?

An EntityType

What is an instance of an EntityType called?

An Entity

Like classes, an EntityType usually has one or more _______________ each consisting of a _____________ with a specific ________________.

properties


named value


data type

EntityType properties that refer to related entities are called _________________ and are typically represented by __________________ in a database.

Navigation properties


foreign key relationships

A relationship between two entities is called a(n) ________________

association

The line between two entities in the EDM is annotated to show the ________________ on each end of the association.

multiplicity

Every EntityType has a property or set of properties that uniquely identifies each instance of the entity. This is known as the ___________ . It is most often mapped to the _____________ in the database.

EntityKey


primary key

In EF, the object that exposes the entity objects, methods for managing the database connection, generating parameterized SQL, marshalling data, caching objects, maintaining change tracking and materializes an untyped result set into a collection of strongly typed objects is called ____________ .

context object

The process of transforming an untyped result set from the database into a collection of strongly typed objects is called _____________ .

materializing

Originally, the only way to work with EF was through the _____________ object. Now, there is an alternate context object that is a wrapper around the original object above, called the ____________ that offers a more streamlined and simplified developer experience. The preferred approach of the two of these is to use the __________ .

ObjectContext


DbContext


DbContext

Visual Studio uses a code-generation technology referred to as T4 templates. What does T4 stand for?

Text Template Transformation Toolkit

Visual Studio uses T4 templates to generate, or ___________ code quickly.

scaffold