Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

Question

I have a table with a time column in my SQL Server 2008 database.

The property of the object I'm trying to map to is a TimeSpan.

How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems?

Answer 1

This is working for me:

Map(x => x.TimeFrom)
    .CustomType("TimeAsTimeSpan");