Скачать презентацию Insert Picture Here New NET Features for the Скачать презентацию Insert Picture Here New NET Features for the

2b8f00888e18887558e476d919dcc840.ppt

  • Количество слайдов: 38

<Insert Picture Here> New. NET Features for the Oracle Database Christian Shay Product Manager New. NET Features for the Oracle Database Christian Shay Product Manager Oracle

Agenda • • • Oracle and. NET Overview New Feature Themes Ease of Development Agenda • • • Oracle and. NET Overview New Feature Themes Ease of Development Performance Manageability and Installation

<Insert Picture Here> Oracle on. NET Overview Oracle on. NET Overview

. NET Development Environment Support Oracle Developer Tools for Visual Studio Oracle Data Provider . NET Development Environment Support Oracle Developer Tools for Visual Studio Oracle Data Provider for. NET Application Development. NET Application Visual Studio Environment Deploy Database Development Deploy Web or Client/Server Application Oracle Providers for ASP. NET Oracle Database Extensions for. NET

. NET Components for Oracle Database • Free • Stay in Visual Studio for . NET Components for Oracle Database • Free • Stay in Visual Studio for project lifecycle • Supports Visual Studio 2003, 2005, and 2008 • Complete access to. NET functionality • Supports. NET Framework 1. 0 and higher • Supports 32 -bit, x 64, and 64 -bit Itanium platforms • ASP. NET services and controls via ASP. NET providers • Easy to use and intuitive • Native access to Oracle Database • Utilize advanced Oracle Database features • E. g. RAC, performance, security, data types, XML, etc.

Develop on Windows, Database on any Platform ODT and ODP. NET Visual Studio Environment Develop on Windows, Database on any Platform ODT and ODP. NET Visual Studio Environment Windows Linux Unix Other Oracle 11 g, 10 g, 9 i, or 8 i

Oracle Technology Network –. NET Developer Center • http: //otn. oracle. com/dotnet • Free 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

<Insert Picture Here> New Feature Themes New Feature Themes

New. NET Feature Themes • Ease of Development • • Performance • • • New. NET Feature Themes • Ease of Development • • Performance • • • Tight integration with Visual Studio 2005 and 2008 Improve productivity for ASP. NET development Objects/UDTs/ADTs Expose new tuning features Improve performance out of the box Manageability and Installation • Deployment: smaller client and easier packaging

<Insert Picture Here> Ease of Development Ease of Development

Ease of Development – Visual Studio • Fully integrated with Visual Studio 2005 and Ease of Development – Visual Studio • Fully integrated with Visual Studio 2005 and 2008 • • Server Explorer Data Sources Window Data Source Configuration Wizard Dataset Designer Table. Adapter Configuration Wizard Query Builder/Query Designer More • Automatic code generation – Winform and ASP. NET • Data Sources Window • Integration with SQLData. Source control • Makes ASP. NET web application development very easy

Ease of Development – Visual Studio • New Oracle Wizards and Designers • Grant/Revoke Ease of Development – Visual Studio • New Oracle Wizards and Designers • Grant/Revoke Privileges Wizard • Import Table Wizard – Migrate tables/data from databases, Excel, Access • Object, VARRAY, Nested Table Designers • UDT Custom Class Code Generation Wizard • Full Oracle UDT Support • View UDT’s in Server Explorer • CRUD operations on UDTs in tables and views • Use UDT types in other Wizards (eg Table designer) • Oracle Data Window Enhancements • Customizable – control how many rows are fetched

Ease of Development – Visual Studio • New Oracle Database Project • Manage, Edit Ease of Development – Visual Studio • New Oracle Database Project • Manage, Edit and Run SQL scripts • SQL*Plus is built in • Source control integration – Source. Safe and Team Foundation Server • Oracle Query Window • New UI • Explain Plan • Auto-commit toggle • ODT Options page • Customize how you use ODT

D E M O N S T R A T I O N New D E M O N S T R A T I O N New ODT Features

Ease of Development – UDTs • Benefit: Simplify Oracle UDT application development • • Ease of Development – UDTs • Benefit: Simplify Oracle UDT application development • • Optimum for Spatial and other object developers UDT development – data access • • Oracle data types • Objects • Mapped to. NET custom objects • Collections (Varrays and Nested Tables) • Mapped to. NET custom objects and arrays • REF • ODP. NET Oracle. Ref can represent Oracle REF Custom type factory and custom type required • Custom type factory instantiates the custom type • Custom types define mapping between UDT attributes/elements and. NET type members

