SQL Server improvements to asynchronous code

microsoft / kernel-memory

RAG architecture: index and query any data using LLM and natural language, track sources, show citations, asynchronous memory patterns.

https://microsoft.github.io/kernel-memory

MIT License

1.52k stars 293 forks source link

Closed dluc closed 4 months ago

dluc commented 4 months ago

Improve some areas of the SqlServer memory connector:

avoid I/O in ctor, which could cause the service to crash with dependency injection errors. Run the initialization logic on the first call to any public method instead.
change methods using I/O from sync to async
use async dispose for connection, command, and data reader instances
add missing ConfigureAwait(false) on instances async disposing logic

dluc commented 4 months ago

/cc @kbeaugrand