Без темы
<<  DeloPro 4.0: Новые возможности Digital signage  >>
DEV 301 Oracle Developer Tools for Visual Studio
DEV 301 Oracle Developer Tools for Visual Studio
Agenda
Agenda
Windows Development Environment Support
Windows Development Environment Support
Agenda
Agenda
Oracle Developer Tools for Visual Studio
Oracle Developer Tools for Visual Studio
Develop on Windows, Database on any platform
Develop on Windows, Database on any platform
Benefits
Benefits
Feature Overview
Feature Overview
demo
demo
Oracle Explorer
Oracle Explorer
Designers and Wizards
Designers and Wizards
Automatic code generation
Automatic code generation
PL/SQL Code Editor
PL/SQL Code Editor
Data Window
Data Window
Oracle Query Window
Oracle Query Window
Integrated Online Help
Integrated Online Help
Coming Soon
Coming Soon
Agenda
Agenda
Oracle Database Extensions for
Oracle Database Extensions for
Write
Write
Creating a
Creating a
demo
demo
Agenda
Agenda
ODP
ODP
ODP
ODP
ODP
ODP
Change Notification Process
Change Notification Process
Setting up ODP
Setting up ODP
demo
demo
ODP
ODP
ODP
ODP
ODP
ODP
ODP
ODP
Next Steps
Next Steps

Презентация на тему: «DEV 301 Oracle Developer Tools for Visual Studio». Автор: Tabatha Shaddick. Файл: «DEV 301 Oracle Developer Tools for Visual Studio.ppt». Размер zip-архива: 151 КБ.

DEV 301 Oracle Developer Tools for Visual Studio

содержание презентации «DEV 301 Oracle Developer Tools for Visual Studio.ppt»
СлайдТекст
1 DEV 301 Oracle Developer Tools for Visual Studio

DEV 301 Oracle Developer Tools for Visual Studio

NET

Christian Shay, Oracle Corporation Alex Keh, Oracle Corporation

2 Agenda

Agenda

Introduction Oracle Developer Tools for VS.NET .NET Stored Procedures Demo Oracle Data Provider for .NET New Features ODP.NET demo – DB Change Notification

3 Windows Development Environment Support

Windows Development Environment Support

DB

Develop

Deploy

IIS

Deploy

Database Development

Oracle Developer Tools for VS.NET

ODP.NET

Oracle DB Extensions For .NET

Oracle Services for MTS

IIS (ASP ASP.NET)

MTS/ COM+

C++, C#, VB .NET Application

Visual Studio Environment

Application

4 Agenda

Agenda

Introduction Oracle Developer Tools for VS.NET .NET Stored Procedures Demo Oracle Data Provider for .NET New Features ODP.NET demo – DB Change Notification

5 Oracle Developer Tools for Visual Studio

Oracle Developer Tools for Visual Studio

NET

Tightly integrated “Add-in” for Visual Studio .NET Oracle is a premier-level partner in MS Visual Studio Industry Partner Program (VSIP) Available for free download now http://otn.oracle.com/dotnet

6 Develop on Windows, Database on any platform

Develop on Windows, Database on any platform

Windows

Linux

Unix

Windows

Other

Oracle 10g, 9i, or 8i

Oracle Developer Tools for VS.NET

Visual Studio Environment

7 Benefits

Benefits

Easy to learn and intuitive Leverage your SQL Server experience Powerful features that enhance productivity – e.g. designers, code generation Exposes native Oracle functionality not typically available in generic tools Stay in Visual Studio for more of your project’s lifecycle

8 Feature Overview

Feature Overview

Oracle Explorer – browse and alter schema Wizards & Designers Automatic Code Generation PL/SQL Editor with intellisense Oracle Data Window Oracle Query Window (Ad Hoc SQL) Integrated Help System – SQL, PL/SQL Keywords

9 demo

demo

Oracle Developer Tools

10 Oracle Explorer

Oracle Explorer

Tree control, similar to “Server Explorer” View Oracle schema objects Generate SQL for schema objects Filter hides unwanted schema objects A starting place for most tasks View, alter, create schema objects Auto generate code View and edit Oracle data Run stored procedures and functions

11 Designers and Wizards

Designers and Wizards

Table Designer View Designer Stored Procedure/Function Wizard Package Wizards Sequence Designer Synonym Designer Trigger Designer Data Adapter Wizard

12 Automatic code generation

Automatic code generation

Drag and drop a schema object from Oracle explorer Generated code uses OracleDataAdapter class (ODP.NET) Data Adapter Wizard can be run to customize Generate “typed datasets” as needed

13 PL/SQL Code Editor

PL/SQL Code Editor

Syntax Coloring Collapsible regions Intellisense Context sensitive help for SQL and PLSQL Keywords and Datatypes Intelligent Error display in task list Context sensitive help for Oracle error numbers

14 Data Window

Data Window

View and Update Table data Run Stored procedures and view data Supports Oracle datatypes View complex data types such as Ref Cursors

15 Oracle Query Window

Oracle Query Window

Execute “Ad Hoc” SQL Drag and drop objects from Oracle Explorer to generate SQL Result of select statements in choice of grid or text format Execute multiple statements in a row Run scripts (“@myscript.sql”)

16 Integrated Online Help

Integrated Online Help

