CAML vs LINQ 2 Sharepoint comparison
1. CAML perform better in some cases as compared to LINQ 2 sharepoint. In case of LINQ 2 sharepoint whole list is fetched into memory and then filters are applied , so LINQ 2 sharepoint has performance over head as compared to CAML for large collections.
2. LINQ 2 sharepoint has full intellisense support in visual studio as compared to CAML, so becomes more programmer wise productive.
3. LINQ 2 Sharepoint is more productive because most .Net programmer already now LINQ syntax whereas CAML can be difficult to become productive because of difficult syntax.
For more details see: