Good day fellow coders, I recently started to build n-tier applications (Presentation Layer, Business Layer and Data Access Layer) in C# and all is well. Until I came to data access layer, at the moment my DAL is static in the sense that for each table in my database I have a data access layer with the different select, update, delete and insert statements for that table for example I have a client data access layer and an order data access layer. Now the question I have is how to make a data access layer dynamic in other words only to use one dynamic data access layer which contains dynamic methods all the business layers can use to select,insert,update or delete data. Put simply I wish to use only one DAL instead of multiple for each table in the database. The purpose is for re-use ability. Please try to help. I would appreciate it!