410 likes | 420 Views
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
E N D
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 • Next Steps
<Insert Picture Here> Oracle and Microsoft – Collaborating Today and in the Future
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
<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.”
.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
<Insert Picture Here> Oracle and .NET – Getting Started
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
.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
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
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.
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
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
<Insert Picture Here> Oracle Developer Tools for Visual Studio (ODT)
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
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
Feature Overview • Oracle Query Window • Ad Hoc SQL • Explain Plan • Integrated help system – SQL, PL/SQL keywords
D E M O N S T R A T I O N Visual Studio Integration
<Insert Picture Here> Oracle Data Provider for .NET (ODP.NET)
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
D E M O N S T R A T I O N ODP.NET
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
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
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
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
<Insert Picture Here> Oracle Providers for ASP.NET
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
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
Oracle Providers for ASP.NET IIS ASP.NET Controls ASP.NET Services Oracle Providers for ASP.NET ODP.NET
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
D E M O N S T R A T I O N ASP.NET Providers
<Insert Picture Here> .NET Stored Procedures
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
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
<Insert Picture Here> Next Steps
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
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.