Hi, I need help in EF Core, I have a table

Question

Hi, I need help in EF Core, I have a table

tabl1 with columns
col_a | col_b
a | 1
a | 2
b | 3
b | 4
I want to select only the first row of every letter, so I get:
a | 1
b | 3
How can I achieve this?

0

07.04.2024

3 ответов

27 просмотров

Adnan Al_Beda Автор вопроса

I can do it with GroupBy, but it might be not the most efficient way, so I'm looking if there's more efficient way.

0

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

Adnan Al_Beda Автор вопроса

luca flan di vedure
did you benchmark it?

No, but my guess is that it will have to run through all rows to then select first of each. That's how it works at least in group by: ctx.Table1.GroupBy(x => x.ColA).Select(x => x.First())

0

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

luca flan di vedure · Accepted Answer

luca flan di vedure

Adnan Al_Beda
I can do it with GroupBy, but it might be not the ...

did you benchmark it?

0

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

Похожие чаты

Hi, I need help in EF Core, I have a table

3 ответов

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