1 / 41

Getting Started with Oracle and .NET

Getting Started with Oracle and .NET. Christian Shay Principal Product Manager, .NET and Windows Oracle USA. Agenda. Oracle and .NET Intro Oracle Developer Tools for Visual Studio Demo Oracle Data Provider for .NET Demo Oracle Providers for ASP.NET Demo .NET Stored Procedures

patriciae
Download Presentation

Getting Started with Oracle and .NET

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 Christian Shay Principal Product Manager, .NET and Windows Oracle USA

  2. Agenda • Oracle and .NET Intro • Oracle Developer Tools for Visual Studio • Demo • Oracle Data Provider for .NET • Demo • Oracle Providers for ASP.NET • Demo • .NET Stored Procedures • Next Steps

  3. <Insert Picture Here> Oracle and Microsoft – Collaborating Today and in the Future

  4. Oracle’s Commitment to .NET Visual Studio .NET Plug-ins .NET Stored Procedures ODAC 2006 64-bit ODP.NET ODP.NET ODP.NET ODAC 11g 2002 2003 Q2 2005 Q3 2005 Q3 2006 Q1 2007 2007, 2008 .NET 1.0 .NET 1.1 VS 2003 .NET 2.0 & VS 2005 .NET 3.0 Windows Vista, Win2k8

  5. Relationship with Microsoft

  6. <Insert Picture Here> Dewey Forrester Director, Platform Evangelism Microsoft “We do not let the areas of competition get in the way of the areas in which we can bring a great combined offering to market.”

  7. .NET Customers “ “ “ “ “ We’re taking the best of both worlds – .NET and Oracle – to give us the best platform possible. ODP.NET is vital to the success of our next-generation application Since we use a Microsoft .NET middle tier, Oracle Data Provider for .NET provided the high throughput, high performance, and bulletproof connectivity to the database Integrating ODP.NET was easy and straightforward.. we were able to take advantage of… the power and high availability of  the grid ” ” ” Bill Evjen, Technical Architect Jim Lombardi, Principal Database Engineer Jason Lin, Assistant Vice President, Application Integration and Architecture

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

  9. Oracle Technology Network – .NET Developer Center • http://otn.oracle.com/dotnet • Free downloads of Visual Studio tools, ODP.NET and Oracle Database XE • Whitepapers • Sample Code • Demo Videos • Help Forums • “How to” step by step tutorials • Latest Oracle on .NET News

  10. .NET Development Environment Support Oracle Providers for ASP.NET Oracle Developer Tools for VS IIS ASP.NET MTS/ COM+ C++, C#, VB .NET Application Develop Deploy Visual Studio Environment Application IIS Deploy Database Development Oracle Data Provider for .NET Oracle Database Extensions for .NET

  11. Oracle Developer Tools for Visual Studio • Free • “Add-in” for Visual Studio 2003,2005, and 2008 • Easy to use and intuitive • Powerful features that enhance productivity • Fully integrated with Visual Studio • Easy ASP.NET web application development • Designers and wizards • Automatic .NET code generation • PL/SQL editor/debugger • Source control integration • Much more • Stay in Visual Studio for project lifecycle

  12. Oracle Data Provider for .NET • Free • Easy to learn, even if new to Oracle • Compliant with ADO.NET 1.x and ADO.NET 2.0 • No learning curve • Supports .NET Framework 1.0 and higher, including 3.5 • 32-bit, x64, and 64-bit Itanium .NET Framework • Complete access to .NET functionality • Native access to Oracle Database • Utilize advanced Oracle Database features • RAC, performance, security, data types, XML, etc.

  13. Oracle Providers for ASP.NET • Free • Pre-built services to store website state in Oracle • E.g. store web user, shopping cart, profile information • Based on ASP.NET standards • Management console via IIS or Website Admin Tool

  14. 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

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

  16. Feature Overview • Fully integrated with Visual Studio 2005 and 2008 • 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

  17. Feature Overview • Oracle Wizards and Designers • Table/View Designer • Stored Procedure/Function/package Wizards • Grant/Revoke Privileges Wizard • UDT Custom Class Code Generation Wizard • More • 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

  18. Feature Overview • Oracle Query Window • Ad Hoc SQL • Explain Plan • Integrated help system – SQL, PL/SQL keywords

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

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

  21. 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

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

  23. ODP.NET Features • Full PL/SQL support • Packaged, non-packaged, anonymous, autonomous • Batch SQL available with anonymous PL/SQL • Native Oracle data types • REF Cursors, LOBs, XMLType, TimeStamp, etc. • Safe type mapping to .NET data types • Connection pooling • Min, Max, Timeout, Lifetime, Increment, Decrement

  24. ODP.NET Features • Transactions • Enterprise Services via Oracle Services for MTS • Local (Implicit and Explicit) • System.Transactions • Savepoints • Parameters • PL/SQL Associative Array data type • LOBs • Ability to pre-fetch or defer LOB retrieval

  25. 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 • RAC • Automatic load balancing • Automatic connection cleanup

  26. Top Unique ODP.NET Features Features Oracle SQL 2005 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 A True Self-Updating Cache Yes No

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

  28. 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

  29. 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

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

  31. 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

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

  33. <Insert Picture Here> .NET Stored Procedures

  34. Oracle Database Extensions for .NET • Database option • DB server on Windows only • Both 32-bit and 64-bit supported • Oracle Database 10g Release 2 or later

  35. Oracle Database Extensions for .NET Oracle Developer Tools for Visual Studio Oracle Developer Tools for VS.NET Visual Studio Environment Client Application Develop Invoke C#,VB.NET,C++ Server Project (Use ODP.NET if required) Stored Procedure, SQL .. Invoke Build Oracle Database Extensions for .NET Assembly foo.dll (proc sp) Oracle Database Extensions for .NET Deploy Stored Proc

  36. <Insert Picture Here> Next Steps

  37. More Information .NET Technology Center http://otn.oracle.com/dotnet .NET Blog http://cshay.blogspot.com/ For more questions christian.shay@oracle.com or search.oracle.com

  38. 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