HOL and additional help

Topics: Web Client Software Factory, User Forum
Sep 16, 2008 at 3:59 PM
I've gone through several of the HOLs and they are quite impressive.  But one thing that I noticed is that they lack some real db interaction.  THe documentation either says, we'll load it into memory, or an entire XML document is loaded from the file system.  What I'm looking for is a good example of loading data from a db (sql express?) when it's needed.  It's nice that the entire XML document is loaded at once, but what about handling loading orders from the db for the admin page, but only when you get to the page, not when the app is started.  Or loading just the catalogue when you go to display the items. 

I've messed with using a datatableadapter in the xsd to try and connect it to a db, but getting the module data to load is proving problematic.

If there are examples of this could you please link to them.

Thanks,
Mike
Coordinator
Sep 17, 2008 at 8:21 PM
To make things easy for developers to get up and running quickly, we made a conscious decision to ignore the data access layer as much as possible, and created the xml file based system.  However, we hid this implementation behind a repository interface, so you could replace the implementation with a "real" one if you wanted.  We originally created the interface (and the generated repository implementation that we threw away) with the Repository Factory (http://www.codeplex.com/RepositoryFactory), which may be a good place to start.  Another place to look would be Enterprise Library's Data Access Block (http://www.codeplex.com/entlib).

While neither of these is exactly what you were looking for, I hope that they help a bit,
Michael Puleio -- patterns & practices
http://blogs.msdn.com/mpuleio/