public void MySQLNumericTypeTest()
{
MysqltypetestCollection datatypeTestColl = new MysqltypetestCollection();
Mysqltypetest datatypeTest = new Mysqltypetest();
// There is a bug in the 1.0.7 Connector/Net for unsigned types.
// It is fixed in 5.0.3.
switch (datatypeTestColl.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MySqlClientProvider":
using (esTransactionScope scope = new esTransactionScope())
{
datatypeTest.BigIntType = -1;
datatypeTest.BigIntUType = 1;
datatypeTest.DblType = -1;
datatypeTest.DblUType = 1;
datatypeTest.DecType = (decimal)(-1.5);
datatypeTest.DecUType = (decimal)(1.5);
datatypeTest.FloatType = (float)(-1.5);
datatypeTest.FloatUType = (float)(1.5);
datatypeTest.IntType = -1;
datatypeTest.IntUType = 1;
datatypeTest.MedIntType = -1;
datatypeTest.MedIntUType = 1;
datatypeTest.NumType = (decimal)(-1.5);
datatypeTest.NumUType = (decimal)(1.5);
datatypeTest.RealType = -1.5;
datatypeTest.RealUType = 1.5;
datatypeTest.SmallIntType = -1;
datatypeTest.SmallIntUType = 1;
datatypeTest.TinyIntType = (sbyte)(1);
datatypeTest.TinyIntUType = Convert.ToByte(1);
datatypeTest.Save();
int? tempKey = datatypeTest.Id;
Assert.IsTrue(datatypeTest.LoadByPrimaryKey(tempKey.Value));
datatypeTest.MarkAsDeleted();
datatypeTest.Save();
}
break;
default:
Assert.Ignore("MySQL only");
break;
}
}
public void MySQLNumericTypeTest()
{
MysqltypetestCollection datatypeTestColl = new MysqltypetestCollection();
Mysqltypetest datatypeTest = new Mysqltypetest();
// There is a bug in the 1.0.7 Connector/Net for unsigned types.
// It is fixed in 5.0.3.
switch (datatypeTestColl.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.MySqlClientProvider":
using (esTransactionScope scope = new esTransactionScope())
{
datatypeTest.BigIntType = -1;
datatypeTest.BigIntUType = 1;
datatypeTest.DblType = -1;
datatypeTest.DblUType = 1;
datatypeTest.DecType = (decimal)(-1.5);
datatypeTest.DecUType = (decimal)(1.5);
datatypeTest.FloatType = (float)(-1.5);
datatypeTest.FloatUType = (float)(1.5);
datatypeTest.IntType = -1;
datatypeTest.IntUType = 1;
datatypeTest.MedIntType = -1;
datatypeTest.MedIntUType = 1;
datatypeTest.NumType = (decimal)(-1.5);
datatypeTest.NumUType = (decimal)(1.5);
datatypeTest.RealType = -1.5;
datatypeTest.RealUType = 1.5;
datatypeTest.SmallIntType = -1;
datatypeTest.SmallIntUType = 1;
datatypeTest.TinyIntType = (sbyte)(1);
datatypeTest.TinyIntUType = Convert.ToByte(1);
datatypeTest.Save();
int?tempKey = datatypeTest.Id;
Assert.IsTrue(datatypeTest.LoadByPrimaryKey(tempKey.Value));
datatypeTest.MarkAsDeleted();
datatypeTest.Save();
}
break;
default:
Assert.Ignore("MySQL only");
break;
}
}
