Getting Started with Oracle and .NET

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

• Riaz Ahmed
• Director Software Development at Oracle

3
Program Agenda
ltInsert Picture Heregt

• Oracle and Microsoft
• Oracle and .NET getting started
• Oracle Developer Tools for Visual Studio
• Oracle Data Provider for .NET
• Oracle Providers for ASP.NET
• Oracle .NET stored procedures
• Additional Oracle .NET features

4
Oracle and Microsoft Partnership
5
Oracles Commitment to .NET
ODAC 2009
64-bit ODAC
ODAC 2006
ODAC 2010
ODT .NET SP
ODAC 2008
ODP.NET
2009
2006
2002-03
2007
2005
2007-08
2010
.NET 3.5 VS 2008
.NET 1.x
.NET 2.0 VS 2005
.NET 3.0
VS 2003
.NET 4 VS 2010
6
(No Transcript)
7
Oracle .NET Large Developer Community

• Over 800K Oracle .NET developer community
• Microsoft MVP endorsements of ODAC
• Bill Evjen, founder of INETA
• Andrew Brust
• John Cook
• Top twenty most downloaded OTN software
• ODAC downloads
• One of the most visited websites on OTN
• OTN .NET Developer Center

8
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
• Whitepapers
• Sample Code
• Demo Videos
• Help Forums
• How to step by step tutorials
• Latest Oracle on .NET News

10
Oracle .NET Development Environment
Oracle Developer Tools for Visual Studio
Oracle Data Provider for .NET
ApplicationDevelopment
Deploy
.NET Framework
Visual Studio
Web or Client/Server
Deploy
Database Development
Oracle Providers for ASP.NET
Oracle Database Extensions for .NET
11
Develop on Windows Run Database on any Platform
Windows
ODT and ODP.NET
Linux
Visual Studio
Solaris
Windows
Other
Oracle 11g, 10g, or 9i
12
Oracle Developer Tools for Visual Studio
13
D E M O N S T R A T I O N
Visual Studio Integration
14
ODT Feature Overview

• Fully integrated with Visual Studio 2010, 2008,
  and 2005
• Server Explorer
• Data Sources Window
• Dataset Designer
• TableAdapter Configuration Wizard
• Query Builder/Query Designer
• More
• Automatic code generation WinForm and ASP.NET
• Makes ASP.NET web application development very
  easy

15
ODT 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

16
ODT Feature Overview

• Performance analysis and tuning
• Oracle Performance Analyzer
• Tune your running applications use of the
  database
• SQL Tuning Advisor
• Tune ad-hoc queries in Query Window
• Tune inefficient application SQL detected by
  Oracle Performance Analyzer
• Messaging
• Advanced Queuing (AQ) designers
• Create, modify, and administer your queues and
  queue tables

17
ODT Feature Overview

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

18
Oracle Data Provider for .NET
19
ODP.NET - Basics

• Implements standard ADO.NET
• Adds Oracle DB-specific capabilities
• Easy to use and intuitive
• Native access to Oracle Database
• Utilize advanced Oracle Database features
• E.g. RAC, performance, security, data types, XML,
  etc.
• DB server can be on any operating system
• DB client can be 32-bit or 64-bit
• Supports .NET Framework 1.0 and higher
• DB client and server versions not need to match

20
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
21
D E M O N S T R A T I O N
ODP.NET
22
Key ODP.NET Features

• Connection pooling
• RAC automatic load balancing
• RAC and Data Guard automatic dead connection
  cleanup
• Performance counters
• 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
• Oracle data types in DataSet
• OracleDataAdapter.ReturnProviderSpecificTypes
  true

23
Key ODP.NET Features

• Performance tuning
• Statement caching
• FetchSize and RowSize
• Security and auditing
• Proxy authentication
• End-to-end tracing with Client Id, Action, and
  Module
• Deployment
• Oracle Universal Installer great for
  individuals
• Xcopy Instant Client great for large deployments

24
Microsoft OracleClient Migration to ODP.NET

• Microsoft OracleClient (MSOC)
• Microsofts ADO.NET provider for Oracle database
• Deprecation announced June, 2009
• Microsoft strongly recommends using another
  Oracle provider
• MSOC to ODP.NET migration
• Add ODP.NET reference
• Add ODP.NET namespace
• Update connection string (if necessary)
• Add one line of code for binding parameters
• OracleCommand.BindByName true //C
• http//www.oracle.com/technetwork/topics/dotnet/in
  dex-085703.html

25
Upcoming Features
26
Oracle Support for LINQ and Entity Framework

• Entity Data Model Wizard and Designer
• Generate a conceptual model from Oracle Database
• Update conceptual model, storage model, and
  mappings from Oracle Database
• Generate Oracle SQL DDL script from the
  conceptual model
• Query language interfaces
• LINQ to Entities
• Entity SQL
• DML capabilities (insert/update/delete)
• Entity Framework auto-generates DML statements
  for Oracle Database
• Or use your own Oracle stored procedures for DML

27
Oracle Support for LINQ and Entity Framework

• Availability
• Beta Available now, version 11.2.0.2.30
• Production End of 2011

28
Fully Managed ODP.NET

• 100 managed provider
• Including Oracle Client
• Fully ADO.NET compliant
• Release schedule
• Beta 2011

29
Oracle Providers for ASP.NET
30
Oracle Providers for ASP.NET Concepts

• 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

31
Oracle Providers for ASP.NET Components

• Eight providers available
• Cache Dependency Provider
• Membership Provider
• Profile Provider
• Role Provider
• Site Map Provider
• Session State Provider
• Web Parts Personalization Provider
• Web Events Provider
• Administrators pick which providers to use
• One or more in any combination

32
Oracle .NET Stored Procedures
33
Oracle Database Extensions for .NET

• Database option
• Windows only
• Both 32-bit and 64-bit supported
• Must have .NET Framework
• Oracle Database 10g Release 2 or later

34
Oracle Database Extensions for .NET
Oracle Developer Tools for Visual Studio
Oracle Developer Tools for VS.NET
Visual Studio
Develop
Oracle Database Extensions for .NET
C,VB,C Server Project
Client Application
Build
Stored Procedure, SQL
Invoke
Deploy
Assembly foo.dll (proc SP)
35
Additional Oracle .NET Features
36
TimesTen Data Provider for .NET

• What is TimesTen
• Memory-optimized relational database for instant
  responsiveness and very high throughput
• Deployed in application tier as an embedded or
  standalone DB
• Available with 11.2.0.2
• Supports ODP.NET classes, enumerations,
  interfaces, delegates, and structures

37
Additional Oracle .NET Capabilities

• Coherence
• Oracle Application Testing Suite
• Berkeley DB
• Oracle Business Process Management
• Grid Control Plug-Ins
• And more.

38
ltInsert Picture Heregt
Appendix
39
More Oracle .NET Resources

• .NET Technology Center
• http//otn.oracle.com/dotnet
• For more questions
• alex.keh_at_oracle.com
• christian.shay_at_oracle.com

40
The preceding is intended to outline our general
product direction. It is intended for information
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.
41
(No Transcript)
42
(No Transcript)