The README.md file has been updated to include a new note about how vectors are saved and retrieved using direct SQL queries with Dapper. Additionally, it provides a link to the master branch for those who prefer to use Entity Framework Core instead. This addition helps clarify the technologies used and offers options for different preferences.

Expanded the Vector support requirement to include both Azure SQL Database and Managed Instance, both currently in EAP. Improved wording for clarity in the note about using direct SQL queries with Dapper.

Corrected the URL in README.md to point to the master branch for using Entity Framework Core, ensuring users are directed to the correct branch.

Revised the application description in README.md to specify the use of direct SQL queries with Dapper for saving and retrieving Vectors. The note about using Entity Framework Core has been moved and rephrased for better clarity.

The Microsoft.SemanticKernel package reference in the SqlDatabaseVectorSearch.csproj file has been updated from version 1.25.0 to 1.26.0.

- Changed ChatService registration in Program.cs to singleton.
- Reformatted ChatHistory initialization in ChatService.cs.
- Modified prompt construction to avoid new lines after chunks.
- Updated Microsoft.SemanticKernel package to version 1.27.0.

The variable name `result` in the `foreach` loop has been changed to `text` for better clarity and consistency. This change affects the loop that appends chunks to the `prompt` variable.

README.md: Updated links to 'sql' branch and corrected property name.
ChatService.cs: Changed prompt separators for better clarity.

Updated .editorconfig with new code style preferences.
Enhanced ChatService prompt string with a new directive.
Modified VectorSearchService using directives and tuple order.
Upgraded SqlDatabaseVectorSearch to target .NET 9.0 and updated packages.

Updated the Microsoft.SemanticKernel package from version 1.27.0 to 1.30.0 in the SqlDatabaseVectorSearch.csproj file. This update may include bug fixes, new features, or other improvements.

Updated Microsoft.SemanticKernel to 1.31.0, Swashbuckle.AspNetCore to 7.1.0, and TinyHelpers.AspNetCore to 4.0.4. Added new package reference for TinyHelpers.AspNetCore.Swashbuckle version 4.0.5.

The version of the `TinyHelpers.AspNetCore` package has been updated from `4.0.4` to `4.0.5` in the `SqlDatabaseVectorSearch.csproj` file. This update likely includes bug fixes, improvements, or new features provided in the newer version of the package.

Updated Program.cs to use TinyHelpers.AspNetCore.OpenApi and Microsoft.Extensions.Caching.Hybrid. Refactored ChatService.cs to use HybridCache for chat history management. Removed MessageLimit property from AppSettings.cs and appsettings.json. Updated SqlDatabaseVectorSearch.csproj to include new caching package and replace Swagger with Swagger UI.

Updated Swashbuckle.AspNetCore.SwaggerUI from 7.1.0 to 7.2.0.
Updated TinyHelpers.AspNetCore from 4.0.5 to 4.0.6.
These updates likely include bug fixes, performance improvements,
or new features.