• .NET

    Building Real Applications with Telerik MVC & OpenAccess – Introduction

    Hi every one, I want to take a moment and introduce you to a series I will be writing here on Telerik blogs.  I will be creating an MVC2 application utilizing Telerik MVC extensions, Open Access, and jQuery.  The goal is to discuss real world problems that are faced when building this type of application, and to show solutions to these issues. It will start with building a model, then the DAL, and then move onto UI issues.  I will also show ways to handle large record sets with OA fetch plans/caching, and show some tips/tricks to help keep the UI...
    February 04, 2010
  • .NET

    OpenAccess ORM Second Level Cache API

    OpenAccess provides you not only with one, but two caches for persistent objects. The first level cache is the cache that directly supports the IObjectScope and that is responsible for the uniqueing of database references. That means, it is responsible to assure that there is only one physical instance per logical database entity: Equal foreign key reference values lead to a consistent representation in memory so that no duplicate representation of a single database row exists within an IObjectScope. This cache also holds the modified objects in a scope. The first level cache is always present and there is a...
    January 21, 2010
  • .NET

    Handling multiple database connections with Telerik OpenAccess ORM

    Very often it is necessary to work simultaneously with more than one database. In such cases it is recommended that each database is mapped to a separate class model residing in its own assembly. The object scopes that handle the persistent objects should be obtained from an instance of the Database class which represents particular database on the server. To make this process easier Telerik OpenAccess ORM generates a helper class named ObjectScopeProvider. How to benefit from this class will be described later in this post. To explain practically how to configure the Visual Studio projects, consider the case of having...
    January 20, 2010
  • .NET

    Using shared columns with Telerik OpenAccess ORM

    Telerik OpenAccess ORM always implemented relations between entities as reference properties (you can have properties on the both ends, or just on the one you decide) and this was the only supported way until now. Starting from Q3 2009 release we also started to support relations that are based not on reference properties, but rather on properties that expose the foreign keys for the entities. This pattern proved to be very useful for Linq To Sql, despite the fact that it is considered a ‘bad practice’ in the OOP domain. With the latest release of Telerik OpenAccess ORM we...
    January 08, 2010
  • .NET

    Dynamic Query with Telerik OpenAccess

    With the introduction of LINQ the concept of querying data became a first-class language construct in C# and Visual Basic.  LINQ enables to you write type-safe queries which are checked during compile-time. While type-safe queries are fine for certain situations, there might be cases where you want to construct a query on the fly, at runtime, based on certain selections made by the user. This is usually done using a string-based representation of the query. How can this be achieved via LINQ?   The LINQ team at Microsoft provides the Dynamic Query Library which extends the core LINQ API with capability to use...
    December 28, 2009