Data access layer: Difference between revisions

Revision as of 01:10, 14 December 2006

Revision as of 20:39, 19 March 2007

Line 5:

This Data Access Layer is used in turn by other program modules to access and manipulate the data within the data store without having to deal with the complexities inherent in this access.

For example, the DAL might return a reference to an [[object (computer science)|object]] (in terms of [[object-oriented programming]]) complete with its attributes instead of a [[row]] of [[Field (computer science)|fields]] from a database [[table (database)|table]]. This allows the client (or using) modules to be created with a higher level of [[abstraction]]. This kind of model could be implemented by creating a class of data access methods which directly reference a corresponding set of database stored procedures.

Consider that you have to interact from a specific table in the database (like insert, delete, update)then you just create a class and a few stored procedures in the database, where you call those Stored Procedures from a method inside the class. and class in return on the coding side will return an object containing the requested values.