LINQ to SQL supports the ability to call Stored Procedures
and UDFs within the database and nicely integrate them into our data
model. In this blog post I demonstrated how you can use SPROCs to easily
retrieve data and populate our data model classes. In my next blog post
in this series I'll cover how you can also use SPROCs to override the
update/insert/delete logic when you SubmitChanges() on your DataContext to
persist back to the database.
Hope this helps,