Swapping Out the DAL

One of the comments that showed up on the blog post about using 3-tiered with DataSets and the ObjectDataSource was, “How do we set this up so that we can swap out the DAL?”  The simple answer to this is, “roll your own Table Adapter.”

Today’s video is the first installment of how you might do that.

Like this Article? Subscribe to get every article sent to your email.

Related Post

  • One Form with Multiple TablesOne Form with Multiple Tables I received the following question a few days ago: “I am trying to use three tables from the same dataset in one form that I am creating in vs.net winforms my problem I guess is the setup […]
  • DataSets, StoredProcedures and 3-Tier ASP.NETDataSets, StoredProcedures and 3-Tier ASP.NET Last Friday I showed how to use DataSet, the ObjectDataSource and select statements.  Today, I'll start with the project we ended up with last week and convert it to use stored […]
  • DataSets, ObjectDataSource and 3-Tier ASP.NETDataSets, ObjectDataSource and 3-Tier ASP.NET As I've mentioned in other post, while I think LINQ has it's uses, I still favor the use of the ObjectDataSource control in conjunction with DataSets and a 3-tiered architecture.  […]
  • DataSets, TableAdapters, and Transient Retry Logic For SqlAzureDataSets, TableAdapters, and Transient Retry Logic For SqlAzure The main project I’m working on these days is moving several web sites to Azure.  It is something I’ve wanted to be able to try for a while.  I’m working with several other agencies on […]
  • Using DataSets to Process XMLUsing DataSets to Process XML I started a project recently that requires me to process an XML file from Google. Being the lazy sort, I'd really rather just use the data as though it were part of a database and forget […]

About Dave Bush

Dave Bush is a Full Stack ASP.NET developer. His commitment to quality through test driven development, vast knowledge of C#, HTML, CSS and JavaScript as well as his ability to mentor younger programmers and his passion for Agile/Scrum as defined by the Agile Manifesto and the Scrum Alliance will certainly be an asset to your organization.

One Pingback/Trackback