If you are a database oriented developer, there is a myriad of choice nowadays. Do you still use stored procedures or do you see Linq and the ADO.NET Entity Framework as they way to go?

Yes, it is true that one can access stored procedures from both Linq and EF, but do you prefer the flexibility they give as a "trade off" over supposed performance and or code separation?