public void ReturnTypeMultipleRowSingleColumnTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, new List <Select> {
new Select(new List <SelectColumn> {
new SelectColumn("col1", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "Int32?"), false)
}, false, null)
});
// Act
var result = helper.GetReturnType(procedure);
// Assert
Assert.AreEqual("Result<IEnumerable<Int32>>", result);
}
public void ReturnTypeMultipleSelectTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, new List <Select> {
new Select(new List <SelectColumn> {
new SelectColumn("col1", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "Int32?"), true),
new SelectColumn("col2", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "String"), true)
}, false, null),
new Select(new List <SelectColumn> {
new SelectColumn("col1", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "Int32?"), true),
new SelectColumn("col2", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "String"), true)
}, true, null)
});
// Act
var result = helper.GetReturnType(procedure);
// Assert
Assert.AreEqual("procResults", result);
}
public void ReturnTypeSingleRowSingleColumnTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, new List<Select>{
new Select(new List<SelectColumn>{
new SelectColumn("col1", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "Int32?"), true)
}, true, null)
});
// Act
var result = helper.GetReturnType(procedure);
// Assert
Assert.AreEqual("Int32?", result);
}
public void ReturnTypeMultipleRowMultipleColumnTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, new List<Select>{
new Select(new List<SelectColumn>{
new SelectColumn("col1", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "Int32?"), true),
new SelectColumn("col2", DataTypeHelper.Instance.GetMap(TypeFormat.DotNetFrameworkType, "String"), true)
}, false, null)
});
// Act
var result = helper.GetReturnType(procedure);
// Assert
Assert.AreEqual("Result<IEnumerable<procOutputDto>>", result);
}
