• .NET

    LINQ Tip of the week: LINQ and Fetch Plans

    Today’s post will discuss one of the most interesting topics in LINQ to OpenAccess ORM and that is of course the proper use of the Fetch Plans functionality. If someone still wonders why Fetch Plans are so interesting when we talk about LINQ the answer is simple – they can boost the performance of your queries in times! When one decides to use a fetch plan he/she always defines one or more fetch groups that are going to be used as part of it. Those fetch groups are containing only the fields that we want to select when we...
    December 02, 2009
  • .NET

    Quick peek at the new OpenAccess class name generator

    A very common concern in Telerik OpenAccess ORM (as well as almost every other ORM product on the market) is how the names of the classes that represent your database tables are formed. Basically the mechanism for generating such names follows a simple pattern – the database table name is in plural form and the class name in the model is in single form. However, in the past OpenAccess covered a really small area of all the rules present for singularizing a given word. As of Q3 2009 this is not an issue anymore. We have implemented a simple, yet powerful...
    November 25, 2009
  • .NET

    How to map references and collections – Part 2

    In the first post we have described the ways to map a foreign key reference in the database to a reference, a collection or both in memory. This post continues the topic with the ways to map a join table. A join table is necessary if an m:n relationship has to be stored, but it also can contain the ordering inside a collection or the content of a dictionary. Let’s start with a simple join table in the database schema. Typically a join table contains two foreign key references, one to the left and one to the right table. 1) The natural way...
    November 24, 2009
  • .NET

    New Demo Web Site for Telerik OpenAccess ORM

    One of the most demanding tasks we always had at the Telerik OpenAccess ORM team, is to demonstrate to our customers and the whole ORM community the capabilities that our product possess. They say a demo is worth 1000 words. I can’t agree more with that. In the case of our product though I would like to add: a video is worth at least for 10 demos. That is the reason why we built a brand new video-oriented web site where we have carefully described each of the most important features (and their count is growing) and all the effort necessary for...
    November 18, 2009
  • .NET

    Using Connection Strings with Telerik OpenAccess ORM

    As you might already found out, with the 2009 Q3 release of Telerik OpenAccess ORM we made the first step of providing an easier and more natural way of defining database connection settings for your applications. In other words, OpenAccess now supports standard ADO.NET connection strings. The aim of this post is to brief you how to use them with the product. To use Telerik OpenAccess ORM in a Visual Studio project, you should run the Enable project wizard first. A detailed article on how to use the wizard can be found in our documentation. Let’s just see what is new in this release....
    November 17, 2009