NoCOUG_2011 Getting_Started_with_ NET

Document Sample
NoCOUG_2011 Getting_Started_with_ NET Powered By Docstoc
					1
     <Insert Picture Here>




Getting Started with Oracle and .NET
Riaz Ahmed
Director Software Development at Oracle
Program Agenda

•   Oracle and Microsoft
                                               <Insert Picture Here>
•   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




                                                                  3
Oracle and Microsoft
Partnership




                       4
   Oracle’s Commitment to .NET


           ODT &    ODAC       64-bit    ODAC      ODAC    ODAC
ODP.NET   .NET SP   2006       ODAC      2008      2009    2010




2002-03    2005      2006      2007     2007-08    2009    2010


 .NET     VS 2003   .NET 2.0   .NET     .NET 3.5
                                                          .NET 4 &
  1.x                  &        3.0        &
                                                          VS 2010
                    VS 2005             VS 2008



                                                                     5
6
  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




                                              7
Oracle and .NET –
Getting Started




                    8
    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




                                                     9
  Oracle .NET Development Environment


Oracle Developer                          Oracle Data
 Tools for Visual                       Provider for .NET
     Studio       Application
                  Development
                                              Deploy
         Visual                    .NET
         Studio                 Framework
                           Deploy                 Web or
                                               Client/Server
              Database
              Development

                                               Oracle Providers
                         Oracle Database         for ASP.NET
                        Extensions for .NET



                                                                  10
Develop on Windows –
Run Database on any Platform



     ODT and                        Windows
     ODP.NET
                                     Linux
      Visual
      Studio
                                     Solaris
    Windows                          Other

                         Oracle 11g, 10g, or 9i

                                                  11
Oracle Developer Tools
for Visual Studio




                         12
D E M O N S T R A T I O N

  Visual Studio
   Integration
                            13
  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




                                                             14
  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
  – SQL*Plus is built in
  – Source control integration
• Integrated PL/SQL Editor and Debugger


                                                  15
  ODT Feature Overview


• Performance analysis and tuning
  – Oracle Performance Analyzer
     • Tune your running application’s 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




                                                                     16
  ODT Feature Overview


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




                                                  17
Oracle Data Provider
for .NET




                       18
  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



                                                             19
  ODP.NET Object Model


Disconnected       Connected Layer            Data
    Layer            (ODP.NET)                Layer


 DataSet       Oracle        Oracle
               DataAdapter   CommandBuilder


               Oracle         Oracle
               DataReader     Command

               Oracle         Oracle
               Transaction    Connection      Oracle


                                                       20
D E M O N S T R A T I O N

     ODP.NET

                            21
 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


                                                              22
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




                                                            23
Microsoft OracleClient Migration to ODP.NET

• Microsoft OracleClient (MSOC)
  • Microsoft’s ADO.NET provider for Oracle database
• Deprecation announced June, 2009
  – Microsoft strongly recommends using another Oracle provider
• MSOC to ODP.NET migration
  1.    Add ODP.NET reference
  2.    Add ODP.NET namespace
  3.    Update connection string (if necessary)
  4.    Add one line of code for binding parameters
       • OracleCommand.BindByName = true; //C#
• http://www.oracle.com/technetwork/topics/dotnet/inde
  x-085703.html


                                                                  24
Upcoming Features




                    25
  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


                                                                   26
  Oracle Support for LINQ and Entity Framework


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




                                                 27
  Fully Managed ODP.NET


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




                              28
Oracle Providers
for ASP.NET




                   29
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




                                                         30
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



                                               31
Oracle .NET Stored
Procedures




                     32
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




                                           33
 Oracle Database Extensions for .NET

Oracle Developer Tools
    Oracle Developer
   for Visual Studio
   Tools for VS.NET
       Visual
       Studio

Develop
                                    Oracle Database
     C#,VB,C++                     Extensions for .NET
      Server
      Project                     Client
                                Application
  Build
     Assembly     Deploy      Invoke        Stored
      foo.dll                             Procedure,
     (proc SP)                              SQL …


                                                         34
Additional Oracle
.NET Features




                    35
  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




                                                                      36
Additional Oracle .NET Capabilities


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




                                         37
           <Insert Picture Here>


Appendix




                             38
More Oracle .NET Resources



• .NET Technology Center
    – http://otn.oracle.com/dotnet
• For more questions
    – alex.keh@oracle.com
    – christian.shay@oracle.com




                                     39
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 Oracle’s
products remains at the sole discretion of Oracle.




                                                      40
41
42

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:11/11/2011
language:English
pages:42