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?
