ADO.NET in a Nutshell

Mapped

SchemaType

MappingType

System.Data

MaxLength

DataColumn

MaxPrecision

SqlDecimal

MaxScale

SqlDecimal

MaxValue

SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

Member_Name

OleDbLiteral

Merge( )

DataSet

MergeFailed

DataSet

MergeFailedEventArgs

System.Data

MergeFailedEventHandler

System.Data

Message

OleDbError, OleDbException, OleDbInfoMessageEventArgs, SqlError, SqlException, SqlInfoMessageEventArgs

MinimumCapacity

DataTable

MinValue

SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

MissingMappingAction

DataAdapter, IDataAdapter, System.Data

MissingPrimaryKeyException

System.Data

MissingSchemaAction

DataAdapter, IDataAdapter, System.Data

Mod( )

SqlByte, SqlInt16, SqlInt32, SqlInt64

Modified

DataRowState

ModifiedCurrent

DataViewRowState

ModifiedOriginal

DataViewRowState

Money

SqlDbType

MoveNext( )

DbEnumerator

Multiply( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

Namespace

DataColumn, DataSet, Data-Table

NativeError

OleDbError

NChar

SqlDbType

Nested

DataRelation

NewRow( )

DataTable

NewRowFromBuilder( )

DataTable

NextResult( )

IDataReader, OleDbDataReader, SqlDataReader

None

AcceptRejectRule, DataViewRowState, Rule, SqlCompareOptions, UpdateRowSource

NoNullAllowedException

System.Data

NotEquals( )

SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

Nothing

DataRowAction

NotSupported

PropertyAttributes

NText

SqlDbType

Null

SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

Number

SqlError, SqlException

Numeric

OleDbType

NVarChar

SqlDbType

Object

DbType

Offset

SqlParameter

OleDbCommand

System.Data.OleDb

OleDbCommandBuilder

System.Data.OleDb

OleDbConnection

System.Data.OleDb

OleDbDataAdapter

System.Data.OleDb

OleDbDataReader

System.Data.OleDb

OleDbError

System.Data.OleDb

OleDbErrorCollection

System.Data.OleDb

OleDbException

System.Data.OleDb

OleDbInfoMessageEventArgs

System.Data.OleDb

OleDbInfoMessageEventHandler

System.Data.OleDb

OleDbLiteral

System.Data.OleDb

OleDbParameter

System.Data.OleDb

OleDbParameterCollection

System.Data.OleDb

OleDbPermission

System.Data.OleDb

OleDbPermissionAttribute

System.Data.OleDb

OleDbRowUpdatedEventArgs

System.Data.OleDb

OleDbRowUpdatedEventHandler

System.Data.OleDb

OleDbRowUpdatingEventArgs

System.Data.OleDb

OleDbRowUpdatingEventHandler

System.Data.OleDb

OleDbSchemaGuid

System.Data.OleDb

OleDbTransaction

System.Data.OleDb

OleDbType

OleDbParameter, System.Data.OleDb

OnCollectionChanged( )

ConstraintCollection, DataColumnCollection, DataRelationCollection, DataTableCollection

OnColumnChanged( )

DataTable

OnColumnChanging( )

DataTable

One

SqlBoolean

OnesComplement( )

SqlBoolean, SqlByte, SqlInt16, SqlInt32, SqlInt64

OnFillError( )

DbDataAdapter

OnListChanged( )

DataView, DataViewManager

OnRemoveRelation( )

DataSet

OnRemoveTable( )

DataSet

OnRowChanged( )

DataTable

OnRowChanging( )

DataTable

OnRowDeleted( )

DataTable

OnRowDeleting( )

DataTable

OnRowUpdated( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter

OnRowUpdating( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter

Open

ConnectionState

Open( )

DataView, IDbConnection, OleDbConnection, SqlConnection

Optional

PropertyAttributes

Or( )

SqlBoolean

Ordinal

DataColumn

Original

DataRowVersion

OriginalRows

DataViewRowState

OriginalState

StateChangeEventArgs

Output

ParameterDirection

OutputParameters

UpdateRowSource

PacketSize

SqlConnection

ParameterDirection

System.Data

ParameterName

IDataParameter, OleDbParameter, SqlParameter

Parameters

IDbCommand, OleDbCommand, SqlCommand

ParentColumns

DataRelation

ParentKeyConstraint

DataRelation

ParentRelations

DataTable

ParentTable

DataRelation

Parse( )

SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

Passthrough

MissingMappingAction

Power( )

SqlDecimal

Precision

IDbDataParameter, OleDbParameter, SqlDecimal, SqlParameter

Prefix

DataColumn, DataSet, DataTable

Prepare( )

IDbCommand, OleDbCommand, SqlCommand

PreventUsage

KeyRestrictionBehavior

Primary_Keys

OleDbSchemaGuid

PrimaryKey

DataTable

Procedure

SqlError, SqlException

Procedure_Columns

OleDbSchemaGuid

Procedure_Name

OleDbLiteral

Procedure_Parameters

OleDbSchemaGuid

Procedures

OleDbSchemaGuid

Property_Name

OleDbLiteral

PropertyAttributes

System.Data

PropertyChanging

DataColumn, DataRelation, DataSet, DataTable

PropertyCollection

System.Data

Proposed

DataRowVersion

ProposedValue

DataColumnChangeEventArgs

PropVariant

OleDbType

Provider

OleDbConnection, OleDbPermission, OleDbPermissionAttribute

Provider_Types

OleDbSchemaGuid

Quote_Prefix

OleDbLiteral

Quote_Suffix

OleDbLiteral

QuotePrefix

OleDbCommandBuilder, SqlCommandBuilder

QuoteSuffix

OleDbCommandBuilder, SqlCommandBuilder

Read

PropertyAttributes

Read( )

IDataReader, OleDbDataReader, SqlDataReader

ReadCommitted

IsolationLevel

ReadOnly

DataColumn

ReadOnlyException

System.Data

ReadSchema

XmlReadMode

ReadUncommitted

IsolationLevel

ReadXml( )

DataSet

ReadXmlSchema( )

DataSet

ReadXmlSerializable( )

DataSet

Real

SqlDbType

RecordsAffected

IDataReader, OleDbDataReader, RowUpdatedEventArgs, SqlDataReader

Referential_Constraints

OleDbSchemaGuid

RefreshSchema( )

OleDbCommandBuilder, SqlCommandBuilder

RejectChanges( )

DataRow, DataSet, Data-Table

RelatedColumns

ForeignKeyConstraint

RelatedTable

ForeignKeyConstraint

RelationCollectionChanged( )

DataViewManager

RelationName

DataRelation

Relations

DataSet

ReleaseObjectPool( )

OleDbConnection

Remove( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataTableCollection, DataTableMappingCollection, OleDbParameterCollection, SqlParameterCollection

RemoveAt( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataTableCollection, DataTableMappingCollection, IColumnMappingCollection, IDataParameterCollection, ITableMappingCollection, OleDbParameterCollection, SqlParameterCollection

RemoveCore( )

DataRelationCollection

RepeatableRead

IsolationLevel

Required

PropertyAttributes

Reset( )

DataSet, DataTable, DataView, DbEnumerator

ResetCommandTimeout( )

OleDbCommand, SqlCommand

ReturnValue

ParameterDirection

Rollback

DataRowAction

Rollback( )

IDbTransaction, OleDbTransaction, SqlTransaction

Round( )

SqlDecimal

Row

DataColumnChangeEventArgs, DataRowChangeEventArgs, DataRowView, DBConcurrencyException, RowUpdatedEventArgs, RowUpdatingEventArgs

RowChanged

DataTable

RowChanging

DataTable

RowDeleted

DataTable

RowDeleting

DataTable

RowError

DataRow

RowFilter

DataView, DataViewSetting

RowNotInTableException

System.Data

Rows

DataTable

RowState

DataRow

RowStateFilter

DataView, DataViewSetting

RowUpdated

OleDbDataAdapter, SqlDataAdapter

RowUpdatedEventArgs

System.Data.Common

RowUpdating

OleDbDataAdapter, SqlDataAdapter

RowUpdatingEventArgs

System.Data.Common

RowVersion

DataRowView

Rule

System.Data

Save( )

SqlTransaction

SByte

DbType

Scale

IDbDataParameter, OleDbParameter, SqlDecimal, SqlParameter

Schema_Name

OleDbLiteral

Schema_Separator

OleDbLiteral

SchemaOnly

CommandBehavior

Schemata

OleDbSchemaGuid

SchemaType

System.Data

Select

StatementType

Select( )

DataTable

SelectCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter

SequentialAccess

CommandBehavior

Serializable

IsolationLevel

Server

SqlError, SqlException

ServerVersion

OleDbConnection, SqlConnection

SetColumnError( )

DataRow

SetDefault

Rule

SetNull

Rule

SetNull( )

DataRow

SetParentRow( )

DataRow

ShouldSerializeRelations( )

DataSet

ShouldSerializeTableMappings( )

DataAdapter

ShouldSerializeTables( )

DataSet

Sign( )

SqlDecimal

SimpleContent

MappingType

Single

DbType, OleDbType

SingleResult

CommandBehavior

SingleRow

CommandBehavior

Site

DataSet, DataTable

Size

IDbDataParameter, OleDbParameter, SqlParameter

SkipAllRemainingRows

UpdateStatus

SkipCurrentRow

UpdateStatus

SmallDateTime

SqlDbType

SmallInt

OleDbType, SqlDbType

SmallMoney

SqlDbType

Sort

DataView, DataViewSetting

Source

OleDbError, OleDbException, OleDbInfoMessageEventArgs, SchemaType, SqlError, SqlException, SqlInfoMessageEventArgs

SourceColumn

DataColumnMapping, IColumnMapping, IDataParameter, OleDbParameter, SqlParameter

SourceTable

DataTableMapping, ITableMapping

SourceVersion

IDataParameter, OleDbParameter, SqlParameter

Sql_Languages

OleDbSchemaGuid

SqlBinary

System.Data.SqlTypes

SqlBoolean

System.Data.SqlTypes

SqlByte

System.Data.SqlTypes

SqlClientPermission

System.Data.SqlClient

SqlClientPermissionAttribute

System.Data.SqlClient

SqlCommand

System.Data.SqlClient

SqlCommandBuilder

System.Data.SqlClient

SqlCompareOptions

SqlString, System.Data.SqlTypes

SqlConnection

System.Data.SqlClient

SqlDataAdapter

System.Data.SqlClient

SqlDataReader

System.Data.SqlClient

SqlDateTime

System.Data.SqlTypes

SqlDbType

SqlParameter, System.Data

SQLDebugging

System.Data.SqlClient

SqlDecimal

System.Data.SqlTypes

SqlDouble

System.Data.SqlTypes

SqlError

System.Data.SqlClient

SqlErrorCollection

System.Data.SqlClient

SqlException

System.Data.SqlClient

SqlGuid

System.Data.SqlTypes

SqlInfoMessageEventArgs

System.Data.SqlClient

SqlInfoMessageEventHandler

System.Data.SqlClient

SqlInt16

System.Data.SqlTypes

SqlInt32

System.Data.SqlTypes

SqlInt64

System.Data.SqlTypes

SqlMoney

System.Data.SqlTypes

SqlNullValueException

System.Data.SqlTypes

SqlParameter

System.Data.SqlClient

SqlParameterCollection

System.Data.SqlClient

SqlRowUpdatedEventArgs

System.Data.SqlClient

SqlRowUpdatedEventHandler

System.Data.SqlClient

SqlRowUpdatingEventArgs

System.Data.SqlClient

SqlRowUpdatingEventHandler

System.Data.SqlClient

SqlSingle

System.Data.SqlTypes

SQLState

OleDbError

SqlString

System.Data.SqlTypes

SQLTicksPerHour

SqlDateTime

SQLTicksPerMinute

SqlDateTime

SQLTicksPerSecond

SqlDateTime

SqlTransaction

System.Data.SqlClient

SqlTruncateException

System.Data.SqlTypes

SqlTypeException

System.Data.SqlTypes

State

IDbConnection, OleDbConnection, SqlConnection, SqlError, SqlException

StateChange

OleDbConnection, SqlConnection

StateChangeEventArgs

System.Data

StateChangeEventHandler

System.Data

StatementType

RowUpdatedEventArgs, RowUpdatingEventArgs, System.Data

Statistics

OleDbSchemaGuid

Status

RowUpdatedEventArgs, RowUpdatingEventArgs

StoredProcedure

CommandType

String

DbType

StringFixedLength

DbType

StrongTypingException

System.Data

Subtract( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

SyncRoot

DataViewSettingCollection, InternalDataCollectionBase

SyntaxErrorException

System.Data

Table

Constraint, DataColumn, DataRow, DataView, DataViewSetting, ForeignKeyConstraint, MergeFailedEventArgs, UniqueConstraint

Table_Constraints

OleDbSchemaGuid

Table_Name

OleDbLiteral

Table_Privileges

OleDbSchemaGuid

Table_Statistics

OleDbSchemaGuid

TableCollectionChanged( )

DataViewManager

TableDirect

CommandType

TableMapping

RowUpdatedEventArgs, RowUpdatingEventArgs

TableMappings

DataAdapter, IDataAdapter

TableName

DataTable

Tables

DataSet, OleDbSchemaGuid

Tables_Info

OleDbSchemaGuid

Text

CommandType, SqlDbType

Text_Command

OleDbLiteral

Time

DbType

Timestamp

SqlDbType

TimeTicks

SqlDateTime

TinyInt

OleDbType, SqlDbType

ToByteArray( )

SqlGuid

ToDecimal( )

SqlMoney

ToDouble( )

SqlDecimal, SqlMoney

ToInt32( )

SqlMoney

ToInt64( )

SqlMoney

ToSqlBinary( )

SqlGuid

ToSqlBoolean( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlByte( )

SqlBoolean, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlDateTime( )

SqlString

ToSqlDecimal( )

SqlBoolean, SqlByte, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlDouble( )

SqlBoolean, SqlByte, SqlDecimal, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlGuid( )

SqlBinary, SqlString

ToSqlInt16( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlInt32( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt64, SqlMoney, SqlSingle, SqlString

ToSqlInt64( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlMoney, SqlSingle, SqlString

ToSqlMoney( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlSingle, SqlString

ToSqlSingle( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlString

ToSqlString( )

SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

ToString( )

Constraint, DataColumn, DataColumnMapping, DataRelation, DataTable, DataTableMapping, OleDbError, OleDbInfoMessageEventArgs, OleDbParameter, SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlError, SqlGuid, SqlInfoMessageEventArgs, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlParameter, SqlSingle, SqlString

ToXml( )

DBDataPermission, OleDbPermission

Transaction

IDbCommand, OleDbCommand, SqlCommand

Translations

OleDbSchemaGuid

True

SqlBoolean

Truncate( )

SqlDecimal

Trustee

OleDbSchemaGuid

TypedDataSetGenerator

System.Data

TypedDataSetGeneratorException

System.Data

UInt16

DbType

UInt32

DbType

UInt64

DbType

Unchanged

DataRowState, DataViewRowState

Union( )

DBDataPermission, OleDbPermission

Unique

DataColumn

UniqueConstraint

System.Data

UniqueIdentifier

SqlDbType

UnsignedBigInt

OleDbType

UnsignedInt

OleDbType

UnsignedSmallInt

OleDbType

UnsignedTinyInt

OleDbType

Unspecified

IsolationLevel

Update

StatementType

Update( )

DataAdapter, DbDataAdapter, IDataAdapter

UpdateCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter

UpdatedRowSource

IDbCommand, OleDbCommand, SqlCommand

UpdateIndex( )

DataView

UpdateRowSource

System.Data

UpdateRule

ForeignKeyConstraint

UpdateStatus

System.Data

Usage_Privileges

OleDbSchemaGuid

User_Name

OleDbLiteral

Value

IDataParameter, OleDbParameter, SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlParameter, SqlSingle, SqlString

value_ _

AcceptRejectRule, CommandBehavior, CommandType, ConnectionState, DataRowAction, DataRowState, DataRowVersion, DataViewRowState, DbType, IsolationLevel, KeyRestrictionBehavior, MappingType, MissingMappingAction, MissingSchemaAction, OleDbLiteral, OleDbType, ParameterDirection, PropertyAttributes, Rule, SchemaType, SqlCompareOptions, SqlDbType, StatementType, UpdateRowSource, UpdateStatus, XmlReadMode, XmlWriteMode

Values

FillErrorEventArgs

VarBinary

OleDbType, SqlDbType

VarChar

OleDbType, SqlDbType

Variant

OleDbType, SqlDbType

VarNumeric

DbType, OleDbType

VarWChar

OleDbType

VersionNotFoundException

System.Data

View_Column_Usage

OleDbSchemaGuid

View_Name

OleDbLiteral

View_Table_Usage

OleDbSchemaGuid

Views

OleDbSchemaGuid

WChar

OleDbType

WorkstationId

SqlConnection

Write

PropertyAttributes

WriteSchema

XmlWriteMode

WriteXml( )

DataSet

WriteXmlSchema( )

DataSet

XmlReadMode

System.Data

XmlWriteMode

System.Data

Xor( )

SqlBoolean, SqlByte, SqlInt16, SqlInt32, SqlInt64

Zero

SqlBoolean, SqlByte, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle

Related

Категории