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