John,
Not to get argumentative, but the whole "best to do it in a SP" idea is getting a bit of a workout here. There is nothing wrong with manipulating data in the application (a la Linq or with already-existing DataSet methods). The SP does not have to do *everything* and in fact, may not be suited to do *everything*.
The only statement that *I've* made regarding SPs being "best", is that most DBAs want to limit access to the database through SPs only. I don't remember what others have said or implied, but this is that *I* meant by it.
~~Bonnie
>
What about them? So what?>
>Well, did you see the part/s about in-memory processing? Until now, in-memory processing has been seen as undesirable in NET because "it's best" to do it in a SP. You've said it yourself. Are you still firmly adherent to that thinking or are you able to engage other possibilities?
>
>As for the CTP- I've commented on it and advised people to look at it, and now you're asking whether I've done so myself. The question is demeaning and does not warrant a response. However, to prevent you escalating the attack, let me respond: "of course I've grabbed the CTP. Not the Beta, the CTP." OK?