public void ExecuteObject2Sql()
{
using (DbManager db = new DbManager())
{
DataTypeSqlTest dt = (DataTypeSqlTest)db
.SetCommand("SELECT * FROM DataTypeTest WHERE DataTypeID = " + db.DataProvider.Convert("id", ConvertType.NameToQueryParameter),
db.Parameter("id", 2))
.ExecuteObject(typeof(DataTypeSqlTest));
TypeAccessor.WriteConsole(dt);
}
}
public void CreateParametersSqlTest()
{
using (DbManager db = new DbManager())
{
DataTypeSqlTest dt = new DataTypeSqlTest();
dt.ID = 12345;
dt.Binary_ = new SqlBinary(new byte[2] {
1, 2
});
dt.Boolean_ = new SqlBoolean(1);
dt.Byte_ = new SqlByte(250);
dt.DateTime_ = new SqlDateTime(DateTime.Now);
dt.Decimal_ = new SqlDecimal(9876543210.0m);
dt.Double_ = new SqlDouble(12345.67890);
dt.Guid_ = new SqlGuid(Guid.Empty);
dt.Int16_ = new SqlInt16(12345);
dt.Int32_ = new SqlInt32(1234567890);
dt.Int64_ = new SqlInt64(1234567890123456789);
dt.Money_ = new SqlMoney(99876543210.0m);
dt.Single_ = new SqlSingle(1234.0f);
dt.String_ = new SqlString("Crazy Frog");
#if !SQLCE
dt.Bytes_ = new SqlBytes(new byte[2] {
2, 1
});
dt.Chars_ = new SqlChars(new char[2] {
'B', 'L'
});
dt.Xml_ = new SqlXml(new XmlTextReader(new StringReader("<xml/>")));
#endif
var parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper <DataTypeSqlTest> .Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper <DataTypeSqlTest> .Instance)
{
var pName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
var p = Array.Find(parameters, obj => obj.ParameterName == pName);
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value);
}
}
}
public void CreateParametersSqlTest()
{
using (DbManager db = new DbManager())
{
DataTypeSqlTest dt = new DataTypeSqlTest();
dt.ID = 12345;
dt.Binary_ = new SqlBinary(new byte[2] {1, 2});
dt.Boolean_ = new SqlBoolean(1);
dt.Byte_ = new SqlByte(250);
dt.DateTime_ = new SqlDateTime(DateTime.Now);
dt.Decimal_ = new SqlDecimal(9876543210.0m);
dt.Double_ = new SqlDouble(12345.67890);
dt.Guid_ = new SqlGuid(Guid.Empty);
dt.Int16_ = new SqlInt16(12345);
dt.Int32_ = new SqlInt32(1234567890);
dt.Int64_ = new SqlInt64(1234567890123456789);
dt.Money_ = new SqlMoney(99876543210.0m);
dt.Single_ = new SqlSingle(1234.0f);
dt.String_ = new SqlString("Crazy Frog");
#if !SQLCE
dt.Bytes_ = new SqlBytes(new byte[2] {2, 1});
dt.Chars_ = new SqlChars(new char[2] {'B', 'L'});
dt.Xml_ = new SqlXml(new XmlTextReader(new StringReader("<xml/>")));
#endif
var parameters = db.CreateParameters(dt);
Assert.IsNotNull(parameters);
Assert.AreEqual(ObjectMapper<DataTypeSqlTest>.Instance.Count, parameters.Length);
foreach (MemberMapper mm in ObjectMapper<DataTypeSqlTest>.Instance)
{
var pName = (string)db.DataProvider.Convert(mm.Name, db.GetConvertTypeToParameter());
var p = Array.Find(parameters, obj => obj.ParameterName == pName);
Assert.IsNotNull(p);
Assert.AreEqual(mm.GetValue(dt), p.Value);
}
}
}
