Transcript Oracle Developer Tools for Visual Studio .NET San FranciscoFebruary 9 Christian Shay Principal Product Manager Oracle Corporation [email protected] Prerequisites for presentation: None Level: Intermediate.

Oracle Developer Tools for Visual Studio .NET
San Francisco
2005
February 9
Christian Shay
Principal Product Manager
Oracle Corporation
[email protected]
Prerequisites for presentation:
None
Level: Intermediate
Christian Shay
Principal Product Manager
Oracle Corporation
[email protected]
Oracle Developer Tools for Visual
Studio .NET




Tightly integrated “Add-in” for Visual Studio .NET
Brings the power of Oracle Database to Windows
developers
Oracle is a premier-level partner in MS Visual
Studio Industry Partner Program (VSIP)
Free public beta available for download now
Develop on Windows, Database on
any platform
Oracle Developer
Tools for VS.NET
Visual Studio
Environment
Windows
Linux
Unix
Windows
Other
Oracle 10g, 9i, or 8i
Benefits





Easy to learn and intuitive for Windows
programmers
SQL Server developers can leverage their
experience to write Oracle apps easily and
quickly
Powerful features that enhance productivity –
e.g. designers, code generation
Exposes native Oracle functionality not
typically available in generic tools
Don’t have to leave the environment you are
comfortable in to do ordinary database tasks
Feature Overview







Oracle Explorer – browse and alter schema
Wizards & Designers – e.g. Table designer,
Stored Procedure Wizard
Automatic Code Generation
PL/SQL Editor with intellisense
Oracle Data Window
Integrated Help System –SQL, PLSQL
keywords
.NET Stored Procedure Deployment
D E M O N S T R A T I O N
Oracle Developer
Tools
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
Designers and Wizards









Table Designer
View Designer
Stored Procedure/Function Wizard
Package Wizards
Sequence Designer
Synonym Designer
Trigger Designer
Data Adapter Wizard
.NET Stored Procedure Deployment Wizard
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
PL/SQL Code Editor





Syntax Coloring
Intellisense
Context sensitive help for SQL and PLSQL
Keywords and Datatypes
Intelligent Error display
Collapsible regions
Data Window




View and Update Table data
Run Stored procedures and view data
Supports Oracle datatypes
View complex data types such as Ref Cursors
Integrated Online Help







Getting started
Walkthroughs
Oracle Developer Tools Reference Guide
Context sensitive help for UI elements
Context sensitive SQL and PLSQL keywords
Oracle SQL Reference Guide
Oracle PL/SQL Reference Guide
Coming Soon



PL/SQL Debugging
Database Project – SQL script
editing/management
Many other features…..
Oracle Database Extensions for
.NET




Run .NET stored procedures on Oracle 10g
database on Windows
Supports C#, VB.NET, C++
Build assembly in Visual Studio .NET
Deploy from Visual Studio .NET using
Deployment Wizard
Write .NET Stored Procedures for Oracle
Oracle Developer
Tools for VS.NET
Client
Application
Visual Studio
Environment
Develop
Invoke
C#,VB.NET,C++
Server Project
(Use Server
Invoke
Side ODP.NET
If required)
Build
Assembly
foo.dll
(proc sp)
Stored
Procedure,
SQL ..
Deploy
Oracle DB
Extensions
for .NET
Stored Proc sp
Server Side Oracle Data Provider
(ODP.NET)




“Oracle Data Provider for .NET” has been
available since 2002
Provides data access to .NET applications
“Server Side ODP.NET” is designed to be used
inside .NET Stored Procedures
Uses implicit database session
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 Server Side
ODP.NET classes
3) Result is a .NET Assembly
4) Run .NET Stored Procedure Deployment
Wizard
.NET Stored Procedure Deployment
Wizard



Part of Oracle Developer Tools for Visual
Studio .NET
For a given Assembly, user identifies the
procedures/functions that should be exposed
Wizard registers assembly with Oracle and
registers the stored procedures or functions
Summary



Oracle brings the power of Oracle Database to
Windows Developers
Oracle is committed to delivering the best
database for Windows and making Windows
developers more productive when using
Oracle Database
Oracle has best tools for whichever
development platform you choose
Next Steps

Visit Oracle at VSLive! Booth #707
– live demos with Oracle on Windows experts!

Oracle Developer Tools web page for free beta
download and whitepapers
– http://www.oracle.com/technology/tech/dotnet/tools/index.html

.NET Developer Center
– http://otn.oracle.com/dotnet

Windows Tech Center
– http://otn.oracle.com/windows

Contact me: [email protected]
QUESTIONS
ANSWERS