DEV 301 Oracle Developer Tools for Visual Studio
- Slides: 34
DEV 301 Oracle Developer Tools for Visual Studio. NET Christian Shay, Oracle Corporation Alex Keh, Oracle Corporation
Agenda Introduction Oracle Developer Tools for VS. NET Stored Procedures Demo Oracle Data Provider for. NET New Features ODP. NET demo – DB Change Notification
Windows Development Environment Support Oracle Developer Tools for VS. NET Visual Studio Environment Develop C++, C#, VB. NET Application Deploy IIS MTS/ (ASP COM+ ASP. NET) Application Deploy Database Development IIS DB Oracle DB Extensions For. NET ODP. NET Oracle Services for MTS
Agenda Introduction Oracle Developer Tools for VS. NET Stored Procedures Demo Oracle Data Provider for. NET New Features ODP. NET demo – DB Change Notification
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
Develop on Windows, Database on any platform Oracle Developer Tools for VS. NET Visual Studio Environment Windows Linux Unix Windows Other Oracle 10 g, 9 i, or 8 i
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
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
demo 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
Automatic code generation Drag and drop a schema object from Oracle explorer Generated code uses Oracle. Data. Adapter class (ODP. NET) Data Adapter Wizard can be run to customize Generate “typed datasets” as needed
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
Data Window View and Update Table data Run Stored procedures and view data Supports Oracle datatypes View complex data types such as Ref Cursors
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”)
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
Coming Soon PL/SQL Debugging Many other features…. .
Agenda Introduction Oracle Developer Tools for VS. NET Stored Procedures Demo Oracle Data Provider for. NET New Features ODP. NET demo – DB Change Notification
Oracle Database Extensions for. NET Oracle 10 g 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
Write. NET Stored Procedures for Oracle Developer Tools for VS. NET Client Application Visual Studio Environment Develop Invoke C#, VB. NET, C++ Server Project (Use. ODP. NET If required) Build Assembly foo. dll (proc sp) Invoke Deploy Stored Procedure, SQL. . Oracle DB Extensions for. NET
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
demo Creating and Deploying a. NET Stored Procedure into Oracle
Agenda Introduction Oracle Developer Tools for VS. NET Stored Procedures Demo Oracle Data Provider for. NET New Features ODP. NET demo – DB Change Notification
ODP. NET 10 g Release 2 Themes Better ease of use More flexibility Access to advanced Oracle DB features Faster performance
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 10 g. R 2 RAC Runtime connection load balancing Connections divided among nodes based on metrics and admin policies Set connection pool parameter: “load balancing = true” Works with 10 g. R 2 RAC
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 10 g. R 2 DB Properties Create/Remove DB change notifications Group multiple notifications into one registration Persist notifications on DB server
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 Oracle. Dependency. On. Change event property Polling - Oracle. Dependency. Has. Changes property
Setting up ODP. NET Change Notification 1. Create Oracle. Dependency 2. Assign event handler to Oracle. Dependency. On. Change event property Event handler invoked when the change notification is received 3. Set the port for the listener to listen on 4. Bind the Oracle. Dependency instance to the Oracle. Command with the query Internally, the DB change notification request is created and assigned to the Oracle. Command. Notification property
demo DB Change Notification
ODP. NET - Connection Pool Management Explicitly refresh connections in a pool or pools Clear connections from a pool or pools One pool - Execute Oracle. Connection. Clear. Pool method All pools – Execute Oracle. Connection. Clear. All. Pools method Works with 10 g. R 2 and earlier DBs
ODP. NET - LOB (and LONG) Retrieval Faster performance Fewer DB round trips for LOB retrieval Transparent to developer Works with 10 g. R 2 DB More tunable and usable Full LOB functionality when Initial. LOBFetch. Size > 0 Get. Oracle. Blob() and Get. Oracle. Clob() methods in Oracle. Data. Reader supported Initial. LOBFetch. Size can be up to 2 GB Works with 10 g. R 2 DB
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 Oracle. Connection. Client. Identifier = “gold customer” Works with 10 g. R 2 and earlier DBs
ODP. NET - Additional Features Input REF Cursors into PL/SQL Only works when REF Cursor is output from PL/SQL first Works with 10 g. R 2 DB ODP. NET works with. NET Stored Procedures Additional ADO. NET 2. 0 features for ODP. NET in 2 nd half 2005
Next Steps Come to the Oracle booth (Exhibition Hall Stand A 21) for a one on one demonstration with. NET experts Next Session: SVR 340 Oracle on Windows Thu Jul 7 10: 15 - 11: 30 Room: 2 c. 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
- Oracle developer tools for vs code
- Office developer tools for visual studio 2017
- Patwel group object browser
- Xna game studio express
- Xna game studio visual studio 2017
- Microsoft visual studio 2005 tools for applications
- Progress developer
- Microsoft robotics developer studio download
- Developer android sdk download
- Microsoft robotics developer studio tutorial
- Microsoft robotics studio
- ヒモ マッチングアプリ
- Progress developer studio
- Introduction to android
- Oracle developer terdiri dari
- Google forms developers
- Toad for oracle 사용법
- Sql developer unit testing
- Use developer tools to create custom visuals power bi
- Financial reporting studio
- Download visual studio express 2017
- Visual studio 2010 training
- Visual basic introduccion
- Visual studio ar
- Visual basic express 2010
- Visual studio family
- Morse code flowchart
- Android studio avd manager missing
- Visual studio 2010 express
- Visual studio composer
- Visual studio emacs
- Visual studio graphics library
- Appium studio download
- Visual studio wireframe
- Visual studio orcas