using store procedure is not my style in .net

During the past I am quite excited about using store procedure and I used it quite often for some performance reason and right now I found out that performance gain is a big trade off of the code maintainability and flexibility in my system. The reason I say so is because when i want to perform a select statement for instance, I need to create a new store procedure and over the time I have a hard time to maintain it. Actually, putting SQL statements inside application code is far more better than having storing store procedure over the server. Just think about by concatenate sql in a string with some condition and forget about store procedure which create so much complication. What do you think? Is life more simpler?