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 NonUpdatableTest() { var da = new SqlQuery(); using (var db = new DbManager()) { var update = da.GetSqlQueryInfo<TestCategory>(db, "Update"); var insert = da.GetSqlQueryInfo<TestCategory>(db, "Insert"); Assert.That(update.QueryText, Is.Not.Contains( "\t" + db.DataProvider.Convert("Id", ConvertType.NameToQueryField) + " = " + db.DataProvider.Convert("Id", db.GetConvertTypeToParameter()) + "\n"), "Update"); Assert.That(insert.QueryText, Is.Not.Contains("Id"), "Insert"); } }
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); } } }