sqlsugar 扩展区分大小写查询

1764564459

于 2022-11-21 14:51:00 发布

阅读量136

点赞数

文章标签： android

本文链接：https://blog.csdn.net/qq_33271771/article/details/133005279

版权

一、添加扩展

①、配置扩展方法

   var context= new SqlSugarScope(new ConnectionConfig()
            {
                DbType = DbType.MySqlConnector,
                InitKeyType = InitKeyType.Attribute,
                IsAutoCloseConnection = true,
                ConnectionString = RepositoryConfig.ConnectionString,
                ConfigureExternalServices = new ConfigureExternalServices()
                {
                    SqlFuncServices= new List<SqlFuncExternal>
                    {
                        new SqlFuncExternal()
                        {
                            UniqueMethodName="AbsEquals",
                            MethodValue = (expInfo, dbType, context) =>
                            {
                                if(dbType==DbType.MySql)
                                    return $" binary {expInfo.Args[0].MemberName}='{expInfo.Args[1].MemberValue}' "；

                                return $" {expInfo.Args[0].MemberName}='{expInfo.Args[1].MemberValue}' ";
                            }
                        }
                    }
                }
            });

②、使用扩展方法

var user = context.Queryable<User>(p => SqlFuncEx.AbsEquals(p.Account, "Apricot")).FirstAsync();

③、扩展类

public static class SqlFuncEx
{
    public static bool AbsEquals(string first, string second)
        => throw new NotSupportedException("Can only be used in expressions");
}