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,...

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...

We believe that the fastest way to learn how to use an OpenAccess model in your ASP.NET MVC 3 application is to watch a video tutorial. Therefore we have prepared some videos, guiding your OpenAccess ORM integration in an MVC project step by step.

Of course, there are different approaches to that based on your needs and personal preferences – you might want to use the strong capabilities of our Visual Designer Database-First scenario to create your Domain Model or you can map everything using our Fluent Mapping API. In any case, each of the dedicated video series will guide you through the...

As a response to your constant requests for sample projects demonstrating the best practices of using OpenAccess ORM in web projects, we have released some of the new and updated samples before Q1 2012 so that you can benefit from them immediately.

MVC developers will be happy to know that along with the MVC 2 example “MVC Forum”, we are now offering two solutions demonstrating MVC 3 usage with Fluent API or an .rlinq Domain Model – whichever approach you prefer. In addition, you can see an implementation using the Razor view engine as an alternative of the default one. Find the...

First I would like to apologize for the extreme delay in publishing this blog!  I was trying to see if it would be possible to salvage the video recording.  Unfortunately, due to the way I recorded it, audio was not captured properly.

With the bad news out of the way, I would like to say, most of the OpenAccess content is covered in a session I did at DevConnections this year, and is available on TTV here.  As for the other topics we covered, feel free to send me an email, and I will do my best to point you...

I want to thank everyone that joined me on Monday for the What’s New in Q3 2011 for Data Tools webinar.  We had a lot of great questions, and saw many of the new awesome features available in Telerik Reporting and OpenAccess ORM for Q3.  In such a short time span it is not possible to cover everything; so make sure to stay tuned to my blog, or the team blog.  Over the next few weeks we will cover even more of the awesome Q3 features!

For those of you that missed out on the fun, the webinar is now live on Telerik...

With the Q3 2011 release of Telerik OpenAccess ORM we introduced three connection pool types which are explained in this blog post. In this blog post we will have a look at the connection pooling behavior of the Oracle driver and what setting to be used when we want to use Telerik OpenAccess ORM with Oracle databases.

Which setting for Oracle and why?

When we want to use Oracle as our backend, it is advisable to use the connection pool type Open Access Connection Pool with OpenAccess Connection Management or the Ado Connection Pool setting. When using one of the two settings, we...

Before Q3 2011 was live we have introduced you one of the major new functionalities you can find in the release – the new Stored Procedure Editor. It is the tool that allows us now to present our stored procedure support as feature complete.

Along with the visual interface the Editor is offering, we have enhanced the functionality that was available in previous OpenAccess ORM versions generating automatically methods in the OpenAccessContext that are calling stored procedures. The old version of this code generation used to produce methods such as this one: