public void CreateParametersTest()
{
using (var db = new DbManager())
{
var dt = new DataTypeTest
{
ID = 12345,
Binary_ = new byte[2] {
1, 2
},
#if !ORACLE
Boolean_ = true,
Guid_ = Guid.Empty,
#endif
Byte_ = 250,
Bytes_ = new byte[] { 2, 1 },
DateTime_ = DateTime.Now,
Decimal_ = 9876543210.0m,
Double_ = 12345.67890,
Int16_ = 12345,
Int32_ = 1234567890,
Int64_ = 1234567890123456789,
Money_ = 99876543210.0m,
Single_ = 1234.0f,
String_ = "Crazy Frog",
Char_ = 'F',
SByte_ = 123,
//UInt16_ = 65432,
//UInt32_ = 4000000000,
//UInt64_ = 12345678901234567890,
#if !SQLCE
Stream_ = new MemoryStream(5),
Xml_ = new XmlTextReader(new StringReader("<xml/>")),
#endif
};
var parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper <DataTypeTest> .Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper <DataTypeTest> .Instance)
{
#if FIREBIRD
if (mm.MemberName == "Stream_" || mm.MemberName == "Xml_")
{
continue;
}
#endif
var paramName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
var p = parameters.First(obj => obj.ParameterName == paramName);
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value, mm.MemberName);
}
}
}
public void GuidType()
{
using (testEntities context = new testEntities())
{
DataTypeTest dtt = context.DataTypeTests.First();
string guidAsChar = dtt.idAsChar;
Assert.Equal(0, String.Compare(guidAsChar, dtt.id.ToString(), true));
Assert.Equal(0, String.Compare(guidAsChar, dtt.id2.ToString(), true));
}
}
public void CreateParametersTest()
{
using (DbManager db = new DbManager())
{
DataTypeTest dt = new DataTypeTest();
dt.ID = 12345;
dt.Binary_ = new byte[2] {
1, 2
};
#if !ORACLE
dt.Boolean_ = true;
dt.Guid_ = Guid.Empty;
#endif
dt.Byte_ = 250;
dt.Bytes_ = new byte[2] {
2, 1
};
dt.DateTime_ = DateTime.Now;
dt.Decimal_ = 9876543210.0m;
dt.Double_ = 12345.67890;
dt.Int16_ = 12345;
dt.Int32_ = 1234567890;
dt.Int64_ = 1234567890123456789;
dt.Money_ = 99876543210.0m;
dt.Single_ = 1234.0f;
dt.String_ = "Crazy Frog";
dt.Char_ = 'F';
dt.SByte_ = 123;
dt.UInt16_ = 65432;
dt.UInt32_ = 4000000000;
dt.UInt64_ = 12345678901234567890;
#if !SQLCE
dt.Stream_ = new MemoryStream(5);
dt.Xml_ = new XmlTextReader(new StringReader("<xml/>"));
dt.XmlDoc_ = new XmlDocument(); dt.XmlDoc_.LoadXml("<xmldoc/>");
#endif
IDbDataParameter[] parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper <DataTypeTest> .Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper <DataTypeTest> .Instance)
{
string paramName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
IDbDataParameter p = Array.Find(parameters,
delegate(IDbDataParameter obj) { return(obj.ParameterName == paramName); });
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value);
}
}
}
public void ExecuteObject2()
{
using (DbManager db = new DbManager())
{
DataTypeTest dt = (DataTypeTest)db
.SetCommand("SELECT * FROM DataTypeTest WHERE DataTypeID = " + db.DataProvider.Convert("id", ConvertType.NameToQueryParameter),
db.Parameter("id", 2))
.ExecuteObject(typeof(DataTypeTest));
TypeAccessor.WriteConsole(dt);
}
}
public void NullableTest2(Func <DbManager, DataTypeTest, int> insert, string config)
{
using (var db = new TestDbManager(config))
{
var data = new DataTypeTest()
{
Byte_ = 0,
Int16_ = 0,
Int32_ = 0,
Int64_ = 0,
UInt16_ = 0,
UInt32_ = 0,
UInt64_ = 0,
Decimal_ = 0,
Double_ = 0,
Money_ = 0,
Single_ = 0,
SByte_ = 0,
};
var id = insert(db, data);
var list = db.GetTable <DataTypeTest>().Where(_ => _.DataTypeID >= id).ToList();
var i = 0;
foreach (var d2 in list)
{
Console.WriteLine("Iteration: " + i++);
Assert.IsNotNull(d2.Byte_);
Assert.IsNotNull(d2.Decimal_);
Assert.IsNotNull(d2.Double_);
Assert.IsNotNull(d2.Int16_);
Assert.IsNotNull(d2.Int32_);
Assert.IsNotNull(d2.Int64_);
Assert.IsNotNull(d2.Money_);
Assert.IsNotNull(d2.Single_);
Assert.IsNotNull(d2.SByte_);
Assert.IsNotNull(d2.UInt16_);
Assert.IsNotNull(d2.UInt32_);
Assert.IsNotNull(d2.UInt64_);
}
db.GetTable <SmallDataTypeTest>().Delete(_ => _.DataTypeID > 2);
}
}
/// <summary>
/// There are no comments for DataTypeTests in the schema.
/// </summary>
public void AddToDataTypeTests(DataTypeTest dataTypeTest)
{
base.AddObject("DataTypeTests", dataTypeTest);
}
/// <summary>
/// Create a new DataTypeTest object.
/// </summary>
/// <param name="id">Initial value of id.</param>
/// <param name="id2">Initial value of id2.</param>
public static DataTypeTest CreateDataTypeTest(global::System.Guid id, global::System.Guid id2)
{
DataTypeTest dataTypeTest = new DataTypeTest();
dataTypeTest.id = id;
dataTypeTest.id2 = id2;
return dataTypeTest;
}
public void CreateParametersTest()
{
using (var db = new DbManager())
{
var dt = new DataTypeTest
{
ID = 12345,
Binary_ = new byte[2] {1, 2},
#if !ORACLE
Boolean_ = true,
Guid_ = Guid.Empty,
#endif
Byte_ = 250,
Bytes_ = new byte[] { 2, 1 },
DateTime_ = DateTime.Now,
Decimal_ = 9876543210.0m,
Double_ = 12345.67890,
Int16_ = 12345,
Int32_ = 1234567890,
Int64_ = 1234567890123456789,
Money_ = 99876543210.0m,
Single_ = 1234.0f,
String_ = "Crazy Frog",
Char_ = 'F',
SByte_ = 123,
//UInt16_ = 65432,
//UInt32_ = 4000000000,
//UInt64_ = 12345678901234567890,
#if !SQLCE
Stream_ = new MemoryStream(5),
Xml_ = new XmlTextReader(new StringReader("<xml/>")),
#endif
};
var parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper<DataTypeTest>.Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper<DataTypeTest>.Instance)
{
var paramName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
var p = parameters.First(obj => obj.ParameterName == paramName);
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value, mm.MemberName);
}
}
}
public void CreateParametersTest()
{
using (DbManager db = new DbManager())
{
DataTypeTest dt = new DataTypeTest();
dt.ID = 12345;
dt.Binary_ = new byte[2] {1, 2};
#if !ORACLE
dt.Boolean_ = true;
dt.Guid_ = Guid.Empty;
#endif
dt.Byte_ = 250;
dt.Bytes_ = new byte[2] {2, 1};
dt.DateTime_ = DateTime.Now;
dt.Decimal_ = 9876543210.0m;
dt.Double_ = 12345.67890;
dt.Int16_ = 12345;
dt.Int32_ = 1234567890;
dt.Int64_ = 1234567890123456789;
dt.Money_ = 99876543210.0m;
dt.Single_ = 1234.0f;
dt.String_ = "Crazy Frog";
dt.Char_ = 'F';
dt.SByte_ = 123;
dt.UInt16_ = 65432;
dt.UInt32_ = 4000000000;
dt.UInt64_ = 12345678901234567890;
#if !SQLCE
dt.Stream_ = new MemoryStream(5);
dt.Xml_ = new XmlTextReader(new StringReader("<xml/>"));
dt.XmlDoc_ = new XmlDocument(); dt.XmlDoc_.LoadXml("<xmldoc/>");
#endif
IDbDataParameter[] parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper<DataTypeTest>.Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper<DataTypeTest>.Instance)
{
string paramName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
IDbDataParameter p = Array.Find(parameters,
delegate(IDbDataParameter obj) { return obj.ParameterName == paramName; });
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value);
}
}
}
