I am a big fan of LINQ but it gives and takes away complexity at the same time.
It makes a 'whole class of things that you would have to do with loops' go away.
Once you are comfortable with the syntax, it makes code a lot more readable.
But you lose track of when and where things are getting executed.
For example, it is easy to make something that you intend to execute inside of
SQL server run inside of C# code. And then, all of a sudden, string comparison
is case-sensitive.
You wind up having to context switch between procedural and set mentality without
the same kind of visual cues you used to get.
It makes a 'whole class of things that you would have to do with loops' go away. Once you are comfortable with the syntax, it makes code a lot more readable.
But you lose track of when and where things are getting executed.
For example, it is easy to make something that you intend to execute inside of SQL server run inside of C# code. And then, all of a sudden, string comparison is case-sensitive.
You wind up having to context switch between procedural and set mentality without the same kind of visual cues you used to get.