Getting Started with Oracle Development using Microsoft Visual Studio .NET 2003 - PowerPoint PPT Presentation

Loading...

PPT – Getting Started with Oracle Development using Microsoft Visual Studio .NET 2003 PowerPoint presentation | free to view - id: c6af-ODZjZ



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Getting Started with Oracle Development using Microsoft Visual Studio .NET 2003

Description:

Getting Started with Oracle Development using Microsoft Visual Studio .NET 2003 ... As defined on MSDN, Microsoft .NET is software that connects information, people, ... – PowerPoint PPT presentation

Number of Views:106
Avg rating:3.0/5.0
Slides: 46
Provided by: medtr
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Getting Started with Oracle Development using Microsoft Visual Studio .NET 2003


1
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle Development Tools for Visual Studio .NET
    2003

Presented by Kalvin Parman Principal Software
Engineer Medtronic, Inc. kalvin.parman_at_medtronic.c
om
2
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

3
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Kalvin Parman -Principal Software Engineer
    Medtronic, Inc.
  • Objective
  • Provide an introduction to the Oracle Developer
    Tools for Visual Studio .NET 2003.

4
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

5
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • What is Microsoft .NET?
  • As defined on MSDN, Microsoft .NET is software
    that connects information, people, systems, and
    devices.
  • Microsoft .NET consists of
  • Developer tools
  • Visual Studio .NET
  • The .NET Framework
  • A set of Servers
  • Windows Server 2003, Microsoft SQL Server,
    Microsoft BizTalk Server
  • Client software
  • Windows XP, Windows CE, Microsoft Office XP

6
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

7
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • What is Visual Studio .NET 2003?
  • Visual Studio .NET 2003 is a multi-language
    integrated development environment (IDE)
  • Provides tools for the design, building, testing
    and deployment of Windows Applications and Web
    Services
  • Integrated with the .NET Framework 1.1

8
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
Visual Studio .NET 2003
9
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

10
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • What is the Microsoft .NET Framework 1.1?
  • The .NET Framework is a multi-language
    development and execution environment for windows
    application and web service development
  • Initial release in 2002, release 1.0
  • Currently .NET Framework 1.1
  • .NET Framework 2.0 beta 1 is currently available
    as a download from MSDN

11
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • The .NET Framework
  • Supports over 20 different programming languages.
  • APL, Fortran, Pascal, C, Perl, C, Java,
    Python, COBOL, Microsoft JScript, RPG, Pascal,
    SmallTalk, Microsoft Visual Basic
  • Manages much of the plumbing involved in
    developing software. This enables developers to
    focus more on coding core business logic
  • The .NET Framework consists of
  • The Common Language Runtime (CLR)
  • The Framework Class Libraries (FCL)

12
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Common Language Runtime (CLR)
  • The CLR is the execution engine for .NET
    framework applications
  • It is responsible for run-time services
  • language integration
  • security enforcement
  • memory, process, and thread management
  • And development cycle features
  • life-cycle management of objects
  • cross-language exception handling, etc.

13
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Framework Class Libraries (FCL)
  • A collection of classes that provide a common,
    consistent development interface across all
    languages supported by the .NET Framework.

14
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • FCL Consists of
  • Base classes Input/output, thread, network,
    string, text, user interface design features
  • ADO.NET classes data access in the form of XML
    through the OLE DB, ODBC, Oracle and SQL Server
    interfaces
  • XML classes Extensible Markup Language
    processing
  • ASP.NET classes support for web based
    application and web services
  • Windows Forms classes support desktop based
    applications

15
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

16
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • What is an ADO .NET?
  • ADO.NET is a set of classes that expose data
    access services to the .NET programmer.
  • What is a Data Provider?
  • A Data Provider in the .NET Framework serves as a
    bridge between an application and a data source.

17
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • ADO.NET Data Providers
  • Bridge Connections
  • Microsoft .NET OLE DB Data Provider
  • Microsoft .NET ODBC Data Provider
  • Native Connections
  • Microsoft SQL Server .NET Data Provider
  • mySQL .NET Data Provider
  • Microsoft .NET Data Provider for Oracle
  • Oracle .NET Data Provider (ODP.NET)
  • Custom Connections
  • IDbConnection, IDbCommand, IDataReader,
    IDataAdapter

18
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle Data Provider for .NET (ODP.NET)
  • Free download available at http//www.oracle.com/t
    echnology/tech/windows/odpnet
  • ODP.NET is fully compliant with ADO.NET
  • Provides advanced Oracle functionality
  • High performance ADO.NET

19
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • ODP.NET
  • Supports Oracle 8, 8i, 9i and 10g Database
    servers on Linux, Unix, Windows, etc.
  • Windows Client must be 9i or 10g

