In one table i have two columns one is unique

Question

In one table i have two columns one is unique

and another is duplicate.
unique always unique and duplicate is that maybe has duplicate and may be not. now i want get Duplicate value of some column that is equals unique and then use that to get all value that has same value as duplicate. (i don't understand what i wrote so i will show an example).i can get what i want with two step i want to is that possible to get that in one step
public class Test
{
public string Unique {get; set;} //sample data: one, two, three, four,
public string Duplicate {get; set;} //same data: yes, yes, no,yes
}

//step one get result of unique that equals one
// step two get result of all record that equals yes (because one has yes as duplicate value)
var test = db.Tests.First(t=> t.Unique == "one");
var otherTests = db.Tests.Where(tt => tt.Duplicate == test.duplicate).ToList();
// i want those two queries become one is that possible?

0

25.05.2024

2 ответов

31 просмотр

Mr Thieves Автор вопроса

luca flan di vedure
you could use .Join()

both result are in same table. so i should write something like this? var tests = db.Tests.First(t => t.Unqiue == "one).Join( // i don't know what do here)

0

5 месяцев назад

luca flan di vedure · Accepted Answer

luca flan di vedure

you could use .Join()

0

5 месяцев назад

Похожие чаты

In one table i have two columns one is unique

2 ответов

Похожие вопросы