public void SetParametersFromObject_StructuredGood_Null_Test() { DbAutoFillHelper.AddParametersFromObjectMembers(_command, _dvco); Assert.AreEqual(_command.Parameters.Count, 1); Assert.IsTrue(((INullable)_command.Parameters[OBJECT_MYSTRUCTUREDFIELD_NAME].SqlValue).IsNull); }
public void SetParametersFromObject_GoodValues_Test() { DbAutoFillHelper.AddParametersFromObjectMembers(_command, _dvco); Assert.AreEqual(_command.Parameters[DEFAULT_PARAMETER1_NAME].Value, DEFAULT_PARAMETER_1_VALUE); Assert.AreEqual(_command.Parameters[DEFAULT_PARAMETER2_NAME].Value, DEFAULT_PARAMETER_2_VALUE); Assert.AreEqual(_command.Parameters[DEFAULT_ToDB_PARAMETER_NAME].Value, DEFAULT_ToDBPARAMETER_VALUE); }
public void Advanced_SetParametersFromObject_ParametersSuffix_OnClass_Test() { ClassWithSuffix cws = new ClassWithSuffix(); DbAutoFillHelper.AddParametersFromObjectMembers(_command, cws); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_SUFFIX_PARAM_NAME)); }
public void Advanced_SetParametersFromObject_ParametersSuffix_OnProperty_Test() { AdvancedAutoFillClass aafc = new AdvancedAutoFillClass(); DbAutoFillHelper.AddParametersFromObjectMembers(_command, aafc); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_SUFFIX_PARAM_NAME)); }
public void Basic_SetParametersFromObject_PlainField_Test() { SecondObject so = new SecondObject(); DbAutoFillHelper.AddParametersFromObjectMembers(_command, so); Assert.IsTrue(_command.Parameters.Contains(BASIC_PARAMETER_SECOND_OBJECT_NORMAL_FIELD)); Assert.IsTrue(_command.Parameters[BASIC_PARAMETER_SECOND_OBJECT_NORMAL_FIELD].Value.Equals(BASIC_PARAMETER_SECOND_OBJECT_NORMAL_FIELD_VALUE)); }
public void SetParametersFromObject_GoodParameters_Test() { DbAutoFillHelper.AddParametersFromObjectMembers(_command, _dvco); Assert.IsTrue(_command.Parameters.Contains(DEFAULT_PARAMETER1_NAME)); Assert.IsTrue(_command.Parameters.Contains(DEFAULT_PARAMETER2_NAME)); Assert.IsFalse(_command.Parameters.Contains(DEFAULT_HIDDEN_PARAMETER_NAME)); Assert.IsTrue(_command.Parameters.Contains(DEFAULT_ToDB_PARAMETER_NAME)); Assert.IsFalse(_command.Parameters.Contains(DEFAULT_NONE_PARAMETER_NAME)); Assert.IsFalse(_command.Parameters.Contains(DEFAULT_FROMDB_PARAMETER_NAME)); }
public void Advanced_SetParametersFromObject_GoodParameters_Test() { AdvancedAutoFillClass aafc = new AdvancedAutoFillClass(); DbAutoFillHelper.AddParametersFromObjectMembers(_command, aafc); Assert.IsTrue(_command.Parameters.Count > 0); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_ALIASED_PARAM_NAME)); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_ALLOWED_MISSING_PARAM_NAME)); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_DbTypeDTDefault_PARAM_NAME)); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_DbTypeDT_PARAM_NAME)); Assert.IsTrue(_command.Parameters.Contains(ADVANCED_PARAMETER_PREFIX_OVERRIDE_PARAM_NAME)); }
public void SetParametersFromObject_StructuredGood_NotNull_Test() { _dvco.MyStructuredField = new GenericSqlStructuredType(); _dvco.MyStructuredField.Add(new MyGenericObject() { id = OBJECT_SET_ELEMENT1_ID, name = OBJECT_SET_ELEMENT1_NAME }); _dvco.MyStructuredField.Add(new MyGenericObject() { id = OBJECT_SET_ELEMENT2_ID, name = OBJECT_SET_ELEMENT2_NAME }); DbAutoFillHelper.AddParametersFromObjectMembers(_command, _dvco); Assert.IsTrue(_command.Parameters.Contains(OBJECT_MYSTRUCTUREDFIELD_NAME)); Assert.IsTrue(_command.Parameters[OBJECT_MYSTRUCTUREDFIELD_NAME].SqlDbType == SqlDbType.Structured); }