public void CreateParameter_OneArgument_Test() { var testObject = new object(); var param = DatabaseUtils.CreateParameter <TestDbParameter>(testObject); param.Should().NotBeNull(); param.Value.Should().Be(testObject); }
public void CreateParamter_TwoArguments_Test() { var testObject = new object(); var param = DatabaseUtils.CreateParameter <TestDbParameter>("TestObject", testObject); param.Should().NotBeNull(); param.Value.Should().Be(testObject); param.ParameterName.Should().Be("TestObject"); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private static IDbParameter CreateParameter(IDataRecord reader) { var param = DatabaseUtils.CreateParameter <DbParameter>(); var tc = new DatabaseTypeConverter(); param.DbType = tc.GetDbType(reader["DATA_TYPE"].ToString()); var paramMode = reader["PARAMETER_MODE"].ToString(); switch (paramMode.ToUpper()) { case "IN": param.Direction = ParameterDirection.Input; break; case "OUT": param.Direction = ParameterDirection.Output; break; default: param.Direction = ParameterDirection.InputOutput; break; } param.ParameterName = reader["PARAMETER_NAME"].ToString(); return(param); }