C# working with linq

Question

I have a question about the benefits of using linq to sql in a C# 2010 web form application. I am asking that question since I am the only programmer at a small company that is making changes to the company website that was written originally by a contract shop that went out of business. This is the first time I have worked with linq to sql.

From my point of view, I just see linq as more performance overhead to slow down the performance of the website. The linq needs to  be translated to sql by the .net application. Thus can you tell me what I am missing?