ASP.NET MVC: MVC Storefront, Part 4 – Linq To Sql Spike

In this webcast I dive pretty deep into Data Access and talk about some architectural decisions I need to make, specifically how to get Linq To Sql to map to my model properly. I also go over some feedback I received at the MVP summit last week.

In this webcast I dive pretty deep into Data Access and talk about some architectural decisions I need to make, specifically how to get Linq To Sql to map to my model properly. I also go over some feedback I received at the MVP summit last week.

Previously, On The MVC Storefront

  • Part 1: Architectural Discussion and Overview. I cover the initial architecture here, in part 1, where I discuss the Repository Pattern with Ayende Rahien and Steve Harman. I also ask Phil Haack what’s first: The Test Chicken or the Model Egg.
  • Part 2: The Repository Pattern. I walk through our Repository implementation and write out the first main set of unit tests. I also  structure up the initial service layer methods and interfaces.
  • Part 3 Pipes and Filters: I discuss the feedback from Parts 1 and 2, and then dive into the Pipes and Filters implementation on the IQueryable repository.
  • The Code is downloadable from here

Small Intermission
I was at the MVP Summit last week and didn’t intend on taking a whole week off of the screencasts – but I’m happy I did. I talked at length with Ayende, Aaron Jensen, Rick Strahl, Phil Haack, and many others about some architectural issues I’m facing.

Nine Inch Nail Time
Steven Harman suggested I run a Spike (a quick prototyping exercise to test out a theory) to make sure that my data access strategy will work with an actual database. Good idea.

I quickly ran into some issues with Linq To Sql, but found some neat ways to keep things clean and tidy so I don’t explode my database all over my happy little application.

Keep It Coming
Your feedback is critical, and I’m hoping for a lot of it with respect to the emerging data access pattern. As always, please leave me as much detail as you possibly can!

Finally, the editing is a little choppier than I wanted – hopefully you can forgive the rough edits!

Note: I’m going to add a Silverlight link here when the service is up and running. It seems that it’s offline right now as I can’t get my video to process :p.

Download the WMV File (15 mins, 18M)

Technorati Tags: