当前位置：Gxlcms > 数据库问题 > abp 连接oracle数据库

abp 连接oracle数据库

时间：2021-07-01 10:21:17 帮助过：33人阅读

override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.HasDefaultSchema("ORCL");//一定要大写 base.OnModelCreating(modelBuilder); }

4.修改**Web 下的web.config　　

<span style="color: #0000ff"><</span><span style="color: #800000">oracle.manageddataaccess.client</span><span style="color: #0000ff">></span>
    <span style="color: #0000ff"><</span><span style="color: #800000">version </span><span style="color: #ff0000">number</span><span style="color: #0000ff">="*"</span><span style="color: #0000ff">></span>
      <span style="color: #0000ff"><</span><span style="color: #800000">dataSources</span><span style="color: #0000ff">></span>
        <span style="color: #0000ff"><</span><span style="color: #800000">dataSource </span><span style="color: #ff0000">alias</span><span style="color: #0000ff">="ORCL"</span><span style="color: #ff0000"> descriptor</span><span style="color: #0000ff">="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) "</span> <span style="color: #0000ff">/></span>
      <span style="color: #0000ff"></</span><span style="color: #800000">dataSources</span><span style="color: #0000ff">></span>
    <span style="color: #0000ff"></</span><span style="color: #800000">version</span><span style="color: #0000ff">></span>
  <span style="color: #0000ff"></</span><span style="color: #800000">oracle.manageddataaccess.client</span><span style="color: #0000ff">></span>

 <span style="color: #0000ff"><</span><span style="color: #800000">connectionStrings</span><span style="color: #0000ff">></span>   
    <span style="color: #0000ff"><</span><span style="color: #800000">add </span><span style="color: #ff0000">name</span><span style="color: #0000ff">="Default"</span><span style="color: #ff0000"> providerName</span><span style="color: #0000ff">="Oracle.ManagedDataAccess.Client"</span><span style="color: #ff0000"> connectionString</span><span style="color: #0000ff">="User Id=ORCL;Password=ORCL;Data Source=ORCL;Persist Security Info=true "</span> <span style="color: #0000ff">/></span>
  <span style="color: #0000ff"></</span><span style="color: #800000">connectionStrings</span><span style="color: #0000ff">></span>

5.程序包管理控制台

5.1默认项目选项选择**EntityFramework

5.2 执行Add-Migration 命令

5.3 执行update-database命令

注：遇到的一个坑，没做好上述步骤之前，执行了nuget命令，导致生成了sqlerver的资源文件，所以一直报没有dbo用户的错

abp 连接oracle数据库

标签：res default .config ring class conf number uil entity

abp 连接oracle数据库

人气教程排行