1 / 32

Oracle and .NET Integration: Tools and Providers Overview

Explore Oracle's Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and Oracle Data Provider for .NET. Learn about features, demos, and seamless integration with Microsoft's .NET environment.

lesiae
Download Presentation

Oracle and .NET Integration: Tools and Providers Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Getting Started with Oracle and .NET Alex Keh Principal Product Manager Server Technologies

  2. Agenda • Oracle and .NET – Getting Started • Oracle Developer Tools for Visual Studio • Demo • Oracle Providers for ASP.NET • Demo • Oracle Data Provider for .NET • Demo • Next Steps

  3. <Insert Picture Here> Oracle and .NET – Getting Started

  4. Oracle and Microsoft Relationship

  5. .NET Development Environment Support Oracle Developer Tools for Visual Studio Oracle Data Provider for .NET ApplicationDevelopment Deploy .NET Application Visual Studio Environment Web or Client/ServerApplication Deploy Database Development Oracle Providers for ASP.NET Oracle Database Extensions for .NET

  6. .NET Components for Oracle Database • Free • Stay in Visual Studio for project lifecycle • Supports Visual Studio 2003, 2005, and 2008 • Complete access to .NET functionality • Supports .NET Framework 1.0 and higher • Supports 32-bit, x64, and 64-bit Itanium platforms • ASP.NET services and controls via ASP.NET providers • Easy to use and intuitive • Native access to Oracle Database • Utilize advanced Oracle Database features • E.g. RAC, performance, security, data types, XML, etc.

  7. Develop on Windows, Database on any Platform Windows ODT and ODP.NET Linux Visual Studio Environment Unix Windows Other Oracle 11g,10g, 9i, or 8i

  8. <Insert Picture Here> Oracle Developer Tools for Visual Studio (ODT)

  9. Feature Overview • Fully integrated with Visual Studio 2008/2005 • Server Explorer • Data Sources Window • Dataset Designer • TableAdapter Configuration Wizard • Query Builder/Query Designer • More • Fully integrated with Visual Studio .NET 2003 • Oracle Explorer • Automatic code generation – Winform and ASP.NET • Makes ASP.NET web application development very easy

  10. D E M O N S T R A T I O N Visual Studio Integration

  11. Feature Overview • Oracle Wizards and Designers • Table/View Designer • Stored Procedure/Function/package Wizards • Grant/Revoke Privileges Wizard • UDT Designers • UDT Custom Class Code Generation Wizard • Table/View Migration Wizard • Oracle Data Window • Oracle Database Project • Edit and Run SQL scripts • SQL*Plus is built in • Source control integration • Integrated PL/SQL Editor and Debugger

  12. Feature Overview • Oracle Query Window • Ad Hoc SQL • Explain Plan • .NET Stored Procedure Deployment • Integrated help system – SQL, PL/SQL keywords

  13. <Insert Picture Here> Oracle Providers for ASP.NET

  14. Oracle Providers for ASP.NET • Pre-built services to store website state into Oracle • Services for commonly used website information • E.g. user info, user roles, shopping cart • Easy to learn • Based on standard ASP.NET provider APIs and schema • Inherits from .NET Framework 2.0 base classes • Compatible with ASP.NET service classes • No unique extensions in Oracle ASP.NET providers

  15. Oracle Providers for ASP.NET • Seamless integration with ASP.NET services and controls • Reference to specific providers unnecessary • High level of abstraction: services and controls based programming • Easy to switch from SQL Server to Oracle quickly • Configuration file determines which data source to use • Easy to setup and manage • Can be managed by IIS or Website Admin Tool

  16. Oracle Providers for ASP.NET IIS ASP.NET Controls ASP.NET Services Oracle Providers for ASP.NET ODP.NET

  17. Oracle Providers for ASP.NET • Oracle Providers for ASP.NET Components • Cache Dependency Provider • Membership Provider • Profile Provider • Role Provider • Site Map Provider • Session State Provider • Web Parts Personalization Provider • Web Events Provider • Administrators can pick and choose which providers to use

  18. D E M O N S T R A T I O N ASP.NET Providers

  19. <Insert Picture Here> Oracle Data Provider for .NET (ODP.NET)

  20. ODP.NET Object Model Disconnected Layer Connected Layer (ODP.NET) Data Layer Oracle DataAdapter Oracle CommandBuilder DataSet Oracle DataReader Oracle Command Oracle Transaction Oracle Connection Oracle

  21. D E M O N S T R A T I O N ODP.NET

  22. ODP.NET Features • Connection pooling • Min, Max, Timeout, Lifetime, Increment, Decrement • RAC • Automatic load balancing • Automatic connection cleanup • Full PL/SQL support • Packaged, non-packaged, anonymous, autonomous • Batch SQL available with anonymous PL/SQL

  23. ODP.NET Features • Native Oracle data types • REF Cursors, LOBs, XMLType, TimeStamp, etc. • Safe type mapping to .NET data types • Parameters • PL/SQL Associative Array data type • LOBs • Ability to pre-fetch or defer LOB retrieval

  24. ODP.NET Features • XML • XMLType data type • Query and Save XML from the DB • Both relational and object-relational • Interoperate with MS XML APIs (e.g. XmlReader) • Supports XSLT, XPATH, and XML Schema • Transactions • Enterprise Services via Oracle Services for MTS • Local (Implicit and Explicit) • System.Transactions • Savepoints

  25. Top Unique ODP.NET Features Features Oracle SQL 2008 Better Result Set Tuning Options Yes No Configurable LOB Retrieval Yes No Array Parameters Yes No Proxy Auth. and Secure App Context Yes No Real Application Clusters Support Yes No Self-Updating Cache Yes No

  26. <Insert Picture Here> Next Steps

  27. Oracle Technology Network – .NET Developer Center • http://otn.oracle.com/dotnet • Free downloads of Visual Studio tools, ODP.NET, ASP.NET providers, and Oracle Database XE • White papers • Sample code • Demo videos • Help forums • “How to” step by step tutorials • Latest Oracle on .NET news

  28. More Information • .NET Technology Center • http://otn.oracle.com/dotnet • Windows Server Center • http://otn.oracle.com/windows • For more questions • alex.keh@oracle.com

  29. The preceding is intended to outline our general product direction. It is intended for informational purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

More Related