Is there a reason you aren't using Entity Framework? It makes things much easier for data access.
Sep 05, 2012
I think this is a good question, I don't have a answer yet though. It would be nice to have a version of the Patterns in Action project for just a single choice of the technologies. I guess they have not done it since they would have to create a solution for every possible combination to keep all users happy. One part you would have to look at is the DataAccess class, you would need to remove this and replace it with direct use of the ADO.NET ADO classes. A slightly related question, have you read the "Building standalone ASP.NET applications" section in the Patterns In Action 4.0 PDF? Would you need to use web services or could you use the direct access method suggested in this section?
Sep 01, 2012