I really should read my blog feeds before posting. Scott has just posted a good article about LINQ in ASP.NET "Orcas" with some good examples. However, I'm still worried about SQL style syntax in code - where should it go? Should we abstract it into a separate layer? Should we not have stored procedures anymore? I think sprocs will be quicker than equivalent LINQ query, although I have no figures to substantiate that. SQL is very, very good at set based operations and coupled with compiled query plans is the fasted way to select data in SQL Server. I don't beleive we should abandon this and move our query out of the database.
[Listening to: Bob Harris Saturday - - ]