Research And Application Of Enterprise Development With Object Relational Mapping

The Object oriented Model is built on methodology, while the relational data model is on basis of the set theory. The difference principal between the two models leads to the dispatch problem. In order to deal with this problem, the Object Relational Mapping approach is proposed to unify the objective model and relational model, providing a way of data interchange between objects and relational database. On the other hand, it is the need for the development of enterprise application to part the business process model description and relational data operation by conducting the relational data operation in accordance with object.Compared with data objects, data in relational database is managed in the form of rows, not in object oriented approach, which results in complexity, poor flexibility and weak reusability. What is more, the traditional database driver handles data by collection of rows which requires converting object data to relational one for persistent storage. In order to solve this Object Persistence Problem, this paper sets up a lightweight framework for object relational mapping on .NET platform according to practical experience. Furthermore, the whole business process model is abstracted into two layers, which helps to construct a loose coupled framework with free migration among different database and flexible adjustment of operations.Compared with the traditional development model, this Object-Relational Mapping framework maintains the automatic management of persistence class entity, which has the following advantages: Firstly, it packages operations on database transparently and provides completely object oriented data persistence function; secondly, it decouples business models and database operations, which describes the business process clearly and reduces system maintenance costs; thirdly, it helps to analyze the whole system at a higher abstract level by dissociating system into loosely coupled relationship, hence expands the system with greater capacity and reusability.