Search code examples
oracle-databasenhibernatefluentora-00942

Fluent Nhibernate Oracle Identifier Too Long - Alias Name Issue

I've tried to do that. 

HasManyToMany<YechidotDoarInGroup>(x => x.Col_yig) 
  .Table("PigToYig") 
  .ChildKeyColumn("YIG_GROUP_RECID") 
 .ParentKeyColumn("PIG_GROUP_RECID");

but I've got:

ORA-00942: table or view does not exist

I am trying to establish HasManyToMany connection not by ID , but by some other property .

First I've got - too long message. When I've tried to enter my own Table name as an alias , it's not recognized. What should I do?

Solution

  • Define Table() method before all of your mapping declaration.

    public EmployeeMap : ClassMap<Employee>
{
    public EmployeeMap()
    {
        Table("EMPLOYEE");
        // your declaration
        Id(x => x.IdEmployee);        
    }
}