Is linq to sql inefficiently translating this query into the format: "select *"?

Question

I am not very familiar with Linq to SQL, but something that struck me was this:

var articles = 
  (from a in DB.Articles
  where 
  a.ArticleId == ArticleId.Question &&
  a.DeletedAt == null &&
  a.Votes >= minVotes
  orderby a.UpdatedAt descending
  select a).
  Take(maxarticles);

proceeds to the following:

string query = 
  "select top 10 * from articles
  where 
  ArticleId = 1 and 
  DeletedAt is null and 
  Votes >= -5
  order by UpdatedAt desc";

It seems ineffective to me that linq to sql is ready to clear everything using a query like "select *". Is it inefficient?

Why does linq for sql do it this way?

Answer 1

If you want to select fewer columns, you will need to use the forecast in your linq query.

var articles = (from a in DB.Articles
    where a.ArticleId == ArticleId.Question 
        && a.DeletedAt == null 
        && a.Votes >= minVotes
    orderby a.UpdatedAt descending
    select new 
    {
       a.ArticleId,
       a.Votes
    })
    .Take(maxarticles);

Doing something like the above translates to SQL, which looks like this:

select top 10 
         ArticleId,
         Votes
from     articles
where    ArticleId = 1 
         and DeletedAt is null
         and Votes >= -5
order by UpdatedAt desc

Answer 2

, "SELECT *", , .

linq sql, , "select a"