pomelo | A fast , scalable , distributed game server framework | Runtime Evironment library

You can use aggregate and array_intersect, along with collect_set to compute the intersection on list_of_fruits and collected_tokens to obtain intersection_list_of_fruits and intersection_collected_tokens.

However, since intersection_most_common_word needs to account for the count of the words. To do this,

1. Find the intersections of words excluding counts
2. Iterate over the intersection words and the collect arrays in most_common_word and find the minimum count

As mentioned by bricelam it was an issue/change in Pomelo provider and already reported in their github https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/1477. Since version 5.0.3 you can add the following to your DbContext:

Turns out after much trial and error that I had the attribute tags in the wrong order should be:

Your problem is async void.

Replace with async Task and don't forget to await GetCommonInfo.

Additional info: async/await - when to return a Task vs void?

Use Pomelo for MySQL 6.0.0 instead just worked.

But then I noticed that WSL is running in a different subnet on my system. My system and my NAS are in the 192.168.. range while WSL runs in the 172.30.. range. So WSL can't find the server as they're in different networks. My solution is simple, as I have a domain name and my router fas port forwarding for one port to the MariaDB database so I connect by using a domain name and custom port. And now it does work from WSL.
This is annoying, but it works.

There are basically 3 simple options, all demonstrated here with the IceCream.Available property:

Pomelo translates tinyint(1) to System.Boolean by default. So if you change the CLR type of your property from byte to bool, it works out-of-the box:

The solution is actually quite simple: Use connection interceptor (available from Entity Framework Core 3.0+).

The code below switches the database after the connection has been opened. Now each DbContext class can use its own database and with only one connection pool in use.

First you create an interceptor class inherited from DbConnectionInterceptor. The constructor takes the database name, you want to switch to, as parameter:

Each DbContext can config their own entity

Let assume we have 10 entities for 3 DbContext, we can separate them out 2 entities for ADbContext, 5 for BDbContext and 3 for CDbContext. Manage the configuration like FK, between them wisely, otherwise, that would turn to be chaos. Here is how to doing this, using fluent API