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_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_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_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);
}
