CODEWITHSUNDEEP
nhibernatelinq-to-nhibernate
Mark
Mark

Reputation: 11

NHibernate 3 LINQ provider creates non-ansi join syntax

I'm pretty new to LINQ (and NHibernate's LINQ provider)

I have a query that joins 3 tables in a grandparent-parent-child using many-to-one mappings.

The actual SQL NHibernate is throwing out is using old-school FROM table1, table2, table3 join syntax.

Is there a way to make it use ANSI joins instead? (I see that using Fetch() will do this, but the syntax isn't exactly standard LINQ stuff)

Cheers, Mark

Upvotes: 1

Views: 352

Answers (1)

Diego Mijelshon
Diego Mijelshon

Reputation: 52735

No, it's not possible.

Keep in mind that, while the ANSI syntax is cleaner and allows for easier outer joins, it's semantically equivalent to the "old one" for inner joins, so you shouldn't care.

Upvotes: 1

Related Questions