DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use NopCommerce with Database Oracle

jPcSMay 20 2015 — edited May 20 2015

Hello I ask for help and I want to implement the Nop-commerce platform, but with connection to my oracle database searching the internet basing on a post where it was set up to MySql i create two classes:

the solution is in asp.mvc

mainly concerns me is that it fails to identify the provider of oracle so I appreciate all the help

------------------------- OracleConnectionFactory :-------------class

OracleConnectionFactory :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.Entity.Infrastructure;

using System.Data.Common;

using Oracle.ManagedDataAccess.Client;

namespace Nop.Data

{

public sealed class OracleConnectionFactory : IDbConnectionFactory

{

private readonly string _baseConnectionString;

private Func<string, DbProviderFactory> _providerFactoryCreator;

public OracleConnectionFactory()

{

}

public OracleConnectionFactory(string baseConnectionString)

{

this._baseConnectionString = baseConnectionString;

}

public DbConnection CreateConnection(string nameOrConnectionString)

{

string connectionString = nameOrConnectionString;

bool treatAsConnectionString = nameOrConnectionString.IndexOf('=') >= 0;

if (!treatAsConnectionString)

{

OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder(this.BaseConnectionString);

connectionString = builder.ConnectionString;

}

DbConnection connection = null;

try

{

connection = this.ProviderFactory("ODP.NET, Managed Driver").CreateConnection();

//var factory = DbProviderFactories.GetFactory("ODP.NET, Managed Driver");

//var conn = factory.CreateConnection();

//onnection = conn;

connection.ConnectionString = connectionString;

}

catch (Exception)

{

connection = new OracleConnection(connectionString);

}

return connection;

}

public string BaseConnectionString

{

get

{

return this._baseConnectionString;

}

internal Func<string, DbProviderFactory> ProviderFactory

{

get

{

Func<string, DbProviderFactory> func1 = this._providerFactoryCreator;

return delegate(string name)

{

return DbProviderFactories.GetFactory(name);

};

}

set

{

this._providerFactoryCreator = value;

}

And------------------------- OracleProvider:-------------class

using System;

using System.Collections.Generic;

using System.Data.Common;

using System.Data.Entity;

using System.Data.Entity.Infrastructure;

using System.Data.SqlClient;

using System.IO;

using System.Text;

using System.Web.Hosting;

using Nop.Data.Initializers;

using Nop.Core.Data;

using Oracle.ManagedDataAccess.Client;

namespace Nop.Data

{

public class OracleDataProvider : IDataProvider

{

#region utilities

protected virtual string[] ParseCommands(string filePath, bool throwExceptionIfNonExists)

{

if (!File.Exists(filePath))

{

if (throwExceptionIfNonExists)

throw new ArgumentException(string.Format("Specified file doesn't exist - {0}", filePath));

return new string[0];

}

var statements = new List<string>();

using (var stream = File.OpenRead(filePath))

using (var reader = new StreamReader(stream))

{

string statement;

while ((statement = ReadNextStatementFromStream(reader)) != null)

{

statements.Add(statement);

}

return statements.ToArray();

}

protected virtual string ReadNextStatementFromStream(StreamReader reader)

{

var sb = new StringBuilder();

string lineOfText;

while (true)

{

lineOfText = reader.ReadLine();

if (lineOfText == null)

{

if (sb.Length > 0)

return sb.ToString();

else

return null;

}

//MySql doesn't support GO, so just use a commented out GO as the separator

if (lineOfText.TrimEnd().ToUpper() == "-- GO")

break;

sb.Append(lineOfText + Environment.NewLine);

}

return sb.ToString();

}

#endregion

#region Methods

/// <summary>

/// Initialize connection factory

/// </summary>

public virtual void InitConnectionFactory()

{

//var connectionFactory = new SqlConnectionFactory();

var connectionFactory = new OracleConnectionFactory("OracleDbContext");

//TODO fix compilation warning (below)

#pragma warning disable 0618

Database.DefaultConnectionFactory = connectionFactory;

}

/// <summary>

/// Initialize database

/// </summary>

public virtual void InitDatabase()

{

InitConnectionFactory();

SetDatabaseInitializer();

}

/// <summary>

/// Set database initializer

/// </summary>

public virtual void SetDatabaseInitializer()

{

//pass some table names to ensure that we have nopCommerce 2.X installed

var tablesToValidate = new[] { "Customer", "Discount", "Order", "Product", "ShoppingCartItem" };

//custom commands (stored proedures, indexes)

var customCommands = new List<string>();

//use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests

//customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/Install/SqlServer.Indexes.sql"), false));

//use webHelper.MapPath instead of HostingEnvironment.MapPath which is not available in unit tests

//customCommands.AddRange(ParseCommands(HostingEnvironment.MapPath("~/App_Data/Install/SqlServer.StoredProcedures.sql"), false));

var initializer = new CreateTablesIfNotExist<NopObjectContext>(tablesToValidate, customCommands.ToArray());

Database.SetInitializer(initializer);

}

/// <summary>

/// A value indicating whether this data provider supports stored procedures

/// </summary>

public virtual bool StoredProceduredSupported

{

get { return true; }

}

/// <summary>

/// Gets a support database parameter object (used by stored procedures)

/// </summary>

/// <returns>Parameter</returns>

public virtual DbParameter GetParameter()

{

//return new SqlParameter();

return new OracleParameter();

}

#endregion

}

--------------------------- web.config /////////////////////////////////////////

<?xml version="1.0" encoding="utf-8"?>

<!--

For more information on how to configure your ASP.NET application, please visit

http://go.microsoft.com/fwlink/?LinkId=152368

-->

</configSections>

</NopConfig>

</plugins>

</resizer>

</appSettings>

<system.web>

</customErrors>

</authentication>

<pages>

</namespaces>

</pages>

</system.web>

<system.webServer>

<!-- <remove name="UrlRoutingModule-4.0" />

</modules>

</staticContent>

</handlers>

</system.webServer>

<system.serviceModel>

</system.serviceModel>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</assemblyBinding>

</runtime>

<system.data>

</DbProviderFactories>

</system.data>

</providers>

</entityFramework>

<oracle.manageddataaccess.client>

</dataSources>

</version>

</oracle.manageddataaccess.client>

</connectionStrings>

</configuration>

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2015

Added on May 20 2015

#oracle-providers-for-asp-net, #windows-and-net

0 comments

2,326 views