Sams Teach Yourself ADO.NET in 21 Days
| for RuBoard |
Abort method
threads
abstract base classes 2nd
base classes
conditional tracing 2nd 3rd 4th 5th
connection management
creating 2nd 3rd 4th 5th 6th 7th 8th
custom exceptions 2nd 3rd
exception handling
tracing
abstract factory patterns
abstracted providers
definition
in data services tier
abstracting
data
with ObjectSpaces Framework 2nd
data providers 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data providers for data access classes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
statements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th
abstracting data providers
code 2nd 3rd 4th 5th
abstraction
stored procedures
abstractions
stored procedures
AcceptChanges method
DataRow class
DataSet class
DataTable class
rows
table rows 2nd
AcceptChanges methods
AcceptChangesDuringFill property
data adapters (.NET Data Providers)
accepting
connection strings
code 2nd
AcceptRejectRule property
Access
accessing
data
accessing;object-oriented syntax
Odbc provider
relationally
server-side cursors 2nd 3rd 4th
SQLXML 2nd 3rd 4th 5th 6th 7th
techniques
with Data Adapter Configuration Wizard
with SQL Server .NET 2nd 3rd 4th 5th
Excel
ODBC data sources 2nd 3rd 4th 5th
commands, creating 2nd 3rd
connection pooling 2nd 3rd
connections, opening 2nd 3rd
Odbc provider 2nd 3rd 4th 5th
XML documents
Active Data Services ( renamed ). [See RDS]
Active Directory Services Interface (ADSI)
Active Server Pages. [See ASP]
adapter patterns
definition
adapters
data
SqlDataAdapter
TitlesDs DataSet, code to populate 2nd
TitlesDs DataSet, popullating
adapters of data
SelectCommand
adapters of data. [See data adapters [edit, move any entries to data adapters]]
adapters. [See also data, adapters]2nd [See also data adapters]
Add method 2nd 3rd
DataRelationCollection class
DataSet class, populating
rows
adding to tablees
Add New Item
command (File menu)
dialog box
Add New Item dialog box
strongly typed DataSet classes 2nd
Add Reference dialog box
ADO Recordset object, reading data
Add value (MissingSchemaAction enumeration)
Add Web Reference command (context menu)
Add Web References dialog box 2nd
Add Web User Control dialog box
AddCriteria method
Added value (DataRowState enumeration)
Added value (DataViewRowState enumeration)
adding
attributes
to connection strings
DataGrid controls to caches
event handlers to MergeFailed event, code 2nd
parameters
to collections
rows
code 2nd
with Add method
AddNew method
DataView class
Address class
code 2nd 3rd 4th 5th 6th 7th
AddressOf keyword
AddressOf statement
AddReviewsRow method
AddWithKey value (MissingSchemaAction enumeration) 2nd
administrators. [See also DBA]
ADO
database connections, pooling
infrastructure
knowledge
leveraging in ADO.NET design 2nd
Pure Visual Basic [edit, italics)
ADO Recordset objects
COM Interop functionality
data
reading 2nd 3rd 4th 5th 6th 7th 8th 9th
ADO+. [See ADO.NET]
ADO.NET 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
architecture
code
commands 2nd 3rd 4th 5th 6th 7th 8th
commands, creating 2nd 3rd 4th 5th
data adapters, configuring 2nd 3rd 4th
data connections 2nd
design goals
ADO knowledge, leveraging 2nd
multi-tiered programming models 2nd
programming errors, reducing 2nd 3rd
relational and object-oriented paradigms , combining 2nd
XML (eXtensible Markup Language) standards, integrating 2nd
in .NET
assembly
CTS (Common Type System) 2nd 3rd
language choices 2nd
managed code, reviewing 2nd 3rd 4th 5th 6th 7th
manifests
modules 2nd
public keys (strong names )
reference types
System.Data namespaces 2nd 3rd 4th 5th
System.Data namespaces, interface-based programming 2nd
System.Data namespaces, providers (generic versus specific) 2nd 3rd
System.Data.Common namespace
System.Data.dll
System.Data.OleDb namespace
System.Data.SqlClient namespace
System.Data.SqlTypes namespace
System.Xml namespace
value types
infrastructure
MDAC
(Microsoft Data Access Components ) 2nd 3rd
multi-tiered applications
data services tier, abstracted providers
data services tier, direct approach
data services tier, exposing custom objects
data services tier, exposing data readers
data services tier, exposing DataSet objects
data services tier, exposing methods
data services tier, external view 2nd 3rd 4th 5th
data services tier, internal data factory 2nd
data services tier, internal view 2nd 3rd 4th 5th
name origin 2nd
ODBC
( Open Database Connectivity) 2nd 3rd 4th
OLE DB 2nd 3rd 4th
Recordset objects 2nd
referencing
SOAP
(Simple Object Access Protocol)
VS .NET
business services applications
code, viewing 2nd 3rd 4th
concurrency;definition
Data Adapter Configuration Wizard 2nd
Data Adapter Configuration Wizard, accessing data
Data Adapter Configuration Wizard, naming stored procedures
Data Adapter Configuration Wizard;opening
data adapters;creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
data adapters;previewing
data services applications
DataSets;creating 2nd 3rd
presentation applications
Server Explorer window 2nd
Server Explorer window, Data Connection node 2nd 3rd 4th 5th
two-tier applications, definition
user interfaces, creating 2nd 3rd 4th 5th 6th
user interfaces, data retrieval 2nd 3rd 4th
user interfaces, event binding 2nd 3rd
user interfaces, event editing 2nd 3rd 4th 5th 6th 7th 8th 9th
user interfaces, navigating 2nd
W3C
(World Wide Web Consortium) 2nd
Web improvements 2nd 3rd 4th 5th
XML
(eXtensible Markup Language) 2nd 3rd 4th
ADS
(Active Data Services). [See RDS]
ADSI (Active Directory Services Interface)
Advanced dialog box
simple binding 2nd
Advanced Options button
stored procedures
aggegate functions
Expression property 2nd 3rd
aggregate functions
COUNT
Aggregate Functions (expression syntax rule)
data, selecting
aggregation of data
AL.exe (Assembly Linker) command-line utility 2nd
aliasing
components
AllowDBNull property
DataColumn class 2nd
AllowDelete property
DataView class
AllowEdit property
DataView class
AllowNew property
DataView class
AndAlso operator
Finally block
any icon (XML Schema tab of XML Schema Toolbox)
anyAttribute icon (XML Schema tab of XML Schema Toolbox)
AppDomains
DataSets
passing between
types, copying with NET [edit, period before] Remoting
AppDomains (Application Domains)
definition
Application Domains (AppDomains)
definition
Application Name attribute (SqlClient provider)
application-centric or data-centric (designing data access classes), comparing 2nd
application-specific stored procedures
ApplicationException class
applications
ASP.NET
connection strings, storing 2nd 3rd 4th 5th
Building Distributed Applications with Visual Basic .NET [edit, italics]
business services
definition
client
assemblies
binding policies
ComputeBooksSimple
data services
definition
databases
summarized data
interoperability
ADO Recordset objects, reading data 2nd 3rd 4th 5th 6th 7th 8th 9th
locking contention
n-tiered
GetChanges methods
NET [edit, period before]
architecture
performance
performance, optimizing
databases, favoring output parameters over DataSets 2nd
databases, indexes 2nd
databases, stored procedures
managed code, ASP.NET caching 2nd 3rd
managed code, connection pooling 2nd
managed code, data readers 2nd
managed code, delegates 2nd 3rd 4th 5th 6th 7th
managed code, narrow providers 2nd
managed code, query multithreading 2nd 3rd 4th 5th 6th 7th 8th 9th
managed code, round trips to database servers 2nd
managed code, Thread class 2nd 3rd
queries, performing joins on servers 2nd
queries, requesting columns 2nd
queries, requesting rows 2nd
presentation
definition
scalability
scalability, optimizing 2nd 3rd
databases, favoring output parameters over DataSets 2nd
databases, indexes 2nd
databases, stored procedures
managed code, ASP.NET caching 2nd 3rd
managed code, connection pooling 2nd
managed code, data readers 2nd
managed code, delegates 2nd 3rd 4th 5th 6th 7th
managed code, narrow providers 2nd
managed code, query multithreading 2nd 3rd 4th 5th 6th 7th 8th 9th
managed code, round trips to database servers 2nd
managed code, Thread class 2nd 3rd
queries, performing joins on servers 2nd
queries, requesting columns 2nd
queries, requesting rows 2nd
scale-out
scale-out, definition
scale-up , definition
two-tier
definition
VC# .NET console application project
strongly typed DataSet classes
applications. [See also multi-tiered applications]2nd [See also Windows Forms applications]
ApplyDefaultSort property
DataView class
architctures
data readers
architectures
ADO.NET
ComputeBooks
data provider
Global XML Web Service Architecture (SOAP)
multi-tiered applications 2nd 3rd 4th 5th 6th
benefits
business services tier 2nd
data services tier 2nd
extensability
maintainability
physical tiers, relation to 2nd 3rd 4th 5th 6th 7th
presentation services tier
rapid development
reusability
specialization
Web services 2nd
NET [edit, period before] applications
NET [edit, period before] Data Providers 2nd 3rd 4th
classes
Command Builder
command object
components
connection object
data adapters
data reader
errors
exceptions
generic providers
interfaces
objects
parameters
permissions
specific providers
SQL Server
SqlClient
transaction classes
ODBC
Odbc data provider
SQL Server clients
Windows Forms data binding 2nd
architectures. [See also WOSA]
arguments
event argument properties 2nd
handling in stored procedures
OleDbCommand object
passing
to delegates
to threads
arrays
declarations
in C#
in VB
writing
code 2nd
articles
Asynchronous Design Pattern Overview [edit, in double quotes]
Data Access Application Block [edit, double quotes]
Object Role Modeling[ colon ] An Overview [edit, place title in double quotes]
asmx [edit, period before] file extension
ASP
(Active Server Pages)
Session object
storage weaknesses 2nd
ASP.NET
event-driven programming model
Global.asax file
ASP.NET applications
connection strings
storing 2nd 3rd 4th 5th
ASP.NET caching
DataFactory class
managed code 2nd 3rd
ASP.NET page output caching
ASP.NET State service
session data, storing 2nd
assemblies
base classes
compiling
client applications
GAC (Global Assembly Cache)
interop
permissions 2nd
PIA (primary interop assembly)
definition
private assembly
storing
System.Data.dll
version numbers , creating
assembly
definition 2nd
Assembly class
[ ] (brackets)
Assembly Linker (AL.exe) command-line utility 2nd 3rd
asterisk (*)
wildcard character
asynchronous delegates
Asynchronous Design Pattern Overview [edit, in double quotes] article
AsyncResult object
AttachDBFileName attribute (SqlClient provider)
attribute icon (XML Schema tab of XML Schema Toolbox)
attributeGroup icon (XML Schema tab of XML Schema Toolbox)
attributes
adding
to connection strings
Application Name (SqlClient provider)
AttachDBFileName (SqlClient provider)
AUTOREGISTER
methods
Connect Timeout (SqlClient provider)
Connection Lifetime (SqlClient provider)
Connection Reset (SqlClient provider)
Current Language (SqlClient provider)
Data Source (SqlClient provider)
definition
Enlist (SqlClient provider)
for providers, determining
Initial Catalog (SqlClient provider)
Integrated Security (SqlClient provider)
MappingType
Hidden value
Max Pool Size (SqlClient provider)
Min Pool Size (SqlClient provider)
Network Library (SqlClient provider) 2nd
of permissions, declaring
Packet Size (SqlClient provider)
Password (SqlClient provider)
PERMISSION SET
CAS (code access security) permission
Persist Security Info (SqlClient provider)
Pooling (SqlClient provider)
Prefix
Serializable
Serializable (ComputeBooksDAException class)
SoapDocumentService
parameters, encoding
SoapRpcMethod
Web method
SqlClient provider
connection pooling 2nd
connections 2nd 3rd 4th 5th 6th
System.Xml.Serialization.SerializableAttribute
Use Procedure For Prepare (SqlClient provider)
User ID (SqlClient provider)
username
VaryByParam
WebMethod
Workstation ID (SqlClient provider)
authoring
classes
in multiple languages
Auto value (XmlReadMode enumeration) 2nd
auto-incrementing columns 2nd 3rd 4th 5th 6th
tables
defining, code 2nd
AutoIncrement
DataColumn class [See d property]2nd [See d property]
AutoIncrement property
DataColumn class 2nd
AutoIncrementStep property
DataColumn class 2nd
AUTOREGISTER attribute
methods
Available References window 2nd
Avg function
| for RuBoard |