ISSN: 2319-8753 International Journal of Innovative Research in Science, Engineering and Technology (An ISO 3297: 2007 Certified Organization) Vol. 3, Issue 8, August 2014 DOI: 10.15680/IJIRSET.2014.0308017 Copyright to IJIRSET www.ijirset.com 15185 Object Relational Mapping Tool for C#.NET Framework Kuldeep Hule 1 , Zakir Shaikh 2 P.G. Student, Department of Computer Science & Engineering, Nagesh Karajagi Orchid College of Engg. & Technology Solapur University, Solapur, Maharashtra, India 1 Assistant Professor, Department of Computer Science & Engineering, Nagesh Karajagi Orchid College of Engg. & Technology Solapur University, Solapur, Maharashtra, India 2 ABSTRACT: Object relational mapping from relational databases has become topic to be dealt with in the recent decade. Object Relational Mapping is a layer which is responsible to bridge the gap between object-oriented programs and relational database. Lot of new Object Relational Mappers have been developed which includes forward engineering as well as reverse engineering approach for developing the object code. In this paper we are proposing the method of reverse engineering for developing object code file. KEYWORDS: Object relational mapping, relational database, impedance mismatch, entity I. INTRODUCTION Information Technology (IT) systems need persistent storage (unless, of course, the systems are really trivial). This persistent storage usually comes in the form of a relational database, such as Oracle, Microsoft Structured Query LANGAUGE (SQL) Server, IBM DB, and likewise. There are several alternatives to RDBMSs; for instance, object- oriented databases (OODBs) e.g. db4o, persistent object stores (Prevayler, XML databases etc.). However, at least until now, all these alternatives haven't really caught and the fact is that Relational Database Management Systems (RDBMSs) remain pretty much ubiquitous. Also nowadays, the object-oriented programming is already widely accepted approach for the development of business applications. Object-oriented development provides more suitable methods and facilities for modelling of the real world objects than e.g. the paradigm of structured programming. Relational databases [10] and object-oriented programming languages are based upon distinct paradigms, with technical conceptual and cultural incompatibilities. The set of those incompatibilities is commonly referred to as the object-relational impedance mismatch problem [8]. Object-relational mapping (ORM) frameworks address the impedance problem of software implementation level [6], providing the developer with ways to declare how each technical incompatibility should be treated [6]. ORM tools brings to the same level relational resources, such as data querying and object-oriented resources, such as inheritance, polymorphism, enabling to explore synergy between those constructs [4]. Object relational mapping (ORM) in computer software is a programming technique for converting data between incompatible type systems in databases and object-oriented programming languages. This creates, in effect, “virtual object databases” which can be used from within the programming language [ 1]. In other words, Object Relational Mapping hides the underlying tables, SQL etc., inside the RDBMS. Due to the popularity of relational data storage with its broad installation base and the use of object-oriented concepts for software development, application objects inevitably need to be stored into (object) relational databases [7]. 2.1. Impendence Mismatch The impedance mismatch problem is a well-known problem in persistence objects in relational databases between both the object model and the relational model and between the object programming language and the relational query language [5]. Object oriented development is based on concept of data & their behaviors, while the relational databases