NHibernate mapping with getdate() sql function in where-attribute

Question

I have a mapping that retrieves all active roles for a user. I use the where attribute to filter out roles in the hbm mapping. The mapping look like this:

<map name="Bar" table="Foo_Bar" lazy="true" cascade="all" inverse="false" where="intGroupId Is Null And dtmExpires > getdate()">
<cache usage="read-write"/>
<key column="intUserId"/>
<index column="varRole" type="string"/>
<one-to-many class="Foo.Bar, Foo"/>
</map>

This works great in production on a SQL Server, but in my unit tests where I use SQLite the getdate() function isn't recognized.

How can I modify my mapping so it works in both MS SQL Server and SQLite, but still have the filter?

// Johan

AlexCuse · Accepted Answer · 2011-02-10 01:24:08Z

1

I don't know much about SQLite but you may be able to use

intGroupId Is Null And dtmExpires > CURRENT_TIMESTAMP

CURRENT_TIMESTAMP is the SQL Standard equivalent of getdate(), and I believe it is implemented in SQLite (and I'm positive it is in SQL Server).

You may be able to use the technique discussed here to tweak your mappings at runtime if this doesn't work.

answered Feb 10, 2011 at 1:24

AlexCuse

18.4k5 gold badges44 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NHibernate mapping with getdate() sql function in where-attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related