- Shopping Bag ( 0 items )
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.
|Ch. 1||Oracle architecture and connectivity||1|
|Ch. 2||Retrieving data||49|
|Ch. 3||Manipulating data||119|
|Ch. 4||Oracle exception and error classes||179|
|Ch. 5||Using PL/SQL from .NET||203|
|Ch. 6||Working with large objects||247|
|Ch. 7||Advanced connections and authentication||285|
|Ch. 8||Performing common tasks with Oracle features||331|
|Ch. 9||SQL tracing||365|
|App||Obtaining and installing the Oracle software||393|
Posted November 16, 2004
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.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.