The syntax of the method is more complete; you cannot make request syntax without connecting a method here or there inside. In addition, for some very simple queries, the method syntax may look more concise, IMO.
On the other hand, the query syntax may seem to more naturally describe a query to someone familiar with SQL.
I always believed that I used the method syntax exclusively when I started to learn Linq in general. But I also often lose queries on query syntax queries. Perhaps you could focus on the Method syntax because of the completeness and familiarity factor (if they are valuable to you at all), and maybe you will find that the query syntax just “comes to you” when you go too.
source
share