- OpenAccess ORM
-
OpenAccess ORM Developer(s) Telerik Stable release Q2 2011 (2011.2.713) / July 13, 2011 Written in C# Operating system Microsoft Windows Platform .NET 2.0, 3.0, 3.5 or 4.0 Type Object-relational mapping License Free or commercial Website OpenAccess ORM
OpenAccess ORM is an object-relational mapping tool (O/R mapper, ORM) and code generator for the Microsoft .NET platform. It provides a framework for mapping an object-oriented domain model to a traditional relational database. Its purpose is to relieve the developer from a significant portion of relational data persistence-related programming tasks.The tool operates within Visual Studio 2005, 2008, or 2010[1] and helps in creating the data access layer for desktop and web applications, based on the application's object model and the database used. It does this by mapping domain objects to database tables, and vice versa.
OpenAccess ORM is developed by the .net solutions provider Telerik.
Contents
Uses and benefits
OpenAccess ORM addresses the Object-relational impedance mismatch encountered when a relational database management system (RDBMS) is being used by a program written in an object-oriented programming language. Using OpenAccess ORM, .NET Framework-based developers can implement data access and data management with significantly less coding efforts. By following object-oriented concepts, OpenAccess ORM enables developers to focus on the business logic instead of time-consuming data access issues. Similar to all object-relational mapping tools, OpenAccess ORM automatically generates the needed SQL commands and relieves the developer from manual data set handling and object conversion [2]. A Visual Entity Designer allows for building and editing domain models and mapping objects visually, within Visual Studio.
The tool keeps the application portable to (and usable with) most databases, with no or little performance overhead, depending on the scenario. [3]
Features
- Map database tables to .NET classes (known as Database-first approach, Schema-First approach, and Reverse Mapping approach)
- Create database tables from .NET classes (known as Model-first approach, and Forward Mapping approach)
- Define model via classes (known as Code-first approach, and Fluent Mapping)
- Stored Procedure support
- Map from CLR data types to [[SQL] data types
- Data query and retrieval (CRUD operations)
- Transparent persistence for Plain Old CLR Objects (POCOs)
- Visual Entity Designer with numerous wizards
- Data performance profiling
- Database-independent code
- Full entity type inheritance
- Flexible concurrency mechanism
- LINQ support
- Disconnected Data support
- Caching support
- Medium Trust environment support
- Multi-tier Support
- Pre-fetch paths
- WCF Rich Internet application (RIA) Services support
Supported Databases
- Microsoft SQL Azure
- Microsoft SQL Server 2000, 2005, 2008, and 2008 R2 (incl. Express versions)
- Microsoft SQL Server Compact 3.5
- MySQL 5.x
- Firebird Server 2.x
- Advantage Database Server 8.1
- SQL Anywhere Server 10.x, 11.x
- Oracle Database Server 9.2, 10.x, 11.x (incl. Oracle Database 10g Express Edition)
- SQLite
- PostgreSQL 8.4+
- VistaDB
Supported .NET frameworks
- ASP.NET
- ASP.NET AJAX
- ASP.NET MVC
- Silverlight
- WPF
- Windows Forms
History
OpenAccess was first developed by Vanatec, a German company based in Munich which specialized in Object Relational Mapping (ORM) software [4].
On October 10, 2008 Vanatec was acquired by Telerik, a leading vendor of developer tools and UI components for .NET [5]. It was then that Vanatec OpenAccess was officially renamed to Telerik OpenAccess ORM, and was re-focused to target the .NET platform only.
The release cycle of OpenAccess ORM follows Telerik's release cycle of 3 major releases per year, with several minor releases (service packs) in between [6].
The latest version of the product is Q2 2011 (version 2011.2.713) released on July 13, 2011 [7].
See also
- Object-relational mapping
- .NET object-relational mapping tools
- List of object-relational mapping software
References
- ^ "OpenAccess ORM System Requirements". Telerik. http://www.telerik.com/products/orm/getting-started/system-requirements.aspx.
- ^ "Stop Hacking, Start Mapping: Object Relational Mapping 101". Code Project. http://www.codeproject.com/KB/showcase/object_relational_mapping.aspx.
- ^ "Question about the benefit of using an ORM". StackOverflow. http://stackoverflow.com/questions/760834/question-about-the-benefit-of-using-an-orm.
- ^ "Vanatec Releases O/R Mapping for Microsoft Visual Studio 2005". Source Wire. http://www.sourcewire.com/releases/rel_display.php?relid=23428.
- ^ "Telerik Acquires Vanatec and Adds ORM to Portfolio". Ajax Alliance. http://www.ajaxalliance.org/modules/news/article.php?storyid=209.
- ^ "Telerik moves to 3 releases per year". Telerik Blogs. http://blogs.telerik.com/blogs/posts/07-01-31/telerik_moves_to_3_releases_per_year.aspx.
- ^ "What's new in Telerik OpenAccess ORM". Telerik. http://www.telerik.com/products/orm/whats-new.aspx.
External links
Categories:- .NET object-relational mapping tools
- .NET programming tools
- Object-relational mapping
- C Sharp software
- XML data access
- .NET framework
- Free software programmed in C Sharp
Wikimedia Foundation. 2010.