20
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • ADO.NET Object Model for Oracle

OracleCommandBuilder
OracleDataAdapter
DataSet
OracleCommand
OracleDataReader
Oracle
OracleConnection
OracleTransaction
Connected Layer (ODP.NET)
Disconnected Layer
Data Layer
21
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
First Create a namespace reference to
Oracle.DataAccess.dll
  • using System
  • using Oracle.DataAccess.Client
  • namespace ConsoleApplication1
  • class Class1
  • STAThread
  • static void Main(string args)
  • OracleConnection conn new OracleConnection("U
    ser IdscottPasswordtiger1")
  • conn.Open()
  • OracleCommand cmd conn.CreateCommand()
  • cmd.CommandText "select ename from emp where
    deptno 20"
  • OracleDataReader reader cmd.ExecuteReader()
  • while (reader.Read())
  • Console.WriteLine("Employee Name "
    reader.GetString(0))

Spacing in ConnectionString creates a new pool
Close all ODP.NET objects, do not count on the
garbage collector to do this
22
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • ODP.NET Basic SELECT Console Application Demo

23
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

24
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • What is the Oracle Development Tools for Visual
    Studio .NET 2003 (ODT for VS.NET)?
  • Tightly integrated "Add-in" for Visual Studio
    .NET
  • Provides Oracle database functionality to Windows
    developers
  • Partnership between Oracle and Microsoft -Oracle
    is a premier-level partner in MS Visual Studio
    Industry Partner Program (VSIP)
  • Free product

25
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Beta is available on Oracle Technical Network
    (OTN)
  • Production version planned for release end of
    April 2005 followed by 6 month releases
  • Stored procedure debugging will be available in
    the fall release
  • With the release of Oracle 10.2 on Windows, users
    will be able to deploy stored procedures written
    in .NET from Visual Studio.

26
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • The Oracle Development Tools contains
  • Oracle Explorer -browse Oracle schemas
  • Oracle Data Window perform routine database
    tasks like inserting and updating Oracle data or
    testing stored procedures
  • Designers and wizards -create and alter schema
    objects
  • Automatically generate code -drag and drop schema
    objects
  • PL/SQL Stored Procedure Create and Run Oracle
    stored procedures
  • PL/SQL editor IntelliSense, Integrated context
    sensitive online Oracle SQL and PL/SQL Users
    Guide Help

27
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle Explorer -browse Oracle schemas

28
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle Explorer
  • Demo

29
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle Data Window perform routine database
    tasks like inserting and updating Oracle data or
    testing stored procedures

30
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Oracle DataWindow
  • Demo

31
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Designers and Wizards-create and alter schema
    objects

32
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Designers and Wizards
  • Demo

33
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Drag-and-Drop automatically generate code -drag
    and drop schema objects

34
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Automatic Code Generation
  • Demo

35
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • PL/SQL Procedure Create and Run stored procedures

36
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • PL/SQL Procedure
  • Demo

37
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • PL/SQL editor IntelliSense and context sensitive
    help

38
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • IntelliSense
  • Demo

39
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

40
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Conclusion
  • As the Microsoft .NET platform gains popularity,
    Windows developers can utilize Oracle
    productivity tools in an integrated development
    environment that manages the repetitive elements
    of software development allowing developers to
    share services and focus on core business logic
    enhancements

41
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Introduction
  • Background
  • What is Microsoft .NET?
  • Microsoft Visual Studio .NET 2003
  • Microsoft .NET Framework 1.1
  • Microsoft .NET 1.1 Data Providers
  • Oracle Developer Tools for Visual Studio .NET
    2003
  • Conclusion
  • References and Links

42
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • References/links
  • Oracle Data Provider for .NET (ODP.NET)
  • http//www.oracle.com/technology/tech/dotnet
  • Oracle Developer Tools for Visual Studio .NET
  • http//www.oracle.com/technology/tech/dotnet/tools
  • ODT for VS .NET Discussion Forum on OTN
  • http//forums.oracle.com/forums/forum.jsp?forum22
    8

43
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • MSDN Articles Links (http//msdn.microsoft.com/)
  • Microsoft vs. Oracle ODP.NET
  • MSDN .NET Framework Developer Center
  • MSDN .NET Data Access Architecture Guide

44
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Microsoft .NET and Web Service Training
  • http//www.intertechtraining.com/
  • Dan Dahlin
  • 651-994-8558 ext. 22.
  • dan.dahlin_at_intertechtraining.com
  • Please mention that Kalvin Parman with Medtronic
    referred you?

45
Getting Started with Oracle Development using
Microsoft Visual Studio .NET 2003
  • Questions?
About PowerShow.com