Data Access Layer Design

Arjun Priyananth posted at 04-Jul-08 01:16

Hi,

I need to create a Data access layer for my application. This is what i have in my mind.

A class called SqlDataProvider.cs or OracleDataProvider.cs this class will have the necessary functions for DB communication. (ExectureReader, ExecteDataset etc)

in the same level another class Called MyAppDataProvider.cs which derives the above Data provider. and this this class will not  have any functions implemented in  it. its just a derived class. Then, in the same level I will be having the relevant categorized classes like UserManagementDataProvider.cs which will derive the MyAppDataProvider.cs class. So, my business layer always creates a instant of UserManagementDataProvider class to communicate to DB. is this way is correct..? can u suggest me an another efficient way with some sample please. I feel deriving classes makes the object more weight.

 


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Data Access Layer Design - Arjun Priyananth  04-Jul-08 01:16 1:16:42 AM
      Implementing data access functionality - Deepak Ghule  04-Jul-08 01:25 1:25:00 AM
      Implementing data access functionality - Deepak Ghule  04-Jul-08 01:25 1:25:36 AM
      Implementing data access functionality - Deepak Ghule  04-Jul-08 01:25 1:25:45 AM
      Designing Data Access Layer - kalit sikka  04-Jul-08 02:05 2:05:18 AM
      Designing Data Access Layer - kalit sikka  04-Jul-08 02:07 2:07:49 AM
      DAL - santhosh kumar  04-Jul-08 02:21 2:21:11 AM
      Data Access Layer Design - Sanjay Verma  04-Jul-08 05:03 5:03:47 AM
View Posts