Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

Object Browser

     class diagrams, creating

Object Explorer

     CLR executables, viewing

     compared to Visual Studio Server Explorer

objects [See also classes, BindingNavigator; controls, BindingNavigator.]

     addressing in SQL Server

     AsyncCallback

     DataColumn

     DataRow 2nd

    DataSet

         Load method

         overview of 2nd

         populating

         strongly typed DataSets

    DataTable

         DataColumns

         DataRows

         joins

         Load method

         overview of 2nd

         populating DataSets with

         populating from SqlDataReader

     Delegate

     DeleteCommand

     disposing of

     duplicating

     InsertCommand

    instantiating

         constructors

         overview of

         scope

         Using block

     ownership

    populating [See populating data structures, DataSet Load method.]

     SelectCommand

    SqlCommand [See SqlCommand objects.]

     SqlConnection

    SqlDataReader

         best practice designs

         fetching all columns

         fetching individual rows

         fetching metadata

         Get functions

         GetSchemaTable method

         HasRows function

         overview of

         testing stream for data 2nd

     TableAdapter 2nd 3rd

         adding parameters to queries

         binding to

         configuring

         defined

         generated parameters, managing

         intertable relationships, managing in Data Source designer

         limitations of

         overview of 2nd

         parameters, configuring with Visual Studio

         selecting Query methods

         single-table TableAdapters

         stored procedures 2nd 3rd

         updating tables with

     UpdateCommand

     WaitHandle 2nd

ODBC (Open Database Connectivity)

OLEDB

OnNullCall setting (SqlMethodAttribute property)

Open Database Connectivity (ODBC)

Open method

Open Table Definition dialog

opening connections

     automatically

     SQL Server connections 2nd

operations, canceling

operators

     BETWEEN

     FETCH

     IN

     JOIN

     LIKE

     TRUNCATE TABLE

     Using

optimizing performance [See performance, CLR executable performance, evaluating.]

Options command (Tools menu)

Options dialog (Visual Studio)

ORDER BY clause

order of columns, changing

OriginalParametersToDrillthrough property (LocalReport class)

outer joins

OUTPUT parameters

overflow (connection pools)

OverwriteChanges setting (ConflictOption property)

ownership 2nd

Ozzie, Ray