public void ExecuteStatementMultipleRowMultipleColumnTest()
{
// 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.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual(@"using(var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
result.RecordsAffected = reader.RecordsAffected;
var list = new List<procOutputDto>();
while (reader.Read())
{
var item = new procOutputDto();
item.col1 = !reader.IsDBNull(0) ? reader.GetInt32(0) : default(Int32?);
item.col2 = !reader.IsDBNull(1) ? reader.GetString(1) : default(String);
list.Add(item);
}
result.Data = list;
reader.Close();
}
", result);
}
public void ExecuteStatementNoSelectTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, null);
// Act
var result = helper.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual("result = cmd.ExecuteNonQuery();\r\n", result);
}
public void ExecuteStatementSingleValueTest()
{
// 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)
}, true, null)
});
// Act
var result = helper.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual("result = (Int32)cmd.ExecuteScalar();\r\n", result);
}
public void ExecuteStatementSingleValueTest()
{
// 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)
}, true, null)
});
// Act
var result = helper.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual("result = (Int32)cmd.ExecuteScalar();\r\n", result);
}
public void ExecuteStatementSingleRowMulipleColumnTest()
{
// 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),
}, true, null)
});
// Act
var result = helper.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual(@"using(var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
result.RecordsAffected = reader.RecordsAffected;
while (reader.Read())
{
var item = new procOutputDto();
item.col1 = !reader.IsDBNull(0) ? reader.GetInt32(0) : default(Int32?);
item.col2 = !reader.IsDBNull(1) ? reader.GetString(1) : default(String);
result.Data = item;
}
reader.Close();
}
", result);
}
public void ExecuteStatementNoSelectTest()
{
// Arrange
var helper = new ProcedureHelper();
var procedure = new Procedure("proc", "proc", null, null, null);
// Act
var result = helper.GetExecuteStatement(procedure);
// Assert
Assert.AreEqual("result = cmd.ExecuteNonQuery();\r\n", result);
}