I just shortened my Entity Files names so that the combination is less than 30 letters , but I don't think that it is a good solution . No real alias table issue solution was found.
On Jan 24, 1:11 pm, Gregory Kaidanov <[email protected]> wrote: > well , 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? > > On Jan 21, 9:30 pm, Hudson Akridge <[email protected]> wrote: > > > > > HasManyToMany().AsBag().Table("ShorterJoinTableName"); > > > If you're talking about the aliases that are used whenever sql is executed, > > that's an NHibernate question and you should probably repost your question > > over to the nhusers google group. FNH doesn't have any control (that I'm > > think of at least) over the alias names used for association joins. > > > If you're talking an alias in a query, you can alias joins in a criteria or > > HQL query by using the "AS" keyword. > > > On Thu, Jan 21, 2010 at 1:10 PM, sternr <[email protected]> wrote: > > > I've got a very long table names, and since the alias FNH creates for > > > a join is the name of both the tables, my DataBase (Oracle) gives me: > > > "Identifier Too Long". > > > > Is there a way to control the Alias names FNH gives my tables\joins? > > > If not, is there any other solution? (considering its a legacy > > > Database...) > > > > Thanks ahead, > > > > --sternr > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Fluent NHibernate" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<fluent-nhibernate%2Bunsubscr > > > [email protected]> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/fluent-nhibernate?hl=en. > > > -- > > - Hudsonhttp://www.bestguesstheory.comhttp://twitter.com/HudsonAkridge -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.
