public void SelectMultipleLinesWithMoreProperties()
{
var people = ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithMultipleLinesMoreProperties");
people.First().Should().Be.Equals(_john);
people.Last().Should().Be.Equals(_mario);
}
public void ExecuteParallel()
{
Parallel.For(0, 10, x =>
{
var p = ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithMultipleLinesMoreProperties");
p.Count().Should().Be(2);
});
}
public void ExecuteTwice()
{
var p1 = ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithMultipleLinesMoreProperties");
var p2 = ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithMultipleLinesLessProperties");
p1.Count().Should().Be(2);
p2.Count().Should().Be(2);
}
public void SelectMultipleLinesWithLessProperties()
{
var people = ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithMultipleLinesLessProperties");
var j = people.First();
var m = people.Last();
j.Name.Should().Be(_john.Name);
j.BirthDate.Should().Be(_john.BirthDate);
m.Name.Should().Be(_mario.Name);
m.BirthDate.Should().Be(_mario.BirthDate);
j.Weight.Should().Be(default(Decimal));
m.Weight.Should().Be(default(Decimal));
}
public void IntegerShouldBeConvertedAsDecimal()
{
var x = ProcedureExecuter.ExecuteReader <Int32AsDecimal>("ExecuteReaderWithMultipleLinesExactProperties").First();
x.IQ.Should().Be(210D);
}
public void SelectNoLinesWithExactProperties()
{
ProcedureExecuter.ExecuteReader <Person>("ExecuteReaderWithNoLinesExactProperties").Any().Should().Be(false);
}
public void ReturnValueAsInt()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithReturnValueAsInt").Should().Be(42);
}
public void DecimalShouldBeConvertedAsString()
{
var x = ProcedureExecuter.ExecuteReader <DecimalAsString>("ExecuteReaderWithMultipleLinesExactProperties").First();
x.Weight.Should().Be("98.7");
}
public void SelectWithMultipleColumnsAllAsInt()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectMultipleColumnsAsInt").Should().Be(42);
}
public void SelectAsDateTime()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectAsDateTime").Should().Be(new DateTime(2012, 1, 1));
}
public void SelectAsBooleanFalse()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectAsBooleanFalse").Should().Be(false);
}
public void SelectAsBooleanTrue()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectAsBooleanTrue").Should().Be(true);
}
public void SelectAsVarChar()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectAsVarChar").Should().Be("The answer is 42");
}
public void SelectAsInt()
{
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectAsInt").Should().Be(42);
}
public void DateTimeShouldBeConvertedAsString()
{
var x = ProcedureExecuter.ExecuteReader <DateTimeAsString>("ExecuteReaderWithMultipleLinesExactProperties").First();
x.BirthDate.Should().Be("1/1/1990 12:00:00 AM");
}
public void DecimalShouldBeConvertedAsInteger()
{
var x = ProcedureExecuter.ExecuteReader <DecimalAsInt32>("ExecuteReaderWithMultipleLinesExactProperties").First();
x.Weight.Should().Be(99);
}
public void SelectWithMutlipleColumnsAllAsVarchar()
{
ProcedureExecuter.CommandTimeout = 90;
ProcedureExecuter.ExecuteScalar("ExecuteScalarWithSelectMultipleColumnsAsVarChar").Should().Be("The answer is 42");
}
public void Integer1ShouldBeConvertedAsTrueBoolean()
{
var x = ProcedureExecuter.ExecuteReader <Int32AsBoolean>("ExecuteReaderWithIntegerAsTrueBoolean").First();
x.IQ.Should().Be(true);
}
public void ReturnMultipleValuesInParallel()
{
Parallel.For(0, 10, x => ProcedureExecuter.ExecuteScalar("ExecuteScalarWithReturnValueAsInt").Should().Be(42));
}
