System.Linq.Async | Prototype of LINQ over IAsyncEnumerable T using C | Database library

I have two asynchronous sequences that I want to "zip" in pairs, and for this purpose I used the Zip operator from the System.Linq.Async package. This operator behaves in an undesirable way though, at least for my case. Instead of enumerating the two sequences concurrently, it enumerates them sequentially, with the result being that the latency is added up. Each of my sequences emits an element every one second on average, and I expected that the combined sequence would also emit zipped pairs every one second, but in reality I get one pair every 2 seconds. Below is a minimal example that demonstrates this behavior:

Is it possible? How?

I have an asynchronous method fetching rows of data from my database. My result is IAsyncEnumerable. It should be a perfect data type for a fast and responsive UI, however - when I set it as a datasource for my grid it just doesn't work and shows nothing.

I have 2 workarounds for this. First is obviously to return array from my async task. The second one is similar - I can just use ToArrayAsync() on result (from System.Linq.Async).

I suspect that using ToArrayAsync() is slower than just returning the array from the task, so it doesn't make much sense.

It would make a lot of sense if IAsyncEnumerable type could be used directly as a data source for the control. But then I probably need to implement some kind of IObservable interface or something like that. Did anyone tried this?

The whole thing is pretty new and I can't find any examples, or even an article stating that it's even possible. I mean - what good IAsyncEnumerable is if you cannot use it for the UI?

Update: what I'm looking for is a conversion between IAsyncEnumerable and ObservableCollection. I found examples, but they all work exactly as my mentioned workaround - so the data is put into an array and then added to the collection. This defeats all IAsyncEnumerable benefits.

I am getting the following error when using .NET Core 2.2 and SQL Always Encrypted. Is this supported in 2.2?

Keyword not supported: 'column encryption setting'.

Actually, I run DB migration in my AppContext constructor as you can see there.

I have an asynchronous sequence (stream) of messages that are arriving sometimes numerously and sometimes sporadically, and I would like to process them in batches of 10 messages per batch. I also want to enforce an upper limit to the latency between receiving a message and processing it, so a batch with fewer than 10 messages should also be processed, if 5 seconds have passed after receiving the first message of the batch. I found that I can solve the first part of the problem by using the Buffer operator from the System.Interactive.Async package:

I am using the latest version of .NET Core (.NET 5) and Entity Framework Core 6 (preview) to connect to a MySQL database. I am trying to use GroupBy to generate a group by query to execute on the DB server, as described here. Unfortunately, this fails to compile with the error

The call is ambiguous between the following methods or properties: 'System.Linq.Queryable.GroupBy(System.Linq.IQueryable, System.Linq.Expressions.Expression>)' and 'System.Linq.AsyncEnumerable.GroupBy(System.Collections.Generic.IAsyncEnumerable, System.Func)

This error is related to LINQ and EF Core sharing the same methods, and is discussed in detail here. I have tried the suggested workaround of creating extension methods for each LINQ call, with the following code:

I have an IAsyncEnumerable stream that contains data downloaded from the web, and I want to save asynchronously each piece of data in a SQL database. So I used the ForEachAwaitAsync extension method from the System.Linq.Async library. My problem is that downloading and saving each piece of data is happening sequentially, while I would prefer if it happened concurrently.

To clarify, I don't want to download more than one pieces of data at the same time, neither I want to save more than one pieces of data at the same time. What I want is that while I am saving a piece of data in the database, the next piece of data should be concurrently downloaded from the web.

Below is a minimal (contrived) example of my current solution. Five items are downloaded and then are saved in the database. Downloading each item takes 1 second, and saving it takes another 1 second:

I can get objects from EF with request like this:

I've watched the chat on LINQ with IAsyncEnumerable which has given me some insight on dealing with extension methods for IAsyncEnumerables, but wasn't detailed enough frankly for a real-world application, especially for my experience level, and I understand that samples/documentation don't really exist as of yet for IAsyncEnumerables

I'm trying to read from a file, do some transformation on the stream, returning a IAsyncEnumerable, and then send those objects downstream after an arbitrary number of objects have been obtained, like:

I've tried to define a gRPC service where client can subscribe to receive broadcasted messages and they can also send them.