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?

LINQ does not necessarily slows anything down, LINQ or SQL (the latter needs translation too, hits a source in a tabular data stream format I would suggest to use the traditional SQL calls in conjunctions with LINQ, e.g. some simple queries are better suited for LINQ, but not complex multi level statements involving stored procedures. PS: You have arrived to a SSIS (ETL) forum.Arthur My Blog