KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I currently have 2 queries that are returning lists of MyModel like this: var q1 = .... select new MyModel() { TheData1 = ... TheData2 = ... TheUniqueID = ... } var q2 = .... select new MyModel() { TheData1 = ... TheData2 = ... TheUniqueID = ... } If in q1 I have: TheUniqueID = 2,3,6,9,11 and in q2 I have: TheUniqueID = 2,4,7,9,12 How do write the query so that I get a list of MyModel where TheUniqueID = 2,3,4,6,7,9,11,12 In other words, each TheUniqueID is present only once (ie. 2 and 9 not repeated). I started looking at Union and distinct but I'm wondering if I need 2 from statements or not. Any suggestions are welcome.
Tags (comma-separated)
Save Edits
Cancel