Select specific columns from First() row with Linq2sql

Question

I want to use First() in a Linq2sql query, but I don't want the database to return the whole row, just specific columns. Is there a way to do that?

If I use Where() I can then Select() (while it stays an IQueryable), but if I use Where() it will iterate over all rows instead of stopping when it finds a match.

@Sami I just now edited the question in case someone doesn't notice the linq-to-sql tag. — ispiro
– ispiro, Commented Dec 3, 2018 at 15:30
@jarlh According to the edit and the comment, he look for a linq answer — Ilyes
– Ilyes, Commented Dec 3, 2018 at 15:31
Write Where().Select() first and then use First(). That's the equivalent of SELECT TOP 1 col1,col2 ..... WHERE .. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Dec 3, 2018 at 15:47

Angel Q · Accepted Answer · 2018-12-03 16:32:54Z

1

when you use "Where" it does not iterate over all record until you actually execute the query. because thats how linq works, until you actually use the result of the query (convert it to a list, bind to a gridview, etc...) it is not executed so you can add as many conditions as you want and they will combine into a single query.

so where.select.first should work

edited Dec 3, 2018 at 16:32

answered Dec 3, 2018 at 16:26

Angel Q

12410 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select specific columns from First() row with Linq2sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related