Looks like I can't modify my message. To add I am using NH
v2.1.2.4000.

On Aug 20, 11:05 am, Mike <[email protected]> wrote:
> I created a custom dialect and told NH to use it. From there I
> registered a few keywords so I could use it with HQL.
>
> public class CustomDialect : Oracle10gDialect
> {
>         public CustomDialect()
>         {
>                 RegisterKeyword("start");
>                 RegisterKeyword("with");
>                 RegisterKeyword("connect");
>                 RegisterKeyword("by");
>                 RegisterKeyword("prior");
>         }
>
> }
>
> Here is the function in my repository responsible for using those
> keywords.
>
> public static IList<string> FindAll()
> {
>         ISession sesion = GetSession();
>
>         var q = sesion.CreateQuery(@"select nu.StationDesc from
> NormalUpstream nu
>                         start with nu.UpStationNumber = 'abc'
>                         connect by prior StationNumber = nu.UpStationNumber");
>
>         return q.List<string>();
>
> }
>
> That HQL only generated `select nu.StationDesc from NormalUpstream
> nu`.From that HQL, I would expect the SQL generated would include my
> new keywords.
>
> Why is NH ignoring my registered keywords?
>
> Thank you.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" 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/nhusers?hl=en.

Reply via email to