These OBEs cover content on .NET and Visual Studio 2013.
This content is intended for the following job role(s): Application Developer
Release Date: 28-AUG-2014
This tutorial covers how to use Entity Framework 5 or 6, Language Integrated Query (LINQ), and generate Data Definition Language (DDL) scripts using Model-First for Oracle database.
Duration: 30 minutes
This tutorial demonstrates how to use Entity Framework (EF) Code First with Oracle Data Provider for .NET (ODP.NET). You will create .NET classes in Entity Framework, which will then create Oracle database tables and add data to those tables. Lastly, you will modify those classes using Code First Migrations and propagate the changes so that they are reflected in the database tables.
Duration: 20 minutes
This tutorial describes how you can build a .NET application that uses the Oracle Data Provider for .NET to access data in an Oracle Database.
This tutorial describes how you can use SQL Tuning Advisor to tune ad-hoc SQL statements in Visual Studio. It also shows how you can use Oracle Performance Analyzer to tune your running application's use of the Oracle Database.
Duration: 65 minutes
This tutorial covers how to use Multitenant Container Databases in Visual Studio.
The Oracle Multitenant option is introduced in Oracle Database 12c Release 1 to enable an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to any Oracle client application as a non-CDB. Note that all Oracle database versions prior to Oracle Database 12c Release 1 (12.1) are known as non-CDBs.
Duration: 40 minutes
This tutorial describes how to download, install, and configure Oracle Data Provider for .NET (ODP.NET), Managed Driver and ODP.NET, Managed Entity Framework Driver using Microsoft NuGet.
Duration: 10 minutes
This tutorial describes how you can create applications that access Oracle user-defined types with .NET and Visual Studio.
User-defined types (UDTs) make it possible to model real-world entities such as "Customers" or "Purchase Orders" as objects in the Oracle Database. The Oracle Data Provider for .NET (ODP.NET), Unmanaged Driver supports UDTs, so that developers can access their objects, VARRAYs, and nested table types from C# or VB.NET code. Oracle Developer Tools for Visual Studio also supports UDTs, enabling you to use Visual Studio to create and modify object types and to autogenerate .NET code to access them.
In this tutorial, you will create an application that displays the contents of a relational table that has UDTs defined for some of the columns. You will create the type definition in Oracle using Visual Studio, create the relational table that contains the UDT, load data into the table, and then auto generate the .NET data access code for the application that will display the data.
Duration: 45 minutes
This tutorial describes how to build ODP.NET, Managed Driver applications. You will learn:
This tutorial covers developing WCF Data Services and Open Data Protocol (OData) applications for the Oracle Database using Visual Studio. You learn how to expose Oracle Database data via WCF Data Services and OData through Oracle's Entity Framework support.
This tutorial describes how you can build ASP.NET web applications that access Oracle Database using Oracle Developer Tools for Visual Studio.
This tutorial demonstrates Oracle Providers for ASP.NET usage and how tightly the providers integrate with existing ASP.NET management tools, controls, and services.
This tutorial describes how you can debug Oracle PL/SQL from Visual Studio.
The integrated PL/SQL debugger in Oracle Developer Tools (ODT) allows you to remain inside of Visual Studio for end-to-end debugging of your .NET and Oracle solution. You can debug PL/SQL code such as procedures and functions (both stand-alone and packaged), object methods, and triggers from within the Visual Studio environment in the same way as you would debug your C# or VB.NET code. With the ODT integrated PL/SQL debugger, you can use traditional debugging features such as setting break points, viewing and modifying variable values, and examining the call stack.
This tutorial teaches several coding techniques to enhance ODP.NET data access performance. These .NET techniques are exclusive for Oracle database development.
This tutorial introduces the Continuous Query Notification feature supported by the Oracle Data Provider for .NET and Oracle database.
This tutorial describes how to use the Schema Compare tool in Visual Studio 2013.
Schema Compare is an integrated tool that is included with the Oracle Developer Tools for Visual Studio (ODT). It is used to visually inspect the differences between a source and a target schema and to generate a diff script that modifies the target schema to make it identical to the source. The source and target schemas can reside on the same database or on two different databases.