You can view the SQL that linq generates in debug mode, but a talented DBA might be able to write better code. There are still alot of "It depends" at this point in time. Remember you can still use LINQ with Stored Procedures with less code than ADO.NET, so you are really getting the best of both worlds. I'll see if I can dig up some performances reports.

You're right, my bad. I still pretty new to this, so I will take you advice for future posting.