ODP.NET Developer’s Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET
eBook:
$29.99
Formats:
Formats:
$13.50
save 55%!
Print book:
$49.99
$44.99
save 10%!
Print + eBook bundle:
$79.98
Includes free access to the book on PacktLib
Includes free access to the book on PacktLib
$49.49
save 38%!
Free Shipping! UK, US, Europe and selected countries in Asia.
| This book can also be purchased from: |  |
- Application development with ODP.NET
- Dealing with XML DB using ODP.NET
- Oracle Developer Tools for Visual Studio .NET
- Read: Chapter 3 [PDF 1 MB] | Table of Contents
- Available to download immediately as an eBook
Book Details
Language : EnglishPaperback : 328 pages [ 235mm x 191mm ]
Release Date : June 2007
ISBN : 1847191967
ISBN 13 : 978-1-847191-96-0
Author(s) : Jagadish Chatarji Pulakhandam, Sunitha Paruchuri
Topics and Technologies : All Books, Microsoft Development , Oracle Database, Enterprise, Microsoft, .NET, Oracle
Table of Contents
Preface
Chapter 1: Introduction to ODP.NET
Chapter 2: Connecting to Oracle
Chapter 3: Retrieving Data from Oracle Using ODP.NET
Chapter 4: Manipulating Data in Oracle Using ODP.NET
Chapter 5: Programming ODP.NET with PL/SQL
Chapter 6: Dealing with Large Objects (LOBs)
Chapter 7: XML and XML DB Development with ODP.NET
Chapter 8: Application Development Using ODP.NET
Chapter 9: Introduction to Oracle Developer Tools for Visual Studio 2005
Index
Jagadish Chatarji Pulakhandam
Sunitha Paruchuri
Sorry, we don't have any reviews for this title yet.
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
Find your book in our support section to find errata and to download code samples.
- 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
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.
Annual subscription:
$220.00 per annum
Monthly subscription:
$21.99 per month
|
||||||||||||||||
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.
Read the full Table of Contents for ODP.NET Developer’s Guide
Chapter-by-Chapter
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.
This is a practical guide for developers working with the Oracle Data Provider for .NET (ODP.NET) using VB.NET. From introducing ODP.NET and programming with ODP.NET to application development using ODP.NET and on to discussing Oracle Developer Tools for Visual Studio 2005, this book covers the most important aspects of ODP.NET.
Read: Chapter 3: Retrieving Data From Oracle Using ODP Dot NET [889 KB] | Table of Contents
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.
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.
If this isn't the right book for you, take a look at some of our other offerings below.
-
- Learn how Dynamics NAV ERP suite is set up and customized for various industries
- Integrate numerous parts of a company's operations including financial reporting, sales, order management, inventory, and forecasting
- Develop complete applications and not just skeleton systems
- Covers the design and implementation of two new add-on services: The Squash application and the Storage & Logistics application
- Also usable for previous versions such as 3.x, 4.0, and 5.0
- Easy-to-read style, packed with hard-won practical advice
- Real-world examples with step-by-step explanations
-
- Technical foundations of the Documentum platform
- Over 200 practice questions and three practice tests
- Up-to-date information on version 6.5 SP2 including presets, aspects, new Webtop interface, lightweight types, Composer, and DFS
- Over 200 illustrations and many more examples from a real-life business scenario
-
- Easy-to-follow introduction to OGRE 3D
- Create exciting 3D applications using OGRE 3D
- Create your own scenes and monsters, play with the lights and shadows, and learn to use plugins
- Get challenged to be creative and make fun and addictive games on your own
- A hands-on do-it-yourself approach with over 100 examples
-
- Written in an accessible readable style, this practical book will help you to successfully master user authentication, authorization, and user management in Siebel CRM
- Set up the organization and position hierarchy as well as create user accounts in step-by-step examples
- Instructions valid for versions 8.0, 8.1, and 8.2
-
- Optimize time-consuming tasks efficiently using three Oracle database utilities
- Get to grips with user session management issues
- Boost database defences with Oracle Wallet Manager and Security
- A focused handbook with practical content and real-life scenarios
-
- The first book on the newly released Inkscape version 0.48, with an exclusive focus on web design
- Incorporate eye-catching designs, charts, and other visual elements to spice up your web pages
- Learn how to create your own Inkscape templates in addition to using the built-in ones
- Written in a simple illustrative manner, which will appeal to web designers and experienced Inkscape users alike
-
- Focusses on 3 key areas of development with Seam – testing, persistence and security
- Test your site to ensure efficiency
- Learn how to develop persistent applications
- Secure your web application with user authentication and OpenID.
-
- Covers the full spectrum of features offered by the NetBeans IDE
- Discover ready-to-implement solutions for developing desktop and web applications
- Learn how to deploy, debug, and test your software using NetBeans IDE
- Another title in Packt's Cookbook series giving clear, real-world solutions to common practical problems
-
New jQuery Book Released 
jQuery UI Themes Beginner's Guide is a step-by-step tutorial aimed at beginners to jQuery UI Themes.There is ready-for-use sample code explained with essential screenshots for better and quicker understanding.
Learn More - Quickly look up features of the jQuery library
- Step through each function, method, and selector expression in the jQuery library with an easy-to-follow approach
- Understand the anatomy of a jQuery script
- Write your own plug-ins using jQuery's powerful plug-in architecture
- Written by the creators of learningquery.com
- Check out the new Learning jQuery Third Edition here
-
- An introduction to jQuery that requires minimal programming experience
- Detailed solutions to specific client-side problems
- For web designers to create interactive elements for their designs
- For developers to create the best user interface for their web applications
- Packed with great examples, code, and clear explanations
- Revised and updated version of the first book to help you learn jQuery
