you cannot embed the C# function into sql. what you can do is 1. implement the functionality within an HQL keyword for each database you support 2. load the results into memory and then perform the C# function on each object.
i'm not sure of the specifics, but I have seen other talk about this. this way your hql queries can reader "from entity where MyFunction(property) = x" you can then map MyFunction to driver specific sql statements so you may have 4 implementations (MS Sql, SQLite, Oracle & Postgres) but the HQL is DB agnostic. option 2 will work if the amount of objects returned from the database is a reasonable size. you wouldn't want to take this approach if you needed to load 1000s of entities. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/bq6aWRkobwIJ. 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.
