The first half of this session introduces Oracle Database support for .NET, including Oracle Data Provider for .NET (ODP.NET) and Oracle Developer Tools for Visual Studio. We'll demonstrate how to use Oracle Database with Visual Studio for .NET development. The second half discusses recent and upcoming features in the most recent Oracle .NET releases, including Entity Framework 6 and Code First, Visual Studio 2013, fully-managed ODP.NET, Oracle Schema Comparison tools, and support for new Oracle Database 12c features, such as multitenant database administration from Visual Studio.
.NET and Oracle programmers frequently work with SQL and PL/SQL, whether that means setting up a call to a stored procedure from .NET code, writing and debugging PL/SQL stored procedure code, or generating deployment SQL scripts and checking them into source control. This session begins with coding tips and tricks for writing performant .NET code that leverages PL/SQL. Next, we demonstrate SQL and PL/SQL script creation, editing, debugging, source control management, and automated performance tuning of both the SQL as well as the .NET application as a whole. Finally, we show how to use the new Schema Compare tools which greatly assist developers during development and deployment.