My web application is based on the model described in the infamous Data Access Tutorials by Scott Mitchell. However, to my knowledge, he never addresses any of the Many-to-Many relationships found in the Northwind database.
I have been searching for days (with no success) to find any examples, tutorials, books, or anything that describes how to work with many-to-many junction tables (like working with the Order and OrderDetails tables in Northwind) in the context of Scott's model (which uses and XSD file and Table Adapters for the DAL).
I have come across some examples using Entity Framework, or using LinqToSQL, but so far, nothing using Scott's model.
Can anyone point me towards some resources (free or otherwise) that can be of help? Or do any of the Starter Kits use the same basic DAL model that Scott used in those tutorials? (or at this point in time, would it be better to develop my DAL using EF4?)
Thank you for your time!
View Complete Post