Entity Framework Core - Knowledge Base (KB)

How to merge two similar database tables into one SelectList

I have two database tables that each have two columns that are the exact same -- Name and Designator. I want to create a SelectList combining the two tables using Designator as the value and Name as the text. This is what I've tried, but the options come ...