在 oracle 中的旧数据库上使用流畅的 Nhibernate

Question

我正在尝试使用 fluencemapping 连接到 oracle 中的现有数据库。 我得到了 映射客户

public CustomerMapping()
    {

         Not.LazyLoad();
        Id(x => x.Cst_Recid).GeneratedBy.Increment() ;
    }

，我正在尝试创建会话

public static ISessionFactory CreateSessionFactory()
    {
        return Fluently
            .Configure()
            .Database(OracleClientConfiguration.Oracle10.ConnectionString
            ("...."))
            .Mappings(m =>
             {
                 m.FluentMappings.AddFromAssemblyOf<CustomerMapping>();

             })
             .BuildConfiguration() 
             .BuildSessionFactory();
    }

我有一些试用课程来尝试创建 sessionFactory

public class MyDataProvider
{
    public static  Customer GetCustomerById(long customerId)
    {
        ISessionFactory sessionFactory = SessionFactory.CreateSessionFactory(); 
        ISession session = sessionFactory.OpenSession();
          return session.Linq<Customer>().Where(x => x.Cst_Recid.Equals(temp)).FirstOrDefault();

    }


}

即使我要打开会话并激活，我也无法通过 Id 获取客户...

测试非常简单- 仅检查选择活动

    [Test]
    public void CanGetCustomerById()
    {
        MyDataProvider provider = new MyDataProvider();
        Assert.AreEqual(33941, MyDataProvider.GetCustomerById(33941).Cst_Recid);

    }

是否存在错误 -

TestCase '...DataLayer.Tests.CustomerMappingTests.CanGetCustomerById' 失败：NHibernate.ADOException：无法执行查询 [ select * from ( SELECT this_.Cst_Recid as Cst1_0_0_, this_.Cst_Customerid as Cst2_0_0_, this_.Cst_First_Name as Cst3_0_0_, this_.Cst_Group_Recid as Cst4_0_0_, this_.Cst_Insdbdt as Cst5_0_0_, this_.Cst_Insdbuser as Cst6_0_ 0_, this_.Cst_Joingroup_Dt 为 Cst7_0_0_, this_. Cst_Last_Name 为 Cst8_0_0_，this_.Cst_Lastupddt 为 Cst9_0_0_，this_.Cst_Lastupduser 为 Cst10_0_0_，this_.Cst_Tat_Lakoach_Meshalem 为 Cst11_0_0_，this_.Cst_Typeid 为 Cst12_0_0_，this_.Cst_Tziyun_Meshalem_Rashi_仅作为 Cst13_0_0_，this_.Cst_Tziyun_Mizdamen 作为 Cst14_0_0_ 来自“客户”this_ WHERE this_.Cst_Recid = ： p0 ) 其中 rownum <=:p1 ] 位置参数：#0>33941 [SQL: select * from ( SELECT this_.Cst_Recid as Cst1_0_0_, this_.Cst_Customerid as Cst2_0_0_, this_.Cst_First_Name as Cst3_0_0_, this_.Cst_Group_Recid as Cst4_0_0_, this_.Cst_Insdbdt as Cst5_0_0_, this_.Cst_Insdbuser as Cst6_ 0_0_，this_.Cst_Joingroup_Dt 为 Cst7_0_0_， this_.Cst_Last_Name 为 Cst8_0_0_、this_.Cst_Lastupddt 为 Cst9_0_0_、this_.Cst_Lastupduser 为 Cst10_0_0_、this_.Cst_Tat_Lakoach_Meshalem 为 Cst11_0_0_、this_.Cst_Typeid 为 Cst12_0_0_、this_.Cst_Tziyun_Meshalem_ Rashi_Only 作为 Cst13_0_0_，this_.Cst_Tziyun_Mizdamen 作为 Cst14_0_0_ 来自“客户”this_ WHERE this_.Cst_Recid = :p0 ) 其中 rownum <=:p1] ----> System.Data.OracleClient.OracleException：ORA-00942：表或视图不存在，

他尝试运行的查询是由 FluentNHibernate 自动构建的。如果我删除引号，查询将正确执行，它会得到结果..问题是我无法根据需要更改查询..也许问题是我们正在使用 Oracle 11 g 和 FluentNhibernate 仅调整到 Oracle 9 或10？

将不胜感激任何帮助。

Answer 1

我之前的回答是不正确的。请允许我再试一次！

当您在 Oracle 中引用对象名称时，它会区分大小写。您的 CUSTOMER 表被引用为“Customer”，这与引用的“CUSTOMER”不同：

SQL> select * from "dual";
select * from "dual"
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from "Dual";
select * from "Dual"
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from "DUAL";

D
-
X

我仍然对 Fluid NHibernate 一无所知，但是是否有可能让它查找“CUSTOMER”表而不是“客户”表？

或者，如果没有其他东西在寻找 CUSTOMERS 表，您可以将其重命名为“Customers”...但是，这将破坏对 CUSTOMERS 表的引用：

SQL> create table CUSTOMERS (x int);

Table created.

SQL> insert into CUSTOMERS (x) values (1);

1 row created.

SQL> select * from CUSTOMERS;

         X
----------
         1

SQL> select * from "Customers";
select * from "Customers"
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from "CUSTOMERS";

         X
----------
         1

SQL> alter table CUSTOMERS rename to "Customers";

Table altered.

SQL> select * from CUSTOMERS;
select * from CUSTOMERS
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from "Customers";

         X
----------
         1

祝你好运！我希望这有帮助...