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] http://blog.unhandled-exceptions.com http://twitter.com/sbohlen On Tue, Sep 11, 2012 at 2:26 AM, Ghassan Karwchan < [email protected]> 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? > > >
