.NET Answers

Last Thursday, we looked at how to replace the TableAdapter with our own TableAdapter as a way or eliminating our dependence on Microsoft SQL.  The problem with this implementation is that every time you want to switch databases, you’ll need to switch what TableAdapter the code is using.

Under normal circumstances, this isn’t an issue.  Most of us pick a database and stick with it.  But, there are times when we’d like to be able to have our product support multiple databases.  Maybe we have a Windows application that will work fine using an Access database for example, but we know that in larger installations they’d be much happier with a SQL implementation.  Or maybe we have customers that have a religious conviction toward a specific implementation of SQL.

Today, I’m going to show you the first step in how to write your code in such a way that the BLL will not need to change every time you switch the DAL.

Other Related Items:

Hitachi KC18DG6L 18-Volt Lithium-Ion Tool Combo Kit, 6-PieceBacked by Hitachi's industry-leading 10-year Lithium-Ion Tool Warranty, the Hitachi KC18DG6L 18-Volt Lithium-Ion Six-Tool Combo Kit includes the DV18D... Read More >

Rush - Beyond the Lighted Stage [2 DVD]Studio: Uni Dist Corp (music) Release Date: 06/29/2010

Ciao! (with Audio CD)CIAO!, Sixth Edition continues to emphasize practical, communicative use of Italian, while teaching the four language skills and providing an enhanced... Read More >

Related Post

• Using Reflection to Load a Class in ASP.NET
• DataSets, ObjectDataSource and 3-Tier ASP.NET
• Transaction Tracking Typed Datasets Using SqlTransaction
• ASP.NET/VB.NET – Video Training
• Mixing ASP.NET, jQuery and JSON

Bookmark to:

Hide Sites

One Response to “Swapping the DAL Abstractly”