Ease of Development – UDTs • UDT development - tools • • Create, view, Ease of Development – UDTs • UDT development - tools • • Create, view, and modify UDTs and their specifications • Designers for Varrays, Nested Tables, and Objects • Designers for Object tables and views • New tree control nodes for UDTs Custom Class Wizard • Automatically generate. NET custom type from existing Oracle Collections and Objects • Generates C#, VB. NET, or C++

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

Oracle Providers for ASP. NET • Pre-built services to store website state into Oracle 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 Oracle Providers for ASP. NET • Seamless integration with ASP. NET services and controls • • • Easy to switch from SQL Server to Oracle quickly • • Reference to specific providers unnecessary High level of abstraction: services and controls based programming 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 Oracle Providers for ASP. NET IIS ASP. NET Controls ASP. NET Services Oracle Providers for ASP. NET ODP. NET

Available Providers • Oracle Providers for ASP. NET components • • • Membership Provider Available Providers • Oracle Providers for ASP. NET components • • • Membership Provider Role Provider Profile Provider Session State Provider Site Map Provider Web Parts Personalization Provider Web Event Provider Cache Dependency Provider Administrators pick which provider(s) to use • Most providers are independent of one another

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

<Insert Picture Here> Performance Performance

Performance – Data Retrieval (11 g) • Client Result Cache • • • Improved Performance – Data Retrieval (11 g) • Client Result Cache • • • Improved statement caching • • Automatically caches results sets on client No. NET code changes required to use Accessible across the same process to different sessions with same user settings Cache remains consistent via DB Change Notification Cache ODP. NET parameter contexts Better LOB performance • • LOB prefetching – fewer roundtrips Even more LOB performance improvement using Secure. Files

Performance – Loading External Data • • Load external data quickly into Oracle database Performance – Loading External Data • • Load external data quickly into Oracle database programmatically ADO. NET 2. 0 Bulk Copy • • • Direct data upload from. NET to Oracle Excellent for large amounts of external data Performance comparable to SQL*Loader

Performance – 64 -bit • • Allow ODP. NET and. NET stored procedures to Performance – 64 -bit • • Allow ODP. NET and. NET stored procedures to use more scalable 64 -bit hardware (10. 2. 0. 3) Windows x 64 • • • Windows Itanium • • • 64 -bit ODP. NET 64 -bit. NET Stored Procedures Available for download on OTN from. NET Center

<Insert Picture Here> Manageability and Installation Manageability and Installation

Instant Client (IC) • • • IC available with OUI and xcopy No functionality Instant Client (IC) • • • IC available with OUI and xcopy No functionality difference between IC and standard client IC Benefits • Control over install process • Xcopy • Fine grain control over installation process • Great for large scale deployments or ISV packaging • OUI – great for small scale deployments • Smaller install size compared to standard install • Xcopy install – smallest footprint • OUI install – small footprint • Fastest client deployment – Xcopy install

New Instant Client Components • • • ODP. NET Oracle Providers for ASP. NET New Instant Client Components • • • ODP. NET Oracle Providers for ASP. NET Oracle Provider for OLE DB OO 4 O Oracle Services for MTS

IC Deployment • OUI • • Use the installer as you normally would Xcopy IC Deployment • OUI • • Use the installer as you normally would Xcopy • • Step 1: Unzip and copy IC files to disk Step 2: Run install. bat • Provide parameters specifying product(s) to install, Oracle Home name, and target location • Step 3: Add installation directories to Windows PATH • Step 4: Modify NLS_LANG to desired locale

Managing Multiple Oracle Homes in. NET • Solution for ODP. NET 10. 2. 0. Managing Multiple Oracle Homes in. NET • Solution for ODP. NET 10. 2. 0. 4 and higher • ODP. NET reads. NET config files for location of unmanaged Oracle DLLs • Each app can use different Oracle client DLLs even if same ODP. NET managed version is used • DLL search order • • 1. Current application directory 2. Application config or web. config 3. Machine. config 4. Windows Registry • HKLMSoftwareOracleODP. NETDll. Path • 5. Windows System Path setting

D E M O N S T R A T I O N Client D E M O N S T R A T I O N Client Deployment

<Insert Picture Here> Appendix Appendix

More Information • . NET Technology Center • http: //otn. oracle. com/dotnet • . More Information • . NET Technology Center • http: //otn. oracle. com/dotnet • . NET Blog • http: //cshay. blogspot. com/ • For more questions • christian. [email protected] com or search. oracle. com

Your Feedback is Important Please fill out a session evaluation form and either put Your Feedback is Important Please fill out a session evaluation form and either put them in the basket near the exit or drop them off at the conference registration desk. Thank you!

The preceding is intended to outline our general product direction. It is intended for 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.