Research And Implementation Of ORM Component In .NET Platform

Today, the Object-Relational Mapping (ORM) has become a new hotspot in the field of software engineering. The application of ORM can reduce the coupling degree between the business and data greatly, improve the system's expansion and maintainability. At the same time the developing efficiency is also improved. Using ORM component in application is equal to erecting a bridge between relation model and object model. It can free developers from rudimentary and repeated work, and make them have more time to pay attention to the real commercial demand.In this paper, combined with the actual need of a Department's office automation project in Guangdong Province, a suit of Lightweight ORM Component (LOC) model based on Dot Net platform is proposed. One LOC is designed and realized. Around the realization and study of LOC, the following contents are studied in this thesis.1. Theoretical research of the object model and the relation modelThe concept and theoretical foundation of the object model and the relation model is studied. Moreover the reason which causes the problem of "impedance mismatch" between the object model and relation model is also discussed deeply.2. After studied ORM component technology in deep, the thought of LOC is proposed. Based on the analysis and comparison to the key technology of ORM component, which ismapping object to relation technology and object identification technology, the thought of LOC is proposed. That is, under the condition of fulfilling the major requirement of project, we simplified the ORM component.3. MYORM-the lightweight ORM component based on Dot NET platform is designed and realized.Combined with the actual project, we analyzed the characteristic of government's office automated system and the problem of changing demands frequently. MYORM is designed and realized based on Dot NET platform. Its can carry on some functions such as basic CRUD operation, simple condition's query and affairs control. It can low the cost of component to maximum degree under the condition of satisfying the most requirements of government departments of office automated system and reducing the disadvantage influence of changing demands.4. Application and test of MYORM componentThe configuration of MYORM component is introduced. The test code of CRUD operating, simple query and transaction processing is compiled. At last, MYORM component is tested by Nunit.This component has already been applied in the office automated system of one company in Guangdong Province and has made a good effect.