--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/Linq/ConvertTest.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,532 @@
+using System;
+using System.Linq;
+
+using NUnit.Framework;
+
+using BLToolkit.Data.DataProvider;
+using BLToolkit.Data.Linq;
+
+namespace Data.Linq
+{
+	[TestFixture]
+	public class ConvertTest : TestBase
+	{
+		[Test]
+		public void Test1()
+		{
+			ForEachProvider(new[] { ProviderName.SQLite },
+				db => Assert.AreEqual(1, (from t in db.Types where t.MoneyValue * t.ID == 1.11m  select t).Single().ID));
+		}
+
+		#region Int
+
+		[Test]
+		public void ToInt1()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select              Sql.ConvertTo<int>.From(t.MoneyValue),
+				from t in db.Types select Sql.AsSql(Sql.ConvertTo<int>.From(t.MoneyValue))));
+		}
+
+		[Test]
+		public void ToInt2()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select              Sql.Convert<int,decimal>(t.MoneyValue),
+				from t in db.Types select Sql.AsSql(Sql.Convert<int,decimal>(t.MoneyValue))));
+		}
+
+		[Test]
+		public void ToBigInt()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.BigInt, t.MoneyValue),
+				from t in db.Types select Sql.Convert(Sql.BigInt, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToInt64()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select (Int64)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (Int64)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToInt64()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select Convert.ToInt64(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToInt64(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToInt()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.Int, t.MoneyValue),
+				from t in db.Types select Sql.Convert(Sql.Int, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToInt32()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (Int32)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (Int32)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToInt32()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToInt32(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToInt32(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToSmallInt()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.SmallInt, t.MoneyValue),
+				from t in db.Types select Sql.Convert(Sql.SmallInt, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToInt16()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (Int16)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (Int16)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToInt16()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToInt16(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToInt16(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToTinyInt()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.TinyInt, t.MoneyValue),
+				from t in db.Types select Sql.Convert(Sql.TinyInt, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToSByte()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (sbyte)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (sbyte)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToSByte()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToSByte(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToSByte(t.MoneyValue) where p > 0 select p));
+		}
+
+		#endregion
+
+		#region UInts
+
+		[Test]
+		public void ToUInt1()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from t in    Types select              Sql.ConvertTo<uint>.From(t.MoneyValue),
+				from t in db.Types select Sql.AsSql(Sql.ConvertTo<uint>.From(t.MoneyValue))));
+		}
+
+		[Test]
+		public void ToUInt2()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from t in    Types select              Sql.Convert<uint,decimal>(t.MoneyValue),
+				from t in db.Types select Sql.AsSql(Sql.Convert<uint,decimal>(t.MoneyValue))));
+		}
+
+		[Test]
+		public void ToUInt64()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select (UInt64)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (UInt64)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToUInt64()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select Convert.ToUInt64(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToUInt64(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToUInt32()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select (UInt32)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (UInt32)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToUInt32()
+		{
+			ForEachProvider(new[] { ProviderName.MySql }, db => AreEqual(
+				from p in from t in    Types select Convert.ToUInt32(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToUInt32(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToUInt16()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (UInt16)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (UInt16)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToUInt16()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToUInt16(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToUInt16(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToByte()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (byte)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (byte)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToByte([DataContexts] string context)
+		{
+			using (var db = GetDataContext(context))
+				AreEqual(
+					from p in from t in    Types select Convert.ToByte(t.MoneyValue) where p > 0 select p,
+					from p in from t in db.Types select Convert.ToByte(t.MoneyValue) where p > 0 select p);
+		}
+
+		#endregion
+
+		#region Floats
+
+		[Test]
+		public void ToDefaultDecimal()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DefaultDecimal, t.MoneyValue * 1000),
+				from t in db.Types select Sql.Convert(Sql.DefaultDecimal, t.MoneyValue * 1000)));
+		}
+
+		[Test]
+		public void ToDecimal1()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.Decimal(10), t.MoneyValue * 1000),
+				from t in db.Types select Sql.Convert(Sql.Decimal(10), t.MoneyValue * 1000)));
+		}
+
+		[Test]
+		public void ToDecimal2()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.Decimal(10,4), t.MoneyValue),
+				from t in db.Types select Sql.Convert(Sql.Decimal(10,4), t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToDecimal3()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (Decimal)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (Decimal)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToDecimal()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToDecimal(t.MoneyValue) where p > 0 select p,
+				from p in from t in db.Types select Convert.ToDecimal(t.MoneyValue) where p > 0 select p));
+		}
+
+		[Test]
+		public void ToMoney()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select (int)Sql.Convert(Sql.Money, t.MoneyValue),
+				from t in db.Types select (int)Sql.Convert(Sql.Money, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToSmallMoney()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select (decimal)Sql.Convert(Sql.SmallMoney, t.MoneyValue),
+				from t in db.Types select (decimal)Sql.Convert(Sql.SmallMoney, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToSqlFloat()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select (int)Sql.Convert(Sql.Float, t.MoneyValue),
+				from t in db.Types select (int)Sql.Convert(Sql.Float, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToDouble()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (int)(Double)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (int)(Double)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToDouble()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToDouble(t.MoneyValue) where p > 0 select (int)p,
+				from p in from t in db.Types select Convert.ToDouble(t.MoneyValue) where p > 0 select (int)p));
+		}
+
+		[Test]
+		public void ToSqlReal()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select (int)Sql.Convert(Sql.Real, t.MoneyValue),
+				from t in db.Types select (int)Sql.Convert(Sql.Real, t.MoneyValue)));
+		}
+
+		[Test]
+		public void ToSingle()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select (Single)t.MoneyValue where p > 0 select p,
+				from p in from t in db.Types select (Single)t.MoneyValue where p > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToSingle()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToSingle(t.MoneyValue) where p > 0 select (int)p,
+				from p in from t in db.Types select Convert.ToSingle(t.MoneyValue) where p > 0 select (int)p));
+		}
+
+		#endregion
+
+		#region DateTime
+
+		[Test]
+		public void ToSqlDateTime()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DateTime, t.DateTimeValue.Year + "-01-01 00:20:00"),
+				from t in db.Types select Sql.Convert(Sql.DateTime, t.DateTimeValue.Year + "-01-01 00:20:00")));
+		}
+
+		[Test]
+		public void ToSqlDateTime2()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DateTime2, t.DateTimeValue.Year + "-01-01 00:20:00"),
+				from t in db.Types select Sql.Convert(Sql.DateTime2, t.DateTimeValue.Year + "-01-01 00:20:00")));
+		}
+
+		[Test]
+		public void ToSqlSmallDateTime()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.SmallDateTime, t.DateTimeValue.Year + "-01-01 00:20:00"),
+				from t in db.Types select Sql.Convert(Sql.SmallDateTime, t.DateTimeValue.Year + "-01-01 00:20:00")));
+		}
+
+		[Test]
+		public void ToSqlDate()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.Date, t.DateTimeValue.Year + "-01-01"),
+				from t in db.Types select Sql.Convert(Sql.Date, t.DateTimeValue.Year + "-01-01")));
+		}
+
+		[Test]
+		public void ToSqlTime([DataContexts(ProviderName.SQLite)] string context)
+		{
+			using (var db = GetDataContext(context))
+				AreEqual(
+					from t in    Types select Sql.Convert(Sql.Time, t.DateTimeValue.Hour + ":01:01"),
+					from t in db.Types select Sql.Convert(Sql.Time, t.DateTimeValue.Hour + ":01:01"));
+		}
+
+		DateTime ToDateTime(DateTimeOffset dto)
+		{
+			return new DateTime(dto.Year, dto.Month, dto.Day, dto.Hour, dto.Minute, dto.Second);
+		}
+
+		[Test]
+		public void ToSqlDateTimeOffset()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select ToDateTime(Sql.Convert(Sql.DateTimeOffset, t.DateTimeValue.Year + "-01-01 00:20:00")),
+				from t in db.Types select ToDateTime(Sql.Convert(Sql.DateTimeOffset, t.DateTimeValue.Year + "-01-01 00:20:00"))));
+		}
+
+		[Test]
+		public void ToDateTime()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select DateTime.Parse(t.DateTimeValue.Year + "-01-01 00:00:00") where p.Day > 0 select p,
+				from p in from t in db.Types select DateTime.Parse(t.DateTimeValue.Year + "-01-01 00:00:00") where p.Day > 0 select p));
+		}
+
+		[Test]
+		public void ConvertToDateTime()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToDateTime(t.DateTimeValue.Year + "-01-01 00:00:00") where p.Day > 0 select p,
+				from p in from t in db.Types select Convert.ToDateTime(t.DateTimeValue.Year + "-01-01 00:00:00") where p.Day > 0 select p));
+		}
+
+		#endregion
+
+		#region String
+
+		[Test]
+		public void ToChar()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.Char(20), t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.Char(20), t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToDefaultChar()
+		{
+			ForEachProvider(new[] { "Oracle", "DevartOracle", ProviderName.Firebird, ProviderName.PostgreSQL }, db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DefaultChar, t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.DefaultChar, t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToVarChar()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.VarChar(20), t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.VarChar(20), t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToDefaultVarChar()
+		{
+			ForEachProvider(new[] { "Oracle", "DevartOracle", ProviderName.Firebird, ProviderName.PostgreSQL }, db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DefaultVarChar, t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.DefaultVarChar, t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToNChar()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.NChar(20), t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.NChar(20), t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToDefaultNChar()
+		{
+			ForEachProvider(new[] { "Oracle", "DevartOracle", ProviderName.Firebird, ProviderName.PostgreSQL }, db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DefaultNChar, t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.DefaultNChar, t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToNVarChar()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.NVarChar(20), t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.NVarChar(20), t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void ToDefaultNVarChar()
+		{
+			ForEachProvider(new[] { "Oracle", "DevartOracle", ProviderName.Firebird, ProviderName.PostgreSQL }, db => AreEqual(
+				from t in    Types select Sql.Convert(Sql.DefaultNVarChar, t.MoneyValue).Trim(' ', '0', '.'),
+				from t in db.Types select Sql.Convert(Sql.DefaultNVarChar, t.MoneyValue).Trim(' ', '0', '.')));
+		}
+
+		[Test]
+		public void DecimalToString()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToString(t.MoneyValue) where p.Length > 0 select p.Replace(',', '.').TrimEnd('0', '.'),
+				from p in from t in db.Types select Convert.ToString(t.MoneyValue) where p.Length > 0 select p.Replace(',', '.').TrimEnd('0', '.')));
+		}
+
+		[Test]
+		public void ByteToString()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select ((byte)t.ID).ToString() where p.Length > 0 select p,
+				from p in from t in db.Types select ((byte)t.ID).ToString() where p.Length > 0 select p));
+		}
+
+		[Test]
+		public void GuidToString()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in    Types where Sql.ConvertTo<string>.From(t.GuidValue) == "febe3eca-cb5f-40b2-ad39-2979d312afca" select t.GuidValue,
+				from t in db.Types where Sql.ConvertTo<string>.From(t.GuidValue) == "febe3eca-cb5f-40b2-ad39-2979d312afca" select t.GuidValue));
+		}
+
+		#endregion
+
+		#region Boolean
+
+		[Test]
+		public void ToBit1()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in from t in    Types where Sql.Convert(Sql.Bit, t.MoneyValue) select t select t,
+				from t in from t in db.Types where Sql.Convert(Sql.Bit, t.MoneyValue) select t select t));
+		}
+
+		[Test]
+		public void ToBit2()
+		{
+			ForEachProvider(db => AreEqual(
+				from t in from t in    Types where !Sql.Convert(Sql.Bit, t.MoneyValue - 4.5m) select t select t,
+				from t in from t in db.Types where !Sql.Convert(Sql.Bit, t.MoneyValue - 4.5m) select t select t));
+		}
+
+		[Test]
+		public void ConvertToBoolean1()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToBoolean(t.MoneyValue) where p == true select p,
+				from p in from t in db.Types select Convert.ToBoolean(t.MoneyValue) where p == true select p));
+		}
+
+		[Test]
+		public void ConvertToBoolean2()
+		{
+			ForEachProvider(db => AreEqual(
+				from p in from t in    Types select Convert.ToBoolean(t.MoneyValue - 4.5m) where !p select p,
+				from p in from t in db.Types select Convert.ToBoolean(t.MoneyValue - 4.5m) where !p select p));
+		}
+
+		#endregion
+	}
+}