'Multiple tables with different properties in a single Azure Search index
Say I have multiple tables like News and User. These tables have complete different properties, is it possible to get data from both tables in the same index?
Solution 1:[1]
Yes, you can index data from different sources into the same index. Here's a tutorial on how to achieve this: https://docs.microsoft.com/en-us/azure/search/tutorial-multiple-data-sources
Solution 2:[2]
If you are creating your index programaticaly then just create new ViewModel that is composed of multiple models and create the index out of it. Or create the composite view in database out of few tables and again just create the index based on that view.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | ramero-MSFT |
| Solution 2 | error505 |