Pro .NET Oracle Programming

Description:

This book never loses sight of its instructional mission: to effectively utilize the Oracle database from the .NET environment. Though Visual Studio and Oracle form a popular and powerful duo, there is a noticeable lack of written material in this area. The result: projects that often turn out with less-than-optimal solutions, due to lack of “synergy” between the application developer and the database.

The primary code in the book will be C#, but the code download will also be available in VB.NET (with an appendix describing terms of use). Hence, this book provides a one-stop reference for any VS.NET programmer using Oracle. The author maintains solid focus on databases—emphasizing the use of specific features from a Visual Studio application. The text also includes crucial aspects of developing Oracle-based applications. Assumably, you are already comfortable with the VS.NET environment, and with the aid of this book, you will come to work effectively with the Oracle database as well.

 

Table of Contents:

Chapter 1 – Oracle Architecture and Connectivity
Chapter 2 – Retrieving Data
Chapter 3 – Manipulating Data
Chapter 4 – Oracle Exception and Error Classes
Chapter 5 – Using PL/SQL from .NET
Chapter 6 – Working with Large Objects
Chapter 7 – Advanced Connections and Authentication
Chapter 8 – Performing Common Tasks with Oracle Features
Chapter 9 – SQL Tracing
Appendix – Obtaining and Installing the Oracle Software

描述：
這本書始終保持著教學的使命：有效地在.NET環境中利用Oracle數據庫。儘管Visual Studio和Oracle組成了一個受歡迎且強大的組合，但在這個領域中卻明顯缺乏相應的文獻資料。結果就是，由於應用程序開發人員和數據庫之間缺乏“協同作用”，導致項目通常以不太理想的解決方案結束。
本書的主要代碼將使用C#，但代碼下載也將提供VB.NET版本（附錄中描述使用條款）。因此，對於使用Oracle的任何VS.NET程序員來說，本書提供了一站式參考。作者專注於數據庫，強調從Visual Studio應用程序中使用特定功能。本文還包括開發基於Oracle的應用程序的關鍵方面。假設您已經熟悉VS.NET環境，並且在本書的幫助下，您將能夠有效地與Oracle數據庫一起工作。

目錄：
第1章 - Oracle架構和連接
第2章 - 檢索數據
第3章 - 操作數據
第4章 - Oracle異常和錯誤類
第5章 - 從.NET使用PL/SQL
第6章 - 使用大對象
第7章 - 高級連接和身份驗證
第8章 - 使用Oracle功能執行常見任務
第9章 - SQL追踪
附錄 - 獲取和安裝Oracle軟件