How to select with Linq to Entity from one table with two different variables?
- by George
I have a table where I have items under two different types as you can see below:
How can I select from this table with Linq to Entity to get the result with two variables?
where ItemType = Type1 and ItemType == Type2
.... select new {typeOne == "", typeTwo == ""};
ID ItemName ItemType
1 ItemOne Type1
2 ItemTwo Type1
3 ItemThree Type1
4 ItemFour Type1
5 ItemTFive Type2
6 ItemSix Type2
7 ItemSeven Type2
8 ItemEight Type2
