Little guidance requested for custom async ORM

[chris-kruining]

Hi,
I'm not quite certain this is the right place to ask, but I want to give it a shot any way.

I am trying to create a ORM for C#, for this I would like to utilise the 'new' IAsyncEnumerable. To prevent me from completely re-inventing the wheel I would like to use the power of linq.
I have discovered that it is possible to create a provider for linq via the IQueryable interfave. If I understand correctly this means that I can create a sql string builder via a custom provider for my ORM.

However this seems limited to synchronous code as far as I understand it.
Could I maybe get a starting of point where I basically can create a streaming api where I create a query via linq and get a IAsyncEnumerable<TModel> as output? Or is this just not possible?

[chris-kruining]

Would I need an IAsyncQueryable<T> interface for this? just as IQueryable<T> extends IEnumerable<T>, would IAsyncQueryable<T> extend IAsyncEnumerable<T>?

[chris-kruining]

I just discovered the System.Linq.Async.Queryable nuget package, it seems this is the answer to my question. I am still experimenting with it, but it does contain the interface I name earlier.

[chris-kruining]

Seems I have figured out how it works, closing