getting started with oracle and.net christian shay principal product manager,.net and windows oracle...

<Insert Picture Here>

Getting Started with Oracle and .NETChristian ShayPrincipal Product Manager, .NET and WindowsOracle 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


Oracle and Microsoft – Collaborating Today and in the Future

Oracle’s Commitment to .NET

Q3 200520032002

.NET 1.0

Q2 2005

ODP.NET ODP.NET

Visual Studio .NET

Plug-ins

.NET Stored

Procedures64-bit

ODP.NETODAC 2006

.NET 1.1 .NET 2.0 & VS 2005

Q3 2006

.NET 3.0VS 2003

Q1 2007

ODAC 11g

2007, 2008

Windows Vista, Win2k8

Relationship with Microsoft

Engineering• Close collaboration with MS Engineering teams

• Access to pre-release drops of Microsoft products

Marketing

• VSIP Premier Marketing partner

• Sponsorship at respective events

• Joint training, road shows, collateral etc.

Support• Microsoft Premier Support Agreement

• Collaboration of support teams


“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.”

Dewey ForresterDirector, Platform Evangelism

Microsoft

.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

Bill Evjen,

Technical Architect”

““

Jason Lin, Assistant Vice President, Application Integration and Architecture

“ “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

Jim Lombardi, Principal Database Engineer


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

Visual StudioEnvironmentVisual StudioEnvironment

IIS

C++, C#, VB .NET

Application

C++, C#, VB .NET

Application

Develop DeployIIS

ASP.NETIIS

ASP.NETMTS/COM+MTS/COM+

Application ApplicationDeploy

Database Development

Oracle Data Provider for .NET

Oracle Developer Tools for VS

Oracle Database Extensions for .NET

Oracle Providers for ASP.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.


• 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

Visual StudioVisual StudioEnvironmentEnvironmentVisual StudioVisual StudioEnvironmentEnvironment

ODT and ODT and ODP.NETODP.NETODT and ODT and ODP.NETODP.NET

WindowsWindows

Windows

Linux

Unix

Oracle 11g,10g, 9i, or 8i

Other


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


Oracle Data Provider for .NET (ODP.NET)

ODP.NET Object Model

DataSet OracleDataAdapter

OracleTransaction

OracleCommand

OracleConnection

OracleDataReader

Connected Layer(ODP.NET)

DisconnectedLayer

Oracle

Oracle CommandBuilder

DataLayer


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

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


• 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


• 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


IIS

ASP.NET Controls

ASP.NET Services


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


ASP.NET Providers


.NET Stored Procedures


• Database option• DB server on Windows only

• Both 32-bit and 64-bit supported

• Oracle Database 10g Release 2 or later

C#,VB.NET,C++Server Project(Use ODP.NET

if required)

Assembly foo.dll

(proc sp)

Build

Develop

Stored Proc

Stored Procedure,

SQL ..

ClientApplication

Invoke

Invoke

Deploy

Oracle Developer Tools for VS.NET


Oracle Developer Tools for Visual Studio

Visual StudioEnvironment




Next Steps

More Information

• .NET Technology Center• http://otn.oracle.com/dotnet

• .NET Blog• http://cshay.blogspot.com/

• For more questions• [email protected]

search.oracle.com

or

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.

getting started with oracle and.net christian shay principal product manager,.net and windows oracle...

Documents