Swapping the DAL Abstractly

March 2008
S	M	T	W	T	F	S
« Feb		Apr »
	1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31

March 12th, 2008 |

Author: Dave

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:

LeapFrog Leapster Learning Game Go Diego Go!Al rescate! Diego is at it again - dodging obstacles as he hang-glides and snowboards to the rescue of animals in need. Explore the landscapes of Lati... Read More >

Don't Mess With Me... Programmer on Long Sleeve Women's Cotton T-Shirt (in 9 colors)100% preshrunk heavyweight cotton; double-needle stitching throughout; seamless rib at neck; shoulder-to-shoulder tape; heather grey is 90% cotton, 10% polyester; fashion cut; 5/8" rib collar; fitted tapered sleeve.