The Design And Application Of R2O Framework Base On Lightweight ORM

As a new develop pattern, object-oriented design and development has beenaccepted by people. As an design pattern to data object Persistence Layer, ORM(O/RMapping) solves the problem that is not match between traditional relationaldatabase and object-oriented design pattern. More critical, it encapsules getting andsetting data from the database, the business logic layer can ignore the changes ofdatabases and do their business logic directly, which increase the readability andreusability of the program.But there are some shortages in ORM techonlogy at present. From a structuralpoint of view, they are so complex that user cannot know its structure inside, whenaccident exceptions from the inside occur, it cannot be soloed. From a functionalpoint of view, current techonlogy cannot give good solutions to solve some ORM’sproblems itself, such as cross-table search and deleting problem of the foreign key inmaster-subordinate table. Form the operational point of view, an ORM beginner needto take much more time learning the complex syntax and configure process, whendeveloping the small project, using ORM might complex the project. Judging fromthe high-level call, Existing ORM framework design makes high-level can notcompletely get rid of cumbersome SQL statements.In this thesis，we describe in detail the reason for ORM and the advantage of thedesign pattern using MVC, then describe the typical lightweight ORM frameworksolutions such as Hibernate in Java and LINQ TO SQL in.NET and then find theiradvantage and disadvantage through analysis, and then design and implement anexpertise of data object persistent layer called R2O (Relation To Object) in.NETplatform and using Visual Studio2008as its development tool follows myexperience of actual projects that improve greatly project’s programming. It alsogives many solutions to solve problems in traditional ORM such as how to operate inmulti tables or cascade query.The thesis analysis in detail the implementationprocess and advantage or disadvantage, then takes an project to explain the use ofR2O, finally it evaluates the work about this thesis objectively, and prospects thefuture direction of R2O and ORM technology.