Getting Started with Oracle and .NET

1
(No Transcript)
2
(No Transcript)
3
Getting Started with Oracle and .NET

• Christian Shay, Principal Product Manager, Server
  Technologies
• Anu Chawla, Program Manager, Platform Evangelism,
  Microsoft

4
Agenda

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

5

Oracle and Microsoft Collaborating Today and in
the Future
6
Oracles Commitment to .NET
Visual Studio .NET Plug-ins
.NET Stored Procedures
64-bit ODP.NET
ODAC 2006
ODP.NET
ODP.NET
ODAC 2007
Q3 2005
2003
2002
Q2 2005
Q3 2006
Q1 2007
2007
.NET 1.0
.NET 1.1
.NET 2.0 VS 2005
.NET 3.0
VS 2003
Windows Vista
7
Relationship with Microsoft

8

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.
9
.NET Customers





Were 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
Jason Lin, Assistant Vice President, Application
Integration and Architecture
Jim Lombardi, Principal Database Engineer
10

Oracle and .NET Getting Started
11
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

12
.NET Development Environment Support
Oracle Providers for ASP.NET
Oracle Developer Tools for VS.NET
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
13
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
14

Oracle Developer Tools for Visual Studio .NET
(ODT)
15
Feature Overview

• Fully integrated with Visual Studio 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
• Supports Visual Studio 2008 (beta2)
• Automatic code generation Winform and ASP.NET
• Makes ASP.NET web application development very
  easy

16
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
• SQLPlus is built in
• Source control integration
• Integrated PL/SQL Editor and Debugger

17
Feature Overview

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

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

Oracle Data Provider for .NET (ODP.NET)
20
ODP.NET - Basics

• Supports Oracle8i and higher Oracle DB Server
• DB server can be on any operating system
• Uses 9.2 client or higher
• Database client on Windows
• Supports 32-bit, 64-bit x64, and 64-bit Itanium
• Available as free download
• http//otn.oracle.com/dotnet

21
ODP.NET Object Model
Connected Layer (ODP.NET)
Disconnected Layer
Data Layer
Oracle DataAdapter
Oracle CommandBuilder
DataSet
Oracle Command
Oracle DataReader
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
ODP.NET Features

• Database Change Notification
• Performance Tuning
• Statement caching
• FetchSize and RowSize
• 64-bit AMD64/EM64T and Itanium
• Security
• Proxy authentication
• Application security context

27
Top Unique ODP.NET Features
Features Oracle Result Set Retrieval
Tuning Options Yes Configurable LOB Retrieval
Yes Array Parameters Yes Proxy
Auth. and Secure App Context Yes Real
Application Clusters Support Yes More
Robust Change Notification Yes
28

Oracle Providers for ASP.NET
29
Oracle Providers for ASP.NET

• ASP.NET Providers
• Pre-built services to store website state into
  databases
• Easy to learn
• Based on standard ASP.NET provider APIs and
  schema
• Can be managed by IIS
• Membership and role information
• Installation
• Run PL/SQL scripts to create provider schemas

30
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

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

.NET Stored Procedures
33
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

34
Oracle Database Extensions for .NET
Oracle Developer Tools for Visual Studio .NET
Oracle Developer Tools for VS.NET
Client Application
Visual Studio Environment
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
35

Next Steps
36
.NET Hands On Lab!

• Tuesday 445pm - Continental Ballroom 4
• Seven Lessons to choose from -- beginner level to
  advanced
• Preinstalled on each machine
• Visual Studio
• ODT
• ODP.NET
• .NET Stored Procedures

37
.NET Demogrounds Booth

• All week
• Oracle .NET Engineering staff are there to give
  you a demo and answer questions
• Moscone West, first floor, far left back corner
  area

38
Todays Oracle Develop .NET Sessions

• 1230 pm in this room
• New Features in Oracle Database 11g for .NET
  Developers
• 145pm - Continental Ballroom 6
• ASP.NET Web Development with Oracle Database
• 315pm - Franciscan Room A
• Using Complex Oracle Datatypes in .NET LOBs,
  User-Defined Types, and XML
• 445pm - Franciscan Room A
• Building Scalable and Highly Available .NET
  Applications with Oracle RAC and Oracle Data
  Guard

39
Tuesdays Oracle Develop .NET Sessions

• 1045 am Yosemite Room A
• Database Development Lifecycle Management with
  Visual Studio SQL, PL/SQL, and .NET Stored
  Procedure Development, Source Control, and
  Deployment
• 1215pm - Yosemite Room A
• PL/SQL Programming for .NET Developers Tips,
  Tricks, and Debugging
• 145pm - Continental Ballroom 5
• Optimizing .NET Data Access Performance with
  Oracle Database
• 315pm - Franciscan Room A
• .NET Data Caching Using Oracle Change
  Notification and the Client Result Cache

40
Wednesdays Database on Windows Sessions

• 945 pm Moscone South 304
• What's New for Oracle Database 11g on Windows and
  .NET
• 430 pm - Moscone South 304
• Best Practices for Performance of Oracle Database
  on Windows

41
Thursdays Database on Windows Sessions

• 830 am Moscone South 104
• Best Practices for Oracle Database and Client
  Deployment on Windows
• 100 pm - Moscone South 309
• Using Oracle RAC and Microsoft Windows 64-Bit as
  the Foundation for a Database Grid
• 100 pm Moscone South 306
• Oracle Database Integration with Active Directory
  and Windows Security

42
More Information

• .NET Technology Center
• http//otn.oracle.com/dotnet
• Windows Server Center
• http//otn.oracle.com/windows
• .NET Blog
• http//cshay.blogspot.com/
• For more questions
• christian.shay_at_oracle.com

43
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 Oracles products
remains at the sole discretion of Oracle.
44
(No Transcript)
45
(No Transcript)