Product Description
A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005
- Application development with ODP.NET
- Dealing with XML DB using ODP.NET
- Oracle Developer Tools for Visual Studio .NET
In Detail
The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment and allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. It can be used from any .NET language, including C# and VB.NET.
This book is a practical guide that will give you the in-depth information you need to work with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using the Oracle Developer Tools and ODP.NET.
After introducing ODP.NET, we move on to dealing with SQL, PL/SQL, and XML DB using ODP.NET. Next we look at application development with ODP.NET: Web Applications, Web Services, and Mobile Applications. The last chapter covers Oracle Developer Tools for Visual Studio .NET. All the code examples are in Visual Basic.NET 2005.
What you will learn from this book?
- Different ways of Connecting to Oracle databases using ODP.NET (including Single Sign-on)
- Executing SQL queries and commands using ODP.NET
- Working with PL/SQL blocks, stored procedures, stored functions, packages, and REF CURSORs
- Working with Large Objects like BFILE, BLOB, and CLOB using ODP.NET
- Working with XML and XMLDB
- Application development using ODP.NET
- Database change notifications and Asynchronous programming
- Developing Web Applications using ASP.NET and ODP.NET
- Reporting (including charts) using ASP.NET and ODP.NET
- Developing XML Web Services using ODP.NET
- Developing applications for Smart Client devices (like Pocket PC)
- Using Oracle Developer Tools for Visual Studio 2005
- Creating and debugging PL/SQL stored procedures from Visual Studio 2005
- Creating and Deploying .NET CLR stored procedures in Oracle database using Visual Studio 2005
Approach
This book uses many hands-on examples to show you how to use ODP.NET and Oracle Developer Tools from within Visual Studio 2005 to access Oracle Database 10g.
Who this book is written for?
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.
About the Author
Jagadish Chatarji Pulakhandam
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.
Sunitha Paruchuri
Sunitha Paruchuri has been programming with Microsoft tools and Oracle since 1997. She has developed numerous desktop, web, mobile and distributed applications using Microsoft.NET and has good experience with other Microsoft products like Microsoft SQL Server, Microsoft Sharepoint Portal Server, etc.