| Description |
1 online resource (v, 313 pages) : illustrations |
| Note |
Includes index. |
| Contents |
Cover -- TOC36;Table of Contents -- Preface -- CH36;Chapter 158; Introduction to ODP46;NET -- Introduction to ODP46;NET -- Why Use ODP46;NET63; -- Oracle Database Access from 46;NET Applications -- What Do We Require to Work with ODP46;NET63; -- Introduction to Oracle Database Extensions for 46;NET -- Oracle Database Extensions for 46;NET -- Introduction to Oracle Developer Tools for Visual Studio -- Summary -- CH36;Chapter 258; Connecting to Oracle -- Provider45;Independent Model in ADO46;NET 246;0 -- Listing All 46;NET Data Providers Installed -- Enumerating all Oracle Data Sources Available -- Connecting to Oracle Databases from 46;NET -- Connecting Using 46;NET Data Provider Factory Classes -- Connecting Using 46;NET Data Provider for OLEDB -- Connecting Using 46;NET Data Provider for ODBC -- Connecting using Microsoft39;s 46;NET Data Provider for Oracle -- Connecting Using Oracle Data Provider for 46;NET 40;ODP46;NET41; -- Connecting with Connection Pooling -- Connecting with System45;Level Privileges or DBA Privileges -- Dynamic Connecting String Using OracleConnectionStringBuilder and app46;config -- Embedding a 34;tnsnames46;ora34; Entry45;like Connection String -- Connecting to a Default Oracle Database -- Connecting Using Windows Authentication 40;Single Sign45;On41; -- Summary -- CH36;Chapter 358; Retrieving Data from Oracle Using ODP46;NET -- Fundamental ODP46;NET Classes to Retrieve Data -- Retrieving Data Using OracleDataReader -- Retrieving a Single Row of Information -- Using 34;Using34; for Simplicity -- Retrieving Multiple Rows on to the Grid -- Pulling Information Using Table Name -- Retrieving Typed Data -- Working with Data Tables and Data Sets -- Retrieving Multiple Rows into a DataTable Using OracleDataAdapter -- Filling a DataTable Using OracleDataReader -- Retrieving a Single Row of Information Using OracleDataAdapter -- Working with DataTableReader -- Populating a Dataset with a Single Data Table -- Populating a Dataset with Multiple Data Tables -- Presenting Master45;Detail Information Using a Dataset -- More About the OracleCommand Object -- Retrieving a Single Value from the Database -- Techniques to Improve Performance while Retrieving Data -- Summary -- CH36;Chapter 458; Manipulating Data in Oracle Using ODP46;NET -- Executing DML or DDL Statements Using OracleCommand -- Using INSERT with OracleCommand -- Using UPDATE with OracleCommand -- Using DELETE with OracleCommand -- Multiple Inserts Using Statement Caching -- Multiple Inserts Using Array Binding -- Creating an Oracle Table Dynamically Using ODP46;NET -- Updating Offline Data to the Database Using OracleDataAdapter -- Working with OracleCommandBuilder and OracleDataAdapter -- Working with Transactions Using ODP46;NET -- Handling Oracle Errors and Exceptions -- Displaying a Single or First Error -- Displaying Multiple Errors -- Summary -- CH36;Chapter 558; Programming ODP46;NET with PL47;SQL -- Working with Anonymous PL47;SQL Blocks -- Executing Anonymous PL47;SQL Blocks -- Passing Information to Anonymous PL47;SQL Blocks -- Retrieving Information from Anonymous Blocks -- Working with PL47;SQL Stored Procedures and Functions -- Executing a PL47;SQL Stored Procedure -- Passing Parameter Values to a PL47;SQL Stored Procedure -- Using an. |
| Summary |
This is a practical guide for developers working with the Oracle Data Provider for .NET (ODP.NET) using VB.NET. From introducing ODP.NET and programming with ODP.NET to application development using ODP.NET and on to discussing Oracle Developer Tools for Visual Studio 2005, this book covers the important aspects of ODP.NET. The book is written for professional .NET developers who need to work with and take full advantage of Oracle Database 10g using Visual Studio 2005. Developers are expected to be familiar with Visual Basic.NET 2005 and have minimum knowledge of Oracle SQL and PL/SQL. |
| Note |
Print version record. |
| Subject |
Oracle (Computer file)
|
|
Microsoft Visual studio.
|
|
Microsoft Visual studio. (OCoLC)fst01389599
|
|
Oracle (Computer file) (OCoLC)fst01363816
|
|
Relational databases.
|
|
Parallel processing (Electronic computers)
|
|
Electronic books.
|
|
COMPUTERS -- Data Processing.
|
|
Parallel processing (Electronic computers) (OCoLC)fst01052928
|
|
Relational databases. (OCoLC)fst01093575
|
| Added Author |
Paruchuri, Sunitha.
|
| Added Title |
Oracle database 10g development with Visual Studio 2005 and the Oracle Data Provider for .NET |
| Other Form: |
Print version: Pulakhandam, Jagadish. ODP.NET developers guide. Birmingham, UK : Packt Pub., ©2007 9781847191960 1847191967 (OCoLC)213867606 |
| ISBN |
9781847191977 (electronic bk.) |
|
1847191975 (electronic bk.) |
|
