ABP Framework version: v7.2.2
UI type: MVC
DB provider: EF Core
Tiered (MVC) or Identity Server Separated (Angular): no
Exception message and stack trace:
InvalidOperationException: The LINQ expression 'ROW_NUMBER() OVER(PARTITION BY a0.Id ORDER BY a0.Id ASC)' 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.
Steps to reproduce the issue:"
在EfCoreContractRepository.cs中执行这段代码后，报了上面的错误。DB：mysql 5.7.28
In EfCoreContractRepository. Cs to execute this code, called the above error. DB：mysql 5.7.28
`var dbContext = await GetDbContextAsync();
var model = (await GetDbSetAsync()).Where(b => b.Id == id)
.Select(contract => new ContractWithNavigationProperties
{
Contract = contract,
Customer = dbContext.Customers.FirstOrDefault(c => c.Id == contract.CustomerId),
Department = dbContext.Departments.FirstOrDefault(c => c.Id == contract.DepartmentId),
Orders = dbContext.Orders.Where(c => c.ContractId == contract.Id).ToList(),
Agent = dbContext.AgentAccounts.FirstOrDefault(c => c.ContractId == contract.Id)
}).FirstOrDefault();`
[00:06:05 INF] Request starting HTTP/1.1 GET http://203.195.177.144:8080/api/app/orders?filterText=&orderNo=&projectName=&projectPriceMin=&projectPriceMax=&projectRemarks=&executionGenre=&auditStatus=&contractId=&customerId=&myApplyFlow=false&myApprovalFlow=false&sorting=contract.contractNo%20desc&skipCount=0&maxResultCount=10 application/json - [00:06:05 INF] Executing endpoint 'Ywz.Bms.Orders.OrdersAppService.GetListAsync (Ywz.Bms.Application)' [00:06:05 INF] Route matched with {action = "GetList", controller = "Orders", area = "", page = ""}. Executing controller action with signature System.Threading.Tasks.Task1[Volo.Abp.Application.Dtos.PagedResultDto`1[Ywz.Bms.Orders.OrderWithNavigationPropertiesDto]] GetListAsync(Ywz.Bms.Orders.GetOrdersInput) on controller Ywz.Bms.Orders.OrdersAppService (Ywz.Bms.Application).
[00:06:05 ERR] An exception occurred while iterating over the results of a query for context type 'Ywz.Bms.EntityFrameworkCore.BmsDbContext'.
Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 - An internal exception was caught)
---> System.IO.IOException: Unable to read data from the transport connection: Connection reset by peer.
---> System.Net.Sockets.SocketException (104): Connection reset by peer
--- End of inner exception stack trace ---
at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketError error, CancellationToken cancellationToken)
at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.Tasks.Sources.IValueTaskSource<System.Int32>.GetResult(Int16 token)
at Microsoft.Data.SqlClient.SNI.SNINetworkStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken) at Microsoft.Data.SqlClient.SNI.SslOverTdsStream.ReadAsync(Memory1 buffer, CancellationToken cancellationToken)
at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](CancellationToken cancellationToken)
at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource
Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.
If you're creating a bug/problem report, please include followings:
https://community.abp.io/posts/converting-createedit-modal-to-page-4ps5v60m Based on this article, I converted the creation pattern into a page. But the navigation properties don't show up? 1, the use of modal pop-up mode is normal display. 2. When "Create mode to page" is used, it cannot be displayed.
我根据这篇文章（将创建/编辑模式转换为页面）。
但是导航属性显示不出来？
1、使用模态弹窗方式是正常显示。
2、当使用“创建模式转换为页面”时，显示不出来。
What should I do to display navigation properties normally?
请问需要怎么做，才能正常显示导航属性呢？
Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.
If you're creating a bug/problem report, please include followings:
本地调试MVC项目代码特别慢 Debugging MVC project code locally is particularly slow
使用suite新生成的MVC项目 A newly generated MVC project using suite
打开一个页面，需要的时间很长 It takes a long time to open a page
点击打开一个弹窗，每次需要30-60秒 It takes 30-60 seconds to open a pop-up window
我录制了视频，地址 I made a video. The address Debugging MVC project code locally is particularly slow
请问有解决调试慢的方案吗？ Is there any solution to slow debugging?
Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.
If you're creating a bug/problem report, please include followings:
这个*Module.cs文件，我写了自已的代码，有中文注释。 This *Module.cs file, I wrote my own code, with Chinese comments.
当我用suite生成代码时，中文注释变成了乱码，如何解决的呢？ When I use suite to generate code, Chinese comments become garbled. How do I solve this problem?
ABP Framework version: v6.0.1
UI type: MVC
DB provider: EF Core
Tiered (MVC) or Identity Server Separated (Angular): no
Exception message and stack trace:
Steps to reproduce the issue:"
1、Add Chat to the Suite's Modules
2、Chat is not a feature set in Features（Enable chat）
3、File Management, Forms modules installed, no menu appears.
This is a bug, how do you fix it?
