Support & Learning
Application Development and Deployment
Data Connectivity and Integration
Web Content Management
Get A Free Trial
close mobile menu
Testing & ALM
Tag: Data Access
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
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
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
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
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
Testing & ALM
Latest updates in your inbox
Cooking with ASP.NET Core and Angular
July 26, 2017
July 21, 2017
How a Reporting Solution Can Solve Your Business Needs
July 27, 2017