rsa-dev / dotnet-db-samples

.NET code samples for Oracle database developers #OracleDotNet

Oracle .NET Code Sample Respository

About Oracle .NET

This repository provides .NET code samples for Oracle developers, specifically for Oracle Data Provider for .NET (ODP.NET) and other Oracle .NET components. .NET products for Oracle Database are free of charge. They consist of:

• Oracle Data Provider for .NET (ODP.NET) - an optimized ADO.NET data access provider to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and self-updating client caches. ODP.NET offers three provider types: Core for .NET (Core) runtimes, managed for .NET Framework (100% managed code and easy deployment), and unmanaged for .NET Framework.
• Oracle Developer Tools for Visual Studio - a tightly integrated design-time "Add-in" for Microsoft Visual Studio that provides full Oracle .NET application lifecycle management, including PL/SQL debugging and schema comparison tools.
• Oracle Developer Tools for VS Code - enables Visual Studio Code developers to connect to Oracle Database and Oracle Autonomous Database, edit SQL and PL/SQL with autocomplete, Intellisense, breadcrumbs, and syntax coloring, execute SQL and PL/SQL and view and save the results in formats such as .CSV and JSON. The Oracle Database Explorer tree control allows you to quickly explore your database schema, view table data, and edit, execute and save PL/SQL.
• Oracle Providers for ASP.NET - a collection of ASP.NET providers that use Oracle Database as the data source. ASP.NET applications can store various types of website state in an Oracle database, which can then be shared across the application.

Getting Started

Oracle .NET components are available individually on NuGet Gallery or bundled together as part of Oracle Data Access Components (ODAC). Provider downloads are available from NuGet Gallery and Oracle .NET download page. Oracle Developer Tools for VS Code or Visual Studio can be downloaded from the VS Code Marketplace or Visual Studio Marketplace, respectively.

Tutorials

For beginning Oracle .NET developers, these on-premises .NET database tutorials and Autonomous Database .NET tutorials will assist you in getting started with .NET application development with Oracle Database.

Oracle .NET video tutorials are available from the Oracle .NET YouTube site.

For those that want to build an end-to-end basic .NET web app for Oracle Database in the cloud, try the .NET Development with Oracle Autonomous Database Quick Start. The tutorial takes about an hour to complete and is free. By the end, you will have a complete running .NET website and database.

More Information

• Documentation
• Contibutions to code samples should review CONTRIBUTING for more details.
• You may use files in this repository only if in compliance with the LICENSE.
• More Oracle .NET development information can be found at the Oracle .NET Developer Center.

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide

Security

Please consult the security guide for our responsible security vulnerability disclosure process

License

Copyright (c) 2015, 2023 Oracle and/or its affiliates.

Released under the MIT License