Is it really impossible to choose between LINQ and Stored Procedures?

What is the elephant in the room of software engineering? We don't know how to tell which of two competing designs is the better. We can't make informed choices between architectures. Software engineering is in need of an enlightenment.