cast('字段名' as typ1)
其中typ1 类型为nhibernate定义的类型如string int
入校写法会报错
cast ("id" as char(20))
正确写法为 cast("id" as string)