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_ParameterNvarChar_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List<AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterNvarChar = "England" } }; var result = ExecuteStoredProcedureSingle<UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual("England", result.ParameterNvarChar); }
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_CorrectColumnOrder_NoErrors() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List<AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterDecimal = 555m /* ParameterDecimal - Column 10 */ } }; var result = ExecuteStoredProcedureSingle<UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual(555m, result.ParameterBigInt); }
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_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); }
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_ParameterNText_ReturnCorrectValue() { var proc = new UserDefinedTableStoredProcedure(); proc.UserDefinedTableParameter = new List<AllTypesUserDefinedTable>() { new AllTypesUserDefinedTable() { ParameterNText = "Michael Rodda" } }; var result = ExecuteStoredProcedureSingle<UserDefinedTableStoredProcedureReturn>(proc); Assert.AreEqual("Michael Rodda", result.ParameterNText); }
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); }