test/02_Data/Data.Adapter.SqlServer.Test/ExpressionResolverTests.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using Data.Common.Test.Domain.Article;
using Microsoft.Extensions.DependencyInjection;
using Mkh.Data.Abstractions.Extensions;
using Mkh.Data.Core.Internal;
using Mkh.Data.Core.Internal.QueryStructure;
using Xunit;
using Xunit.Abstractions;

namespace Data.Adapter.SqlServer.Test
{
    public class ExpressionResolverTests : DbContextTests
    {
        private readonly QueryBody _queryBody;

        public ExpressionResolverTests(ITestOutputHelper output) : base(output)
        {
            _queryBody = new QueryBody(_serviceProvider.GetService<IArticleRepository>());
            _queryBody.Joins.Add(new QueryJoin(_dbContext.EntityDescriptors.FirstOrDefault(m => m.TableName == "Article"), "T1"));
        }

        /// <summary>
        /// 解析表达式
        /// </summary>
        [Fact]
        public void ResolveExpressionTest()
        {
            Expression<Func<ArticleEntity, bool>> exp = m => m.Id > 10;

            var parameters = new QueryParameters();
            var sql = ExpressionResolver.Resolve(_queryBody, exp, parameters);

            Assert.Equal("[Id] > @P1", sql);
            Assert.Equal(1, parameters.Count);
        }

        /// <summary>
        /// 解析表达式
        /// </summary>
        [Fact]
        public void ResolveExpressionTest1()
        {
            Expression<Func<ArticleEntity, bool>> exp = m => m.Id > 10 && m.Id < 20 && m.Title == "123";

            var parameters = new QueryParameters();
            var sql = ExpressionResolver.Resolve(_queryBody, exp, parameters);

            Assert.Equal("[Id] > @P1 AND [Id] < @P2 AND [Title] = @P3", sql);
            Assert.Equal(3, parameters.Count);
        }

        /// <summary>
        /// 解析测试字符串的Length属性
        /// </summary>
        [Fact]
        public void ResolveExpressionTest3()