3160 Vocab Exam III

27 cards·by IMObutters

Database Management Systems

software that is specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.

Data-Bound Control

a user interface control that is connected to a data source.

DataSource Property

identifies the table from which the ListBox will get its data.

DisplayMember Property

identifies the column from which the ListBox will get its data.

Primary Key

is a field that can be used to identify a specific row

Foreign Key

a one-to-many relationship

Identity Column

column that contains unique values that are generated by the DBMS

Microsoft SQL Server

A database management system that can interact with C#

Queries

answerthe keywords to construct statements

Relational Database

a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the da

Structured Query Language

a standard language for working with database management systems.

Table Adapter Query

an SQL statement that is stored in a table adapter and can be executed simply by calling a method

Anonymous Types

provide a convenient way to encapsulate a set of read-only properties into a single object without having to explicitly define a type first

Declarative Programming

LINQ specifies the conditions that selected elements must satisfy.

Imperative Programming

You specify the actual steps to perform a task.

From clause

specifies a range variable and the data source to query

IEnumerable Interface

describes the functionality of any object that can be iterated over and thus offers members to access each element.

Implicitly Typed Variables

enables the compiler to infer a local variable’s type based on the context in which it’s used.

Language Integrated Query

allows you to write query expressions, similar to SQL queries, that retrieve information from a variety of data sources, not just databases.

LINQ Extension Methods

can be used to enhance a class’s capabilities without modifying the class’s definition.

LINQ Provider

a set of classes in .NET that implement LINQ operations and enable programs to interact with data sources to perform tasks

Orderby clause

sorts the query results in ascending order.

Select clause

determines what value appears in the results.

ADO.NET Entity Data Model

Set of concepts that describe data structure, regardless of its stored form.

ADO.NET Entity Framework

Used to create an entity data model that represents a database and generates the SQL statements that interact with the database

Entity Relationship Diagram

a conceptual and representational model of data used to represent the entity framework infrastructure.

NuGet

the package manager for the Microsoft development platform including .NET.