C# (CSharp) SimpleResultSet.SingleOrDefault Examples

Example #1

File: SqlRunner.cs Project: jonocairns/csharp-utils

    /// <summary>
    /// Executes the versioned save.
    /// </summary>
    public SimpleResultSet ExecuteNonTransactedVersionedSave(Func <dynamic, SimpleResultSet> dbAction, string outOfDateError)
    {
        SimpleResultSet result = ExecuteNonTransacted(dbAction);

        if (result.SingleOrDefault() == null)
        {
            throw new ConcurrencyException(outOfDateError);
        }

        return(result);
    }

Example #2

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void GenericSingleOrDefaultThrowsOnListWithMoreThanOneElement()
 {
     var list = new SimpleResultSet(Records(2));
     Assert.Throws<InvalidOperationException>(() => list.SingleOrDefault<TestType>());
 }

Example #3

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void GenericSingleOrDefaultReturnsNullOnEmptyList()
 {
     var list = new SimpleResultSet(Records(0));
     Assert.IsNull(list.SingleOrDefault<TestType>());
 }

Example #4

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void GenericSingleOrDefaultReturnsSingleElement()
 {
     var list = new SimpleResultSet(Records(1));
     Assert.AreEqual("0", list.SingleOrDefault<TestType>().Data);
 }

Example #5

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void SingleOrDefaultWithCriteriaMatchingMultipleRecordsThrows()
 {
     var list = new SimpleResultSet(Records(20));
     Assert.Throws<InvalidOperationException>(() => list.SingleOrDefault<TestType>(t => t.Data.EndsWith("8")));
 }

Example #6

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void SingleOrDefaultWithFailingCriteriaReturnsNull()
 {
     var list = new SimpleResultSet(Records(20));
     Assert.IsNull(list.SingleOrDefault<TestType>(t => t.Data.EndsWith("A")));
 }

Example #7

File: SimpleResultSetTest.cs Project: rposbo/Simple.Data

 public void SingleOrDefaultWithCriteriaReturnsMatch()
 {
     var list = new SimpleResultSet(Records(10));
     Assert.AreEqual("8", list.SingleOrDefault<TestType>(t => t.Data.EndsWith("8")).Data);
 }

Example #8

        public void GenericSingleOrDefaultThrowsOnListWithMoreThanOneElement()
        {
            var list = new SimpleResultSet(Records(2));

            Assert.Throws <InvalidOperationException>(() => list.SingleOrDefault <TestType>());
        }

Example #9

        public void GenericSingleOrDefaultReturnsNullOnEmptyList()
        {
            var list = new SimpleResultSet(Records(0));

            Assert.IsNull(list.SingleOrDefault <TestType>());
        }

Example #10

        public void GenericSingleOrDefaultReturnsSingleElement()
        {
            var list = new SimpleResultSet(Records(1));

            Assert.AreEqual("0", list.SingleOrDefault <TestType>().Data);
        }

Example #11

        public void SingleOrDefaultWithCriteriaMatchingMultipleRecordsThrows()
        {
            var list = new SimpleResultSet(Records(20));

            Assert.Throws <InvalidOperationException>(() => list.SingleOrDefault <TestType>(t => t.Data.EndsWith("8")));
        }

Example #12

        public void SingleOrDefaultWithFailingCriteriaReturnsNull()
        {
            var list = new SimpleResultSet(Records(20));

            Assert.IsNull(list.SingleOrDefault <TestType>(t => t.Data.EndsWith("A")));
        }

Example #13

        public void SingleOrDefaultWithCriteriaReturnsMatch()
        {
            var list = new SimpleResultSet(Records(10));

            Assert.AreEqual("8", list.SingleOrDefault <TestType>(t => t.Data.EndsWith("8")).Data);
        }