“This presentation is for informational purposes only and may.PPT

Agenda Oracle Developer Tools for Visual Studio .NET Overview Demo - drill down Oracle Database Extensions for .NET Overview Demo – My First SP Tuning and Data Access Demo – Data Access in a SP Demo – Debugging a .NET SP Windows Development Environment Support Oracle Developer Tools for Visual Studio .NET Tightly integrated “Add-in” for Visual Studio .NET Oracle is a premier-level partner in the Microsoft Visual Studio Industry Partner (VSIP) Program Available for free download now /dotnet Develop on Windows, Database on any Platform Benefits Easy to learn and intuitive Leverage SQL Server development experience Powerful features that enhance productivity – e.g. designers, auto code generation Exposes latest and greatest Oracle functionality Stay in Visual Studio for project lifecycle Feature Overview Oracle Explorer – browse and alter schema Wizards and Designers Automatic code generation PL/SQL Editor with IntelliSense Oracle Data Window Oracle Query Window (ad hoc SQL) .NET Stored Procedure Deployment Wizard Integrated help system – SQL, PL/SQL keywords 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 Oracle Explorer Designers and Wizards Table Designer View Designer Stored Procedure/Function Wizard Package Wizards Sequence Designer Synonym Designer Trigger Designer Data Adapter Wizard Table Designer 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 PL/SQL Code Editor Syntax Coloring Collapsible regions IntelliSense Context sensitive help for SQL/PLSQL keywords Intelligent error display in task list Context-sensitive help for Oracle error number