Pro .NET Oracle Programming / Edition 1

Pro .NET Oracle Programming / Edition 1

4.0 1
by Mark A. Williams
     
 

ISBN-10: 1590594258

ISBN-13: 9781590594254

Pub. Date: 11/04/2004

Publisher: Apress

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

…  See more details below

Overview

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 Visual Basic .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.

Read More

Product Details

ISBN-13:
9781590594254
Publisher:
Apress
Publication date:
11/04/2004
Series:
Pro Series: From Professional to Expert Ser.
Edition description:
2005
Pages:
472
Product dimensions:
7.00(w) x 9.25(h) x 0.96(d)

Table of Contents

Ch. 1Oracle architecture and connectivity1
Ch. 2Retrieving data49
Ch. 3Manipulating data119
Ch. 4Oracle exception and error classes179
Ch. 5Using PL/SQL from .NET203
Ch. 6Working with large objects247
Ch. 7Advanced connections and authentication285
Ch. 8Performing common tasks with Oracle features331
Ch. 9SQL tracing365
AppObtaining and installing the Oracle software393

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Pro .NET Oracle Programming 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
Is it just me, that does not immediately see an overlap between Oracle and .NET? Historically, Oracle databases have tended to be installed on unix workstations (especially Solaris). And nowadays, on linux as well. But Williams points out that given the widespread presence of .NET, and that Oracle is the dominant database, then we should indeed have an important market intersection of the two. Other books have described using C#/.NET with Microsoft's SQL Server. Not surprising, because Microsoft supplies all these parts. But this book is perhaps overdue, in filling a gap in the documentation of .NET and Oracle. The exposition herre is logical, and not unlike some of those other books. (Cf. 'SQL Server Query Performance Tuning Distilled' by Dam.) Except of course that you are shown how to optimise table design and complex queries for Oracle. Plus, Williams describes this for Oracle 10g Enterprise Edition - Oracle's latest flagship version. The book uses C# as the programming language, since it seems to be the best supported 'native' language of .NET. In the development environment, he gives some simple GUIs to access the database. Done often in VB.NET or Microsoft Window Forms. Realistically, any GUIs for your work will be more intricate. But you get enough GUI framework code to get you started along these lines.