???? ? ???????????? ?? ODP.NET ? Oracle 9i

1
???? ? ???????????? ?? ODP.NET ? Oracle 9i

• ?????? ???? ????????
• ??????????? ????

2
????? ? Oracle Data Provider for .NET (ODP.NET)
ASP.NET
VB.NET
C
C.NET
OLE DB .NET
ODBC .NET
ODP .NET
ORACLE OLE DB
ORACLE ODBC
ORACLE DB
3
ODP.NET ??????? ?????
Connected Layer (ODP.NET)
Disconnected Layer
Data Layer
Oracle DataAdapter
OracleCommand Builder
DataSet
Oracle Command
Oracle DataReader
Business Object
Oracle Transaction
Oracle Connection
Oracle
4
??????? ?????????????? ?? ODP.NET

• Full PL/SQL support
• Packaged, non-packaged, anonymous, autonomous
• Batch SQL available with anonymous PL/SQL
• Native Oracle data types
• LOBs, REF Cursor, Date, TimeStamps, Long, Raw,
  etc.
• Connection pooling
• Min, Max, Timeout, Lifetime, Increment, Decrement

• Transactions
• Enterprise Services via Oracle Services for MTS
• Savepoints
• Globalization
• Full Unicode support
• Client settings are used to display Oracle data
  in locale-specific manner
• Transparent application failover
• Notification callbacks

5
??????? ?????????????? ?? ODP.NET - ???????????

• Parameters
• PL/SQL Associative Array data type
• Parameter Array binding
• Named and positional parameters

• XML DB
• XML repository
• Native XMLType
• XML stored as CLOB or object
• Schema and non-schema-based
• XML Views

6
O?????? ?????????? ?? ODP.NET

• Multiple Active Result Sets (MARS)
• Native XML Data Type
• Result Set Retrieval Tuning Options
• Configurable LOB Retrieval
• Array Parameters

7
Oracle Helper

• ExecuteDataSet 6 overloads
• ExecuteFunction 9 overloads
• ExecuteReader 6 overloads
• ExecuteScalar 6 overloads
• ExecuteNonQuery 6 overloads
• ExecuteXMLReader 6 overloads

8
???????? ? ODP.NET

• ?????? DeriveParameters ?? PL/SQL ?????????
• PLSQL Associative Arrays ??? ???????? ?? ???????
• ?? ???????? varray ???? ?????????
• ExecuteScalar ?? ?????? ? PL/SQL Functions ???
  RefCursor
• ??????? ? ???????? ?????

9
????? ???????? ??? ???????????? ?? ODP.NET

• ??????????? connection pooling
• ????????????? ODP.NET ????????, ?????? ??????????
  ??????
• ????????????? roundtrips
• ???????????? ?? single statement (SELECT)
• ??????????? FetchSize (OracleDataReader) ?
  RowSize (OracleCommand)
• ??????????? DataAdapter.Requery
• ???????? roundtrips ??? ???????? ?????????? ??
  ???????

10
????? ???????? ??? ???????????? ?? ODP.NET -
???????????

• ???????????? ?? multi-statement
• ??????????? ????? ? ???????? ????????
• ??????????? anonymous PL/SQL
• ??????????? ??????? ???????
• ??????????? ???? ??????? ????? ?????
• ??????????? parameter array binding
• ??????????? PL/SQL associative arrays

11
????? ???????? ??? ???????????? ?? ODP.NET -
???????????

• ??????????? OracleRefCursor class
• ??????? ?? ????????, ?????? ? ??????????
• ??????????? Oracle LOB classes (DML)
• ???? ???????????? ?? ????????? ??????? ?? ??
  ????????? ??? ???????? LOBs
• ??????? ??????? ? LOB ?? ???? ????
• ??????????? InitialLOBFetchSize, ?? ??
  ???????????? ??????????? ?? LOB
• ??????? ?? ????????? LOB ??-??????
• ?? ????????????, ODP.NET ???????? LOB locators

12
????? ???????? ??? ???????????? ?? ODP.NET -
???????????

• ??????????? PL/SQL ??????
• ???????????? ???????????? ?? .NET
• ?????? ? ????????, ??????????? multiple
  RefCursors
• ??????????? ???????? error handling
  (Exceptions.ApplicationBlock)

13
????? .NET Providers ?? Oracle

• Microsoft .NET Data Provider for Oracle
• Corelab OraDirect .NET Data Provider
• DataDirect Connect for .NET

14
??? .NET Provider ?? ??????????

• ?? ????? ?????????? ? ????? ?????????? MS Data
  Provider for Oracle
• ?? ????? ?????????? ?? ????????????? ?? Oracle DB
  ? ?????? ???????????????? ODP.NET
• http//msdn.microsoft.com/data/default.aspx?pull/
  library/en-us/dnadonet/html/ODPvsMSDP.asp