public void Execute_ParameterChar_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterChar = "Mike Rodda" } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual("Mike Rodda", result.ParameterChar); }
public void Execute_CorrectColumnOrder_NoErrors() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterDecimal = 555.01m /* ParameterDecimal - Column 10 */ } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(555m, result.ParameterBigInt); }
public void Execute_ParameterBinary_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterBinary = GetBytes("Kourtney Wood") } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(GetBytes("Kourtney Wood"), result.ParameterBinary); }
public void Execute_ParameterBit_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterBit = true } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(true, result.ParameterBit); }
public void Execute_ParameterXml_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterXml = "<EntityFramework />" } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual("<EntityFramework />", result.ParameterXml); }
public void Execute_ParameterTime_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterTime = new TimeSpan(0, 2, 88, 2) } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(new TimeSpan(0, 2, 88, 2), result.ParameterTime); }
public void Execute_ParameterSmallDateTime_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterSmallDateTime = new DateTime(2014, 03, 08) } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(new DateTime(2014, 03, 08), result.ParameterSmallDateTime); }
public void Execute_ParameterDateTimeOffset_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterDateTimeOffset = new DateTimeOffset(2014, 5, 2, 9, 4, 8, new TimeSpan(0, 13, 22, 0)) } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(new DateTimeOffset(2014, 5, 2, 9, 4, 8, new TimeSpan(0, 13, 22, 0)), result.ParameterDateTimeOffset); }
public void Execute_ParameterUniqueIdentifier_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); var uniqueIdentifier = Guid.NewGuid(); proc.UserDefinedTableParameter = new List <AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterUniqueIdentifier = uniqueIdentifier } }; var result = ExecuteStoredProcedureSingle <UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(uniqueIdentifier, result.ParameterUniqueIdentifier); }