Data Provider for .NET Guide - Index
-
A -
C -
D -
E -
F -
G -
I -
L -
M -
N -
O -
P -
Q -
R -
S -
T -
U -
W -
Symbols
? for parameter markers
A
adding
connections to a connection pool
references in Solution Explorer
ADO.NET, use of OLE DB
AllowPartiallyTrustedCallers
alternate database servers, specifying
Alternate Servers connection string option
arrays, parameter
assembly
name
overview
C
client load balancing
about
connection string option
code examples
calling a stored procedure
connecting to a database
for each data provider
inserting data into LONGVARCHAR columns
limiting the number of rows returned by a Select statement
modifying data in a rowset
retrieving a scalar value
retrieving warning information
using a DataReader 1 2
using a local transaction
using CommandBuilders
Command object
code example
command that does not return a result
threading support
using to limit rows returned
CommandBuilder object
impact on performance
sample code
connecting
improving performance
overview
resetting the state of the connection
specifying connection properties
connection failover
about
connection retry and
load balancing and
Connection Lifetime
Connection object
properties
threading support
connection pool
adding connections
creating
default behavior
enabling
maximum number of pools
minimum number of connections
removing connections
connection retry
about
connection string option
overview
Connection Retry Count connection string option
Connection Retry Delay connection string option
connection string options
overview
spaces in option names
connection string options, specifying
conventions, typographical
counters, PerfMon
cursor, forward-only
D
data encryption
data types
choosing to improve performance
Pervasive
DataAdapter object
properties
retrieving a result set
DataReader object
code example 1 2
methods supported
properties supported
using a stored procedure
using a transaction
DataSet
date, time, timestamp literal escape sequences
debugging
overview
using the Trace object to maintain security
DeriveParameters
designing .NET applications
See performance optimization
diagnostic support
disconnected DataSet
E
enabling tracing
Encrypted Network Communications
encryption
environmental variable use in tracing
error handling
Error object, properties supported
ErrorCollection object
checking for multiple errors
properties supported
escape sequences
date and time
outer join
event handling
events, using with stored procedures and functions
examples
See coding examples 1 2
ExecuteNonQuery
executing a command
executing a query that does not return results
F
Framework types
FullTrust
functions
functions supported
G
GetSchemaTable method
Global Assembly Cache (GAC)
glossary
I
InfoMessage delegates
InfoMessageEventArgs object
isolation levels
data consistency behavior
compared
dirty reads
non-repeatable reads
phantom reads
data currency
description
read committed
read uncommitted
repeatable read
serializable
support
L
limiting the rows returned by a Select statement
literal parameter values
literals, escape sequence
load balancing
See client load balancing
local transactions
code example
using
locking
modes and levels
overview
M
managed code
mapping PsqlDbTypes
methods
data provider-specific
supported public
tracing calls
N
namespace
native managed providers, performance advantages
numeric functions
O
object
exposing
overview
provider-specific prefix
PsqlCommand
PsqlCommandBuilder
PsqlConnection
PsqlDataAdapter
PsqlDataReader
PsqlError
PsqlErrorCollection
PsqlException
PsqlInfoMessageEventArgs
PsqlParameter
PsqlTrace
PsqlTransaction 1 2
supported .NET public
operating systems supported
outer join escape sequence
P
page-level locking
parameter
array support
in an Update statement
in stored procedures
markers
in query statements
in stored procedures
using the ? symbol
Parameter object
adding to a collection
properties
parameter types
ParameterCollection object
parameter markers
parameters, using in a SQL statement
password, concealed in trace log
Perfmon support
performance optimization
avoiding use of CommandBuilder objects
choosing the right data type
general
managing connections
resetting the state of a connection
size of data retrieved
synchronizing changes back to the database
using a PsqlCommandBuilder object
using disconnected DataSet
using local transactions
using native managed providers
Pervasive.SQL data provider
assembly name
calling a stored procedure
connection retry
connection string options
creating a connection pool
data types
DeriveParameters method
enabling connection pooling
error handling
event handling 1 2
isolation levels
load balancing
mapping parameter types
methods
namespace
objects
outer join escape syntax 1 2 3
parameter arrays
parameter markers 1 2
properties
retrieving a result set using a DataAdapter object
retrieving warning information
sample code
calling a stored procedure
data access task
limiting the rows returned by a Select statement
retrieving a result set
retrieving a scalar value
retrieving data using a DataReader
retrieving warning information
using a local transaction
using the CommandBuilder
streams as input to long data parameters 1 2 3
synchronizing changes back to the database
thread support 1 2
tracing method calls 1 2
transaction support 1 2
Unicode support 1 2
using a local transaction
using the CommandBuilder
platforms supported
pooling connections
maximum number of pools
minimum number of connections
overview
prefix on a public object
private assembly
properties
PsqlCommand object
PsqlCommandBuilder object 1 2
PsqlConnection object
PsqlDataAdapter object
PsqlDataReader object
PsqlDbType 1 2
PsqlError object
PsqlErrorCollection object
PsqlException object
PsqlInfoMessageEventArgs object
PsqlParameter object 1 2
PsqlTrace object
PsqlTransaction object 1 2
Q
query statements, parameterized
query that does not return results, executing
quick start
R
ReadCommitted isolation level
removing connections from a connection pool
resetting connection state
result set, retrieving using a DataAdapter object
retrieving
data using a DataAdapter object
data using a DataReader 1 2
long data
scalar value
warning information
S
sample code
calling a stored procedure
creating the emp table
for each data provider
limiting the number of rows returned by a Select statement
modifying data in a rowset
retrieving a scalar value
retrieving warning information
tables used in the code examples
using a DataReader 1 2
using a local transaction
using CommandBuilders
scalar functions
code example
overview
security
attributes
enabling for tracing
for more information
required permissions
Select statement, limiting rows returned
Serializable isolation level
Server Name
Server Type
serviced components
shared assembly
specifying connection attributes
SQL escape sequences
date, time, timestamp
general
outer join
scalar functions
stored procedures
code example
output array support
support for
using parameter markers as arguments
using the ? symbol in SQL statements
stream objects
code examples
data types supported
using as input to long data parameters 1 2
string functions
overview
strong name
synchronizing changes back to the database
system functions
System.Data.DbTypes
T
threading support
time literal escape sequence
timedate functions
timestamp literal escape sequence
Trace object
properties supported
using
tracing
enabling
method calls
overview
recreating the trace file
setting the path to the trace file
Transaction object
properties
transactions
code example
support for local
typographical conventions
U
Unicode support
Update statement, using parameters in
W
warnings, handling database server
Windows operating systems supported
wire encryption
Symbols
.NET
example using Solution Explorer
Framework data types 1 2
programming resources
security 1 2
supported public objects
