Data access layer class generator
Systems and methods that that automatically generate a data access layer for a middle tier of a relational data store with stored procedures, via a data access layer generator. The data access layer generator can employ an extensible mark up language extension (XML) to determine the stored procedures that are typically exposed to the access layer. Such an arrangement can facilitate data access in a relational database with stored procedure. Moreover, information about the database can be stored in one place, to mitigate a risk for such information being out of sync with that maintained in the middle tier.
1. A system that facilitates data access to a database comprising:
a generator that automatically generates a data access layer based on a configuration file and stored procedures in a database and,
a middle tier component that employs the data access layer to access the database.
2. The system of claim 1 the configuration file is an extensible Markup Language (XML) file that acts as a declaration file to delineate an Application Program Interface (API).
3. The system of claim 2 the XML configuration further includes coding conventions to transform parameters from a transaction Structured Query Language (SQL) basis to a Net framework.
4. The system of claim 3 further comprises a code that bridges a gap between a SQL and a .Net framework.
5. The system of claim 4 , the code is C#™ code.
6. A method of accessing a database comprising:
parsing an XML configuration file by a data class generator;
coordinating data in the file with stored procedures stored in the database; and
automatically generating a data access layer for a middle tier by the data class generator.
7. The method of claim 6 further comprising accessing the database middle tier.
8. The method of claim 6 further comprising generating codes to create commands to invoke a stored procedure in the database.
9. The method of claim 6 further comprising automatically fetching parameter commands for the stored procedures from the database.
10. The method of claim 6 further comprising outputting comments that document a procedure that invokes stored procedures.
11. The method of claim 6 further comprising defining a data access class for the data access layer.
12. The method of claim 6 further comprising retaining one of a result set and a non-result set from the database.
13. The method of claim 6 further comprising creating a preamble code.
14. The method of claim 13 further comprising mapping stored procedure names to object oriented programming names.
15. The method of claim 6 further comprising capturing parameters associated with output parameters invoked from the stored procedures.
16. The method of claim 15 further comprising passing the captured parameters to a client tier.
17. A system that facilitates data access comprising:
means for generating a data access layer based on a configuration file and stored procedures in a database; and
means for accessing the database.
18. The system of claim 17 further comprising means for delineating an Application Program Interface.
19. The system of claim 17 further comprising means for transforming parameters from a transaction Structured Query Language (SQL) basis to a Net framework.
20. The system of claim 17 further comprising means for bridging a gap between a SQL and a .Net framework.