An object relational mapper is about developer productivity, about the ability to quickly and easily make changes to your model, about integrated change tracking, caching and moving to other databases easily. It is also about speed. In this blog post I will try to explain the most common questions about OpenAccess in regards to performance and how you can improve it. The OpenAccessContext When using OpenAccess you always start with a type that derives from OpenAccessContext. Creating an instance of that type is a lightweight operation, typically in the order of a dictionary lookup. Then you execute your first LINQ query, and...

In previous versions of OpenAccess ORM, configuring large data models could be a bit cumbersome. However, I am happy to say that in Q1 2012 we are adding a new batch operation dialog, which makes configuring data models easier than ever! Using the Batch Operation Wizard, developers can efficiently make updates to several entities, or members, in a single operation! To launch the batch operation dialog, right click on the visual design surface, and select Batch Operations. This menu item launches the new wizard: On the left side of the wizard is a search area. This allows developers to search for entities, or members,...

  As many of you probably know already, we are going to release Q1 a month earlier this year (in mid-February). As the release date is approaching we are proud to show you the improvements in the product we have developed in the last several months. Following your feedback and advices, we have dedicated this version mostly to usability and optimization of the time you spend working with large Domain Models.   Batch Operations Dialog We have acknowledged that if you have hundreds of domain classes or tables with plenty of columns, modifying your model can sometimes become a boring and lengthy task. In...

Besides the currently trending MVC framework, the traditional Web Forms are widely used for web applications development, so probably many of you are already familiar with them. OpenAccess ORM is an excellent choice for your Data Access Layer in such situation, as it is easy to integrate in just a few steps. We have already explained those steps in our new ASP.NET Development Guide, but we figured a visual representation of the same will be a faster and more pleasant way of learning what you need to know.   We have created two separate videos: for developing a Web Site using a Model First approach...

As many of you may know, KendoUI is a really awesome new JavaScript framework that combines everything needed for modern JS development into one sweet package.  One of the features it provides is the ability to bind different UI controls to various data sources; so in this blog I will show you how OpenAccess ORM can be leveraged on the backend, and KendoUI can take care of the front end! Getting Set Up To get started create a new ASP.Net Empty Web Application. Note: You can really use any web based project template you like, in this walkthrough I just chose to start with nothing. :) Once...