Does EF not using the same old concept of creating large query that leads to degrade performance?

Does EF not using the same old concept of creating large query that leads
to degrade performance?

I know this could be a stupid question, but a beginner I must ask this
question to experts to clear my doubt. When we use Entity Framework to
query data from database by joining multiple tables it creates a sql query
and this query is then fired to database to fetch records.
"We know that if we execute large query from .net code it will increase
network traffic and performance will be down. So instead of writing large
query we create and execute stored procedure and that significantly
increases the performance."
My question is - does EF not using the same old concept of creating large
query that leads to degrade performance.
Experts please clear my doubts. Thanks.