You'll still have SQL and stored procs, that's in the business logic(BL) layer. But if you step outside in the UI layer, the UI might not need the entire List<T> brought back by the BL and if I remember right you can use Linq to chew down that list to something you'd need in the UI.