Azure SQL has private preview support for vector search (post, post), and EF currently supports this via the EFCore.SqlServer.VectorSearch plugin.

As the Azure SQL support stabilizes, we should move the functionality from the external plugin into the SQL Server provider, this way users just get it out of the box. This should probably be done once the feature is stable enough (so setting as blocked) - being a plugin allows us lots of agility in releasing new versions, reacting to changes etc.