System.Linq.Dynamic.Core/test/System.Linq.Dynamic.Core.Tests/EntitiesTests.SingleOrDefaultAsync.cs at master · matrixdekoder/System.Linq.Dynamic.Core · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
#if EFCORE
using Microsoft.EntityFrameworkCore.DynamicLinq;
#else
using EntityFramework.DynamicLinq;
#endif
using System.Threading.Tasks;
using Xunit;

namespace System.Linq.Dynamic.Core.Tests
{
    public partial class EntitiesTests
    {
        [Fact]
        public async Task Entities_SingleOrDefaultAsync()
        {
            //Arrange
            PopulateTestData(1, 0);

            var expectedQueryable1 = _context.Blogs.Where(b => b.BlogId > 0);
            var expected1 = await expectedQueryable1.SingleOrDefaultAsync();

            var expectedQueryable2 = _context.Blogs.Where(b => b.BlogId > 9999);
            var expected2 = await expectedQueryable2.SingleOrDefaultAsync();

            //Act
            IQueryable queryable1 = _context.Blogs.Where("BlogId > 0");
            var result1 = await queryable1.SingleOrDefaultAsync();

            IQueryable queryable2 = _context.Blogs.Where("BlogId > 9999");
            var result2 = await queryable2.SingleOrDefaultAsync();

            //Assert
            Assert.Equal(expected1, result1);
            Assert.Null(expected2);
            Assert.Null(result2);
        }

        [Fact]
        public async Task Entities_SingleOrDefaultAsync_Predicate()
        {
            //Arrange
            PopulateTestData(1, 0);
#if EFCORE
            var expected1 = await Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.SingleOrDefaultAsync(_context.Blogs, b => b.BlogId > 0);
            var expected2 = await Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.SingleOrDefaultAsync(_context.Blogs, b => b.BlogId > 9999);
#else
            var expected1 = await System.Data.Entity.QueryableExtensions.SingleOrDefaultAsync(_context.Blogs, b => b.BlogId > 0);
            var expected2 = await System.Data.Entity.QueryableExtensions.SingleOrDefaultAsync(_context.Blogs, b => b.BlogId > 9999);
#endif

            //Act
            var result1 = await _context.Blogs.AsQueryable().SingleOrDefaultAsync("it.BlogId > 0");
            var result2 = await _context.Blogs.AsQueryable().SingleOrDefaultAsync("it.BlogId > 9999");

            //Assert
            Assert.Equal(expected1, result1);
            Assert.Null(expected2);
            Assert.Null(result2);
        }
    }
}