About separating database layer from UI layer

Question

I am creating a N Tier application in WPF. I wanted to make UI layer and Database layer separate. When it comes to separation of DB layer I wanted the Db layer to be generic and able to support all databases. I was thinking of using Application Block for this. I just wanted thoughts about the best way of making DB layer generic to support all sorts of databases.

Satish Bhat · Answer

Easiest way to achieve your goal is to use the Enterprise Library Data Access Application Block (DAAB). DAAB can support multiple DB type for your DAL. It can support SQL Server Oracle primarily. Also it can support MySQL but you have to rebuild it . But for Ms Access probaly you have to extend the DAAB . Basic way to support multiple data stores is to use the Provider Model Design Pattern. You can do it yourself also.