Oracle ASP.NET Google (edit)

How to use OracleMembershipProvider in ASP.NET MVC Application​

c# - oracle database connection in web.config asp.net - Stack Overflow

NuGet Gallery | Oracle.Web 21.5.0

ASP.NET Membership Management Tool

sthakuri/ASP.NET-Membership-Management-tool: ASP.NET Membership Management Tool (github.com)

Oracle Data Access Components (ODAC)

Oracle Developer Tools for Visual Studio

Oracle Data Provider for .NET (ODP.NET)

oracle/dotnet-db-samples: .NET code samples for Oracle database developers (github.com)

Overview of Oracle Providers for ASP.NET

Oracle Providers for ASP.NET offer ASP.NET developers an easy to use method to store application state common to web applications (such as web user information, shopping carts) within an Oracle database. These providers are modeled on existing Microsoft ASP.NET providers, sharing similar schema and programming interfaces to provide .NET developers a familiar interface.

Oracle supports the following providers:

  • Membership Provider

  • Role Provider

  • Site Map Provider

  • Session State Provider

  • Profile Provider

  • Web Events Provider

  • Web Parts Personalization Provider

  • Cache Dependency Provider

Each ASP.NET provider can be used individually or in combination with other Oracle ASP.NET providers for your web site. Each of them store a specific set of web site information.

Oracle Providers for ASP.NET classes, their use, installation, and requirements are described in Oracle Providers for ASP.NET Developer's Guide, which is also provided as dynamic help.

Oracle Providers for ASP.NET Installation

Configuring Oracle Providers for ASP.NET Individually

Applications may not require all Oracle Providers for ASP.NET. Providers can be set up individually. Except for the Oracle Session State Provider and Oracle Cache Dependency Provider, the following install script must be executed before any other install scripts. Then, for each Oracle Provider for ASP.NET, a SQL script specific for that provider must be executed (in any order).

These install scripts are found in the ORACLE_BASE\ORACLE_HOME\ASP.NET\sql directory.

Table 1-2 Provider Installation Scripts

Provider Required Installation Script

Oracle Membership Provider

InstallOracleMembership.sql

Oracle Personalization Provider

InstallOraclePersonalization.sql

Oracle Profile Provider

InstallOracleProfile.sql

Oracle Role Provider

InstallOracleRoles.sql

Oracle Session State Provider

For Oracle Database 10g Release 1 and later InstallOracleSessionState.sql

For Oracle Database 9i Release 2 InstallOracleSessionState92.sql

There are correspondingly named uninstall scripts for these install scripts.

Note: This provider only requires the execution of the appropriate provider-specific .sql script as listed. It does not require the execution of InstallOracleASPNETCommon.sql.

Oracle Site Map Provider

InstallOracleSiteMap.sql

Oracle Web Events Provider

InstallOracleWebEvents.sql

Oracle Cache Dependency Provider

No script execution needed

General Setup Information

Once InstallOracleASPNETCommon.sql runs and calls the individual installation scripts, the installation scripts, in turn, execute corresponding .plb scripts, which create the stored procedures and functions. The installation .sql scripts must execute where the .plb file can be accessed.

Each provider also provides corresponding uninstall scripts to remove database objects that were created from the install scripts. These scripts are prefixed with the word Uninstall.

ASP.NET Client Setup

Installation configures the machine.config file to enable Oracle Providers for ASP.NET systemwide. Users can use the ORACLE_BASE\ORACLE_HOME\ASP.NET\Bin\2.x\OraProvCfg utility to configure the provider-specific entry in the machine.config file as follows:

  • To display the OraProvCfg utility help:

    OraProvCfg -help

  • To add Oracle Providers for ASP.NET-specific entries to the machine.config file:

     OraProvCfg  /action:config  /product:aspnet  /component:all
             /frameworkversion:v2.0.50727
             /providerpath:c:\Oracle\odp.net\bin\2.x\Oracle.Web.dll

    Where Framework version and Provider path (especially) may need to change accordingly.

  • To remove the Oracle Providers for ASP.NET-specific entries from the machine.config file:

    OraProvCfg  /action:unconfig  /product:aspnet  /component:all
            /frameworkversion:v2.0.50727

Where Framework version may need to change accordingly.

After installation, developers must provide the connection information to the database schema that stores and retrieves the ASP.NET state information. This step requires developers to supply the User Id, Password, Data Source, and other connection string information if necessary. In the machine.config file, developers can provide an entry similar to the example below.

<connectionStrings>
<add name="OraAspNetConString" connectionString="User Id=aspnet;Password=aspnet;Data Source=oracle; " />
</connectionStrings>

Optionally, developers can customize the properties of each ASP.NET provider from within the <system.web> section of the machine.config.

While Oracle Universal Installer automatically configures the machine.config, developers can apply more fine grained application-level control over the Oracle Providers for ASP.NET by using the web.config file. This file overrides entries from the machine.config file, but only for the specific web application it is a part of. Developers can set up their web.config file with the same XML syntax as the machine.config file.

Oracle.DataAccess.Client

Web.config file for EPiServer 6.0.530.0 for IIS6 and Visual Studio development server (github.com)

OracleMembershipProvider

Managing Users by Using Membership | Microsoft Docs

OracleMembershipProvider

Migrate ASP.NET to Google Cloud Platform

Its show how to migrate existing legacy .NET application to Google Cloud Platform.

dotnet-docs-samples/applications/liftAndShiftPetshop at main · GoogleCloudPlatform/dotnet-docs-samples (github.com)

ASP.NET Membership and Role Provider using Oracle database

We all know that in ASP.NET 2.0 there are Built-In Providers to help developers to build a robust application.

  • Membership
  • Role management
  • Site map
  • Profile
  • Session state
  • Web events
  • Web Parts personalization
  • Protected configuration

What i want to write here is about Membership Provider and Role Provider,

Membership
System.Web.Security.ActiveDirectoryMembershipProvider
System.Web.Security.SqlMembershipProvider

Role management
System.Web.Security.AuthorizationStoreRoleProvider
System.Web.Security.SqlRoleProvider
System.Web.Security.WindowsTokenRoleProvider