I know how to implement a dialect I will rephrase my question. I am not looking for how to hook a custom dialect. I am looking to override the SqlSelectBuilder class Is there a place where we can hook this new SqlSelectBuilder?
On Tuesday, September 11, 2012 5:40:51 AM UTC-6, sbohlen wrote: > > You need to code and compile a completely different assembly representing > your new dialect with whatever changes you need and then use the > hibernate.cfg.xml value to specify it (see > http://www.nhforge.org/doc/nh/en/#configuration-optional-dialects for > more info). > > Steve Bohlen > [email protected] <javascript:> > http://blog.unhandled-exceptions.com > http://twitter.com/sbohlen > > > On Tue, Sep 11, 2012 at 2:26 AM, Ghassan Karwchan > <[email protected]<javascript:> > > wrote: > >> I am dealing with a proprietary database. >> It is ESRI's File Geodatabase (to whom might know it) >> There is an ADO.NET data provider for it, but this provider doesn't >> accept in sql statement aliases >> so the select should be "select field1, fielde2 from table1" >> it doesn't accept "select field1 as name1, field2 as name2 from table1 >> tab_name1" >> >> After I tried for a while with the Dialect, I am thinking my only >> solution is to override the SqlSelectBuilder >> Am I right? >> >> And in case I want to override this class, is there a way with NHibernate >> extension point to specify that I want to use this overridden one? >> where should I assign the new one? >> >> >> >
