Hi Team,
We are upgrading our existing application (Asp.net Core MVC + Jquery with framework .net2.1 and version 6.2.1.) to .net 8 and version 13.1.1. following documentation (Version-Updating).
We have successfully build and run project after resolving conflicts. Now problem is that ABP latest version 9.2.2 is using EF Core 8 and our Linq queries which was working fine before upgrade (EF Core 2.1.4). Now below exception is occuring due to Entity Framework Core 3.x and later versions introduced stricter rules for translating LINQ queries to SQL.
Database: Azure SQL Database and Compatibility Level is 140
Example of Linq Query:
var recurrenceLst = _activityRepository.GetAllIncluding(x => x.CustomerFk, x => x.ContactFk) .Where(x => x.StatusId != (int)Status.Completed && x.IsRecurring && ((x.RecurrenceType == RecurrenceType.Monthly && (x.RecurrenceMonthDay == DateTime.Today.Day || (x.RecurrenceMonthDay > lastDayOfMonth && DateTime.Today.Day == lastDayOfMonth))) || (x.RecurrenceType == RecurrenceType.Weekly && x.RecurrenceWeekDay == (WeekDay)((int)DateTime.Today.DayOfWeek + 1)))).ToList();
Exception: The LINQ expression 'DbSet<Activity>() .Where(a => __ef_filter__p_0 || (int?)((IMustHaveTenant)a).TenantId == __ef_filter__CurrentTenantId_1) .Where(a => a.StatusId != 2 && a.IsRecurring && (int?)a.RecurrenceType == (int?)Monthly && a.RecurrenceMonthDay == (int?)DateTime.Today.Day || a.RecurrenceMonthDay > __lastDayOfMonth_0 && DateTime.Today.Day == __lastDayOfMonth_1 || (int?)a.RecurrenceType == (int?)Weekly && (int?)a.RecurrenceWeekDay == (int?)(WeekDay)((int)DateTime.Today.DayOfWeek + 1))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.
Solution Tried: We have thousands of Linq queries in a project and to avoid rewrite query and to load a lot of data in Memory and then filter, we tried to keep previous version of EFCore (2.1.4) and all related packages of EF Core to (2.1.4) But no success, project doesn't run and get another exception in LoadStopDbContextConfigurer file at builder.UseSqlServer(connectionString);
Exception System.TypeLoadException: 'Method 'get_Info' in type 'Microsoft.EntityFrameworkCore.SqlServer.Infrastructure.Internal.SqlServerOptionsExtension' from assembly 'Microsoft.EntityFrameworkCore.SqlServer, Version=2.1.4.0, Culture=neutral, PublicKeyToken=adb9793829ddae60' does not have an implementation.'
Please give a solution or suggestion. Right now its not possible to rewrite thousands of Linq Queries according to EF Core 8. What we can do to support current written Linq queries?
Hi Team,
We are upgrading our existing application (Asp.net Core MVC + Jquery with framework .net2.1 and version 6.2.1.) to .net 8 and version 13.1.1. following documentation (Version-Updating). We have successfully resolved all conflicts of files and now try to running the project.
When doing Impersonation getting a AbpSession.ImpersonatorUserId NULL.
Hi Team,
We are upgrading our existing application (Asp.net Core MVC + Jquery with framework .net2.1 and version 6.2.1.) to .net 8 and version 13.1.1. following documentation (Version-Updating).
Getting a lot of MIME Type Errors.
Refused to apply style from 'http://localhost:65501/view-resources/Areas/App/Views/_Bundles/account-layout-libs.min.css' because its MIME type ('') is not a supported stylesheet MIME type, and strict MIME checking is enabled.
Hi Team,
We are upgrading our existing application (Asp.net Core MVC + Jquery with framework .net2.1 and version 6.2.1.) to .net 8 and version 13.1.1. following documentation (Version-Updating).
In Startup.cs we have added below line // MVC var mvcBuilder = services.AddControllersWithViews(options => { options.Filters.Add(new AbpAutoValidateAntiforgeryTokenAttribute()); options.AddAbpHtmlSanitizer(); });
We are facing below exception when project runs.
Exception: HandlerException: Can't create component 'Abp.AspNetCore.Mvc.Antiforgery.AbpAutoValidateAntiforgeryTokenAuthorizationFilter' as it has dependencies to be satisfied. 'Abp.AspNetCore.Mvc.Antiforgery.AbpAutoValidateAntiforgeryTokenAuthorizationFilter' is waiting for the following dependencies: - Service 'Castle.Core.Logging.ILogger' which was not registered.
Hi @ismcagdas,
As we are upgrading to latest version from 6.2.0 to 13.1.1 following documentation. I have read in one of your comment "We don't support IdentityServer4 anymore. In v12.3 we will integrate and support OpenIdDict".
I have seen in latest version you have removed IdentityServer4 and using OpenIdDict but we still want to use IdentityServer4. Need your assistance on this. What we have to do to use IdentityServer4 instead of OpenIdDict?
We have a existing project in Asp.net Core MVC + Jquery with framework .net2.1 and version 6.2.1. We are going to upgrade in .net 8 and version 13.1.1.
I have downloaded the latest version 13.1.1 and .net 8 project with same name.
As mention in documentation "Switch to aspnetzero branch in your source control and copy new AspNet Zero version into this branch". What does it mean to copy new AspNet Zero version into your branch?. Which files, and folder needs to copy ? Can you please describe in detail?
AspNetZero (Paid) Product version --> 4.0 Product type --> MVC Product framework type --> .net core
We have reference to below files in bundleconfig json in the project we downloaded from aspnetzero: wwwroot/lib/json2/lib/JSON2/static/json2.js wwwroot/lib/bootstrap/dist/css/bootstrap.css wwwroot/lib/datatables.net-responsive-bs4/css/responsive.bootstrap4.css wwwroot/lib/push.js/bin/push.js wwwroot/lib/datatables.net-responsive-bs4/js/responsive.bootstrap4.js
but these files does not exist on these paths but available in node_modules and it is causing issue in build pipelines. So can you please let us know how to fix this? Is this bug in existing project or we need to run some commands?
Hi
We are using AspNetZero (Paid) Product version --> 4.0 Product type --> MVC Product framework type --> .net core
Is there any way with which we can disable access to specific page if tenant is setup with specific feature tag?
Hi
We are using AspNetZero (Paid) Product version --> 4.0 Product type --> MVC Product framework type --> .net core
We are working on a new feature where we have a need to dynamically add new item in the menu without reloading page. We have look through some documents and found there is one javascript API called abp.nav.menus.MainMenu but there are no methods we can find right now to make a call and get updated menu.
So could you please let us know if there is anyway we can refresh menu without reloading the entire page?
AspNetZero (Paid) Product version --> 4.0 Product type --> MVC Product framework type --> .net core 2.1
Right now we don't have any background job using worker but we see some queries in log which are blocking
(@p9 bigint,@p0 datetime2(7),@p1 bigint,@p2 bit,@p3 nvarchar(4000),@p4 nvarchar(512),@p5 datetime2(7),@p6 datetime2(7),@p7 tinyint,@p8 smallint)UPDATE [AbpBackgroundJobs] SET [CreationTime] = @p0, [CreatorUserId] = @p1, [IsAbandoned] = @p2, [JobArgs] = @p3, [JobType] = @p4, [LastTryTime] = @p5, [NextTryTime] = @p6, [Priority] = @p7, [TryCount] = @p8 WHERE [Id] = @p9
and also some queries deleting logs (@p0 uniqueidentifier)DELETE FROM [AbpNotifications] WHERE [Id] = @p0
We haven't configured so far for it, so we need to know when and at what interval these queries are getting executed? And is there any way we can disable it?
