Does this look right? 1- get BgBomVectorModel by id first 2- do a search using BgBomVectorModel's list of BgBomVectorItem and find top a few best matching ones?
if so, what about write a query just for the BomItemsInformation list?
SELECT TOP 10 c.id, VectorDistance(c.DescriptionEmbedding , [1,2,3]) AS SimilarityScore
FROM c --(c is BomItemsInformation, the list)
ORDER BY VectorDistance(c.DescriptionEmbedding , [1,2,3])