ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET - Brossura

Pulakhandam, Jagadish Chatarji; Paruchuri, Sunitha

Brossura

ISBN 10: 1847191967 ISBN 13: 9781847191960

Casa editrice: Packt Publishing, 2007

Riassunto

This is a practical guide to working with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using Oracle Data Provider for .NET and Oracle Developer Tools. ODP.NET optimizes Oracle database access from a .NET environment, allowing developers to leverage advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security, using VB.NET, C#, or any .NET language. With many hands-on examples the book provides the in-depth information to use ODP.NET and Oracle Developer Tools from Visual Studio 2005. After introducing ODP.NET, it covers using SQL, PL/SQL, LOBs, and XML DB through ODP.NET; developing Web Applications, Web Services, and Mobile Applications; and finally Oracle Developer Tools for VS.NET. All the code examples use Visual Basic.NET 2005. This book is for professional .NET developers with a minimum knowledge of Oracle SQL and PL/SQL who need to work with and take full advantage of the Oracle Database 10g using Visual Studio 2005.

Su questo libro

L'autore

Jagadish Chatarji Pulakhandam currently works as a .NET Architect and is responsible for analyzing/designing enterprise-level .NET applications. He has worked with Oracle since database version 7.1 and has been in the IT field for about 12 years. Apart from Oracle and .NET, he has a good knowledge of developing corporate software and web applications, designing and implementing databases, designing and implementing data warehouses, and working with enterprise reporting software. During his free time, he contributes technical articles to OTN (Oracle Technology Network) and to the world of developer communities.

Contenuti

Chapter 1 introduces the concept of Oracle Database Extensions for .NET and provides information about Oracle Developer tools for Visual Studio.

Chapter 2 introduces the Provider Independent Model in ADO.NET 2.0, and shows how to connect to Oracle databases from .NET, working with .NET data providers, connection pooling, system privileged connection, and single sign-on etc.

Chapter 3 shows you several methods to retrieve data from an Oracle database. You will work with the core ODP.NET classes like OracleCommand, OracleDataReader, OracleDataAdapter, OracleParameter and ADO.NET classes like Dataset, DataTable, and DataRow etc.

Chapter 4 is about inserting, updating, and deleting data in the database. You will also learn about statement caching, array binding, working with offline data, implementing transactions, and handling errors and exceptions encountered during database work.

Chapter 5 deals with working with PL/SQL blocks, PL/SQL stored procedures, and functions. It also teaches you how to execute routines in PL/SQL packages, how to pass and receive arrays from the Oracle database, and working with REF CURSOR using ODP.NET.

Chapter 6 is completely dedicated to dealing with Large objects in Oracle. This chapter illustrates concepts, configurations, and programming for BFILE, BLOB, and CLOB (or NCLOB) in conjunction with ODP.NET.

Chapter 7 gives details about Oracle XML DB, an add-on feature of Oracle database. It provides information about generating XML from existing rows in tables, manipulating rows in a table using XML, and working with native XML in the Oracle database.

Chapter 8 deals with real-time application development scenarios like Oracle database change notifications, Asynchronous Application development, Web Application development using ASP.NET 2.0, Web Reporting (including grouping, sub-totals, charts etc.), Object-Oriented Development with ODP.NET and ASP.NET, XML Web Services development using ODP.NET and Smart Device Application development (for clients like the Pocket PC etc.).

Chapter 9 introduces you to Oracle Developer Tools for Visual Studio 2005. It teaches you to connect to Oracle from the Visual Studio 2005 environment, retrieve Oracle information from Visual Studio, and work with database objects from Visual Studio. It also provides information about how to create and debug PL/SQL stored procedures and .NET CLR Stored Procedures in Oracle.

Dettagli dell'edizione

• Editore: Packt Publishing
• Data di pubblicazione: 2007
• Lingua: Inglese
• ISBN 10: 1847191967
• ISBN 13: 9781847191960
• Rilegatura: Copertina flessibile
• Numero di pagine: 313
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile