流畅的 nHibernate 和列函数 (Oracle)

发布于 2024-10-06 19:14:40 字数 1026 浏览 1 评论 0原文

我有以下 sql：

select  s.status_code_id, -- number(2)
        s.status.getStringVal(), --sys.xmltype
        s.description.getStringVal() --sys.xmltype
from schema2.table_status_code s

Tablestatuscode 表的 Fluent nHibernate 映射是

Table("table_status_code");
Schema("schema2");
Id(x => x.Id)
    .Column("STATUS_CODE_ID");
Map(x => x.Status)
    .Column("STATUS.getStringVal()");
Map(x => x.Description)
    .Column("Description.getStringVal()");

这不起作用。如何在 Fluent nHibernate 中使用 getStringVal() 函数？

这也不起作用：

Table("table_status_code");
Schema("schema2");
Id(x => x.Id)
    .Column("STATUS_CODE_ID");
Map(x => x.Status)
    .Formula("STATUS.getStringVal()");
Map(x => x.Description)
    .Formula("Description.getStringVal()");
HasMany(x => x.Evoluties)
    .Inverse();

因为生成的 sql 对于 Oracle 来说不正确。 Oracle 中必须有 tablename.columnname.getStringVal() 而不是 columnname.getStringVal()

谢谢，

Filip

原文

I've got the following sql:

select  s.status_code_id, -- number(2)
        s.status.getStringVal(), --sys.xmltype
        s.description.getStringVal() --sys.xmltype
from schema2.table_status_code s

The Fluent nHibernate map for the tablestatuscode table is

Table("table_status_code");
Schema("schema2");
Id(x => x.Id)
    .Column("STATUS_CODE_ID");
Map(x => x.Status)
    .Column("STATUS.getStringVal()");
Map(x => x.Description)
    .Column("Description.getStringVal()");

This doens't work. How can I use the getStringVal() function with Fluent nHibernate?

This doesn't work either:

Table("table_status_code");
Schema("schema2");
Id(x => x.Id)
    .Column("STATUS_CODE_ID");
Map(x => x.Status)
    .Formula("STATUS.getStringVal()");
Map(x => x.Description)
    .Formula("Description.getStringVal()");
HasMany(x => x.Evoluties)
    .Inverse();

because the generated sql isn't correct for oracle. You must have tablename.columnname.getStringVal() in Oracle and not columnname.getStringVal()

thanks,

Filip

分享到QQ

分享到微博