//-----------------------------------------------------------------------
// <copyright file="LocalDateTime2.cs" company="Able Solutions Corporation">
//     (c) 2018 Able Solutions Corporation. All rights reserved.
// </copyright>
//-----------------------------------------------------------------------

namespace CommerceBuilder.DomainModel
{
    using System.Data;
    using NHibernate.SqlTypes;

    /// <summary>
    /// Provides custom translation of DateTime, using UTC for database storage with
    /// in memory conversion to local time respecting the store timezone setting
    /// </summary>
    public class LocalDateTime2 : LocalDateTime
    {
        /// <summary>  
        /// Gets the SQL types for the columns mapped by this type.   
        /// </summary> 
        public override SqlType[] SqlTypes
        {
            get
            {
                // We store our datetime in a single column in the database that can contain a datetime2
                SqlType[] types = new SqlType[1];
                types[0] = new SqlType(DbType.DateTime2);
                return types;
            }
        }
    }
} 

public SqlType[] SqlTypes

public virtual SqlType[] SqlTypes

<property name="OrderDate" column="OrderDate" type="CommerceBuilder.DomainModel.LocalDateTime, CommerceBuilder" not-null="true" />

<property name="OrderDate" column="OrderDate" type="CommerceBuilder.DomainModel.LocalDateTime2, CommerceBuilder" not-null="true" />