SubSonic 2.1 和 Oracle 问题 [英] SubSonic 2.1 and Oracle problems

问题描述

如果有人知道答案，我还在寻找 3 天，什么都没有..

Please if anyone knows the answer, I´m still looking for 3 days and nothing..

我使用 subsonic、SqlServer 和 MySql 进行了一些测试，并在 web.config 文件中进行了一些小改动，一切都很好.

I make some test with subsonic, SqlServer and MySql and with some little changes in the web.config file everything was good.

但是现在，我需要使用 Oracle .我进行了更改并运行了下一个命令

But now, I need to work with Oracle . I maked the changes and next command runs

DataTable qry = ModeloDados.DB.Select().From("CARGO").ExecuteDataSet().Tables[0];

但如果我输入 ModeloDados. 类不会出现.Ony出现下一个:

But if i type the ModeloDados. the class doesn´t appear. Ony appear the next :

数据库、架构、SP、表、视图

使用 SqlServer 或 MySql 一切都很好. Cargo 类出现了.我认为这不是 Oracle 中的配置，因为上面的命令运行，但我需要使用该类

With the SqlServer or MySql everything is good.The class Cargo appear. I think it´s not configuration in the Oracle because the above command runs, but i need to work with the class

有些像Cargo c = new Cargo

但是类没有出现.

我遗漏了什么?

感谢您的帮助.

配置:

<connectionStrings>
    <add name="oracle" connectionString="Data Source=xxx.x.xx.xx:1521/bancoteste;Persist Security Info=True;User ID=user;Password=xxx;" providerName="System.Data.OracleClient"/>
</connectionStrings>


<SubSonicService defaultProvider="oracle" enableTrace="false" templateDirectory="">
    <providers>
        <clear/>
        <add name="oracle" type="SubSonic.oracleDataProvider, SubSonic" 
           fixDatabaseObjectCasing="true" 
           connectionStringName="oracle" 
           generateRelatedTablesAsProperties="true" 
           fixPluralClassNames="false" 
           generatedNamespace="ModeloDados" 
           regexIgnoreCase="true" 
           removeUnderscores="false" 
           setPropertyDefaultsFromDatabase="true" 
           generateNullableProperties="true" 
           useExtendedProperties="true" useUtc="true"/>
    </providers>
</SubSonicService>


    <compilation debug="true">
        <buildProviders>
            <add extension=".abp" type="SubSonic.BuildProvider, SubSonic"/>

推荐答案

我的猜测是构建提供程序针对 Oracle 运行时出现错误.

My guess is that there are errors when the build provider runs against Oracle.

您需要找到那些，也许通过使用 SubCommander 进行构建.我已经很长时间没有使用构建提供程序了，但是如果没记错的话，将错误放入可以看到它们的 Visual Studio 中并不是那么好.

You'll need to hunt those down, perhaps by doing a build with SubCommander instead. I haven't used the build provider in a long time, but if memory serves, it's not that great at putting the errors into visual studio where you can see them.

这篇关于SubSonic 2.1 和 Oracle 问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！