public void ToHsqlProviderType()
{
Assert.AreEqual(HsqlProviderType.VarChar, HsqlConvert.ToHsqlProviderType(DbType.AnsiString));
Assert.AreEqual(HsqlProviderType.Char, HsqlConvert.ToHsqlProviderType(DbType.AnsiStringFixedLength));
Assert.AreEqual(HsqlProviderType.Binary, HsqlConvert.ToHsqlProviderType(DbType.Binary));
Assert.AreEqual(HsqlProviderType.Boolean, HsqlConvert.ToHsqlProviderType(DbType.Boolean));
Assert.AreEqual(HsqlProviderType.SmallInt, HsqlConvert.ToHsqlProviderType(DbType.Byte));
Assert.AreEqual(HsqlProviderType.Decimal, HsqlConvert.ToHsqlProviderType(DbType.Currency));
Assert.AreEqual(HsqlProviderType.TimeStamp, HsqlConvert.ToHsqlProviderType(DbType.Date));
Assert.AreEqual(HsqlProviderType.TimeStamp, HsqlConvert.ToHsqlProviderType(DbType.DateTime));
Assert.AreEqual(HsqlProviderType.TimeStamp, HsqlConvert.ToHsqlProviderType(DbType.DateTime2));
Assert.AreEqual(HsqlProviderType.Char, HsqlConvert.ToHsqlProviderType(DbType.DateTimeOffset));
Assert.AreEqual(HsqlProviderType.Decimal, HsqlConvert.ToHsqlProviderType(DbType.Decimal));
Assert.AreEqual(HsqlProviderType.Double, HsqlConvert.ToHsqlProviderType(DbType.Double));
Assert.AreEqual(HsqlProviderType.Binary, HsqlConvert.ToHsqlProviderType(DbType.Guid));
Assert.AreEqual(HsqlProviderType.SmallInt, HsqlConvert.ToHsqlProviderType(DbType.Int16));
Assert.AreEqual(HsqlProviderType.Integer, HsqlConvert.ToHsqlProviderType(DbType.Int32));
Assert.AreEqual(HsqlProviderType.BigInt, HsqlConvert.ToHsqlProviderType(DbType.Int64));
Assert.AreEqual(HsqlProviderType.Object, HsqlConvert.ToHsqlProviderType(DbType.Object));
Assert.AreEqual(HsqlProviderType.TinyInt, HsqlConvert.ToHsqlProviderType(DbType.SByte));
Assert.AreEqual(HsqlProviderType.Real, HsqlConvert.ToHsqlProviderType(DbType.Single));
Assert.AreEqual(HsqlProviderType.VarChar, HsqlConvert.ToHsqlProviderType(DbType.String));
Assert.AreEqual(HsqlProviderType.Char, HsqlConvert.ToHsqlProviderType(DbType.StringFixedLength));
Assert.AreEqual(HsqlProviderType.TimeStamp, HsqlConvert.ToHsqlProviderType(DbType.Time));
Assert.AreEqual(HsqlProviderType.Integer, HsqlConvert.ToHsqlProviderType(DbType.UInt16));
Assert.AreEqual(HsqlProviderType.BigInt, HsqlConvert.ToHsqlProviderType(DbType.UInt32));
Assert.AreEqual(HsqlProviderType.Numeric, HsqlConvert.ToHsqlProviderType(DbType.UInt64));
Assert.AreEqual(HsqlProviderType.Numeric, HsqlConvert.ToHsqlProviderType(DbType.VarNumeric));
Assert.AreEqual(HsqlProviderType.Xml, HsqlConvert.ToHsqlProviderType(DbType.Xml));
}