Getting started Walkthroughs Oracle Developer Tools Reference Guide Context sensitive help for UI elements Context sensitive SQL and PLSQL keywords Oracle Error Manual Oracle SQL Reference Guide Oracle PL/SQL Reference Guide

17 Coming Soon

Coming Soon

PL/SQL Debugging Many other features…..

18 Agenda

Agenda

Introduction Oracle Developer Tools for VS.NET .NET Stored Procedures Demo Oracle Data Provider for .NET New Features ODP.NET demo – DB Change Notification

19 Oracle Database Extensions for

Oracle Database Extensions for

NET

Oracle 10g Release 2 on Windows Supports C#, VB.NET, C++ Stored Procedures Build assembly in Visual Studio .NET Deploy from Visual Studio .NET using Deployment Wizard

20 Write

Write

NET Stored Procedures for Oracle

Develop

Invoke

Invoke

Deploy

Build

Oracle Developer Tools for VS.NET

Oracle DB Extensions for .NET

Stored Proc

Client Application

Visual Studio Environment

C#,VB.NET,C++ Server Project (UseODP.NET If required)

Stored Procedure, SQL ..

Assembly foo.dll (proc sp)

21 Creating a

Creating a

NET SP

1) Use Visual Studio .NET to build a NET procedure or function in the usual way 2) If data access is required, use ODP.NET classes 3) Result is a .NET Assembly 4) Run .NET Stored Procedure Deployment Wizard 5) Call .NET SP as you would any other SP

22 demo

demo

Creating and Deploying a .NET Stored Procedure into Oracle

23 Agenda

Agenda

Introduction Oracle Developer Tools for VS.NET .NET Stored Procedures Demo Oracle Data Provider for .NET New Features ODP.NET demo – DB Change Notification

24 ODP

ODP

NET 10g Release 2 Themes

Better ease of use More flexibility Access to advanced Oracle DB features Faster performance

25 ODP

ODP

NET - RAC and Grid

Automatic connection cleanup ODP.NET frees connections to bad nodes automatically Set connection pool parameter “HA events = true” Works with 10gR2 RAC Runtime connection load balancing Connections divided among nodes based on metrics and admin policies Set connection pool parameter: “load balancing = true” Works with 10gR2 RAC

26 ODP

ODP

NET - DB Change Notification

When a DB data change occurs, client app using the data is notified Change in a query result set, schema objects, or the state of the database Works with 10gR2 DB Properties Create/Remove DB change notifications Group multiple notifications into one registration Persist notifications on DB server

27 Change Notification Process

Change Notification Process

1. When command is executed, the notification registration is created in the DB 2. ODP.NET starts the application listener upon notification registration 3. When a change occurs, the application is notified through either Callback - event delegate assigned to the OracleDependency.OnChange event property Polling - OracleDependency.HasChanges property

28 Setting up ODP

Setting up ODP

NET Change Notification

1. Create OracleDependency 2. Assign event handler to OracleDependency.OnChange event property Event handler invoked when the change notification is received 3. Set the port for the listener to listen on 4. Bind the OracleDependency instance to the OracleCommand with the query Internally, the DB change notification request is created and assigned to the OracleCommand.Notification property

29 demo

demo

DB Change Notification

30 ODP

ODP

NET - Connection Pool Management

Explicitly refresh connections in a pool or pools Clear connections from a pool or pools One pool - Execute OracleConnection.ClearPool method All pools – Execute OracleConnection.ClearAllPools method Works with 10gR2 and earlier DBs

31 ODP

ODP

NET - LOB (and LONG) Retrieval

Faster performance Fewer DB round trips for LOB retrieval Transparent to developer Works with 10gR2 DB More tunable and usable Full LOB functionality when InitialLOBFetchSize > 0 GetOracleBlob() and GetOracleClob() methods in OracleDataReader supported InitialLOBFetchSize can be up to 2GB Works with 10gR2 DB

32 ODP

ODP

NET - Security

Application security context ODP.NET can set the Client Identifier in the Application Context for every database session Similar to proxy user authentication, but requires only one session and no pre-created proxy user Set OracleConnection.ClientIdentifier = “gold customer” Works with 10gR2 and earlier DBs

33 ODP

ODP

NET - Additional Features

Input REF Cursors into PL/SQL Only works when REF Cursor is output from PL/SQL first Works with 10gR2 DB ODP.NET works with .NET Stored Procedures Additional ADO.NET 2.0 features for ODP.NET in 2nd half 2005

34 Next Steps

Next Steps

Come to the Oracle booth (Exhibition Hall Stand A21) for a one on one demonstration with .NET experts Next Session: SVR340 Oracle on Windows Thu Jul 7 10:15 - 11:30 Room: 2c .NET Developer Center - free downloads, demos, walkthroughs, and whitepapers http://otn.oracle.com/dotnet Oracle Developer Tools & .NET Stored Proc questions? Email: christian.shay@oracle.com Oracle Data Provider (ODP.NET) questions? Email: alex.keh@oracle.com

«DEV 301 Oracle Developer Tools for Visual Studio»
http://900igr.net/prezentacija/informatika/dev-301-oracle-developer-tools-for-visual-studio-263137.html
cсылка на страницу

Без темы

778 презентаций
Урок

Информатика

130 тем
Слайды
900igr.net > Презентации по информатике > Без темы > DEV 301 Oracle Developer Tools for Visual Studio