Dapper使用LIKE實作模糊查詢

LIKE '%@Nsrmc%' 會解析成'%'@Nsrmc'%' 這裡用拼接也是不行的'%'[email protected]+'%' 隻能用MySQL函數方法拼接

public dynamic GetListByFilter(TaxBasicInfoModel filter, PageInfo pageInfo, int tenantId = 0)
        {
            var _where = $" where 1=1 and tenantId={tenantId} ";
            if (!string.IsNullOrEmpty(filter.Nsrmc))
            {
                _where += " and Nsrmc LIKE CONCAT('%',@Nsrmc,'%') ";
            }

            return GetListByFilter(filter, pageInfo, _where);
        }