Telerik blogs
  • Release

    Quering Spatial Data with OpenAccess in Q1 2011

    Starting with the 2011 Q1 release, OpenAccess supports development of applications that involve geometric or geographic data. For the sake of simplicity, this blog will focus on the use of SqlGeography with MSSQL 2008. Other databases (like Oracle) provide support for geometric and geographic data as well, but this shall be the topic of another blog post. Let's start with a simple model that has only two domain classes City and Country. Both classes should contain geographic information: the location of the City (as a point) and the polygon shape of the Country. Both domain classes then...
    May 27, 2021 4 min read
  • Productivity

    Different OpenAccess Versions Used in Development Process

    We hear a lot that migrating projects using OpenAccess to a new OpenAccess version is a complicated process. The first decision should be if you want to migrate each of your projects or if you want to stay for some of them with the old OpenAccess version. This post describes how to prepare your project so that an installation of a new OpenAccess version does not break your build or makes it necessary to use the new version in your older projects. The first step is to check-in all necessary runtime and compile time used resources instead of taking them from the...
    May 27, 2021 5 min read
  • Productivity

    Integrating Telerik OpenAccess ORM Spatial Data with RadMap

    You read that right!  In Q3 2010 OpenAccess ORM introduced new SQL Spatial Type support.  Which is awesome for those of us that love playing with spatial data :)  I started playing around with the new OA spatial support, and decided what better way to to demonstrate the capabilities than to output the data on to a map?  This blog covers how I accomplished this task :)   First We Need Spatial Data Some of you may already have spatial data sitting in a SQL Server DB, but if not never fear!   You can use the great Shp2Sql utility, made by Morten Nielsen, to import a...
    May 27, 2021 3 min read
  • Productivity

    Handling Schema Migrations

    If you have played around with the Fluent Mapping API you have most probably stumbled upon the issue of actually creating or migrating your database to the latest state. And while most tools suggest that schema operations should be performed during design time we give you the tools to either run them automatically or manually.  All you need to do in order to get your schema up to date is instantiate a context object and then access its schema handler. I have prepared a simple code snippet that makes sure every time I run my console application my database schema...
    May 27, 2021 1 min read
  • Release

    Upgrading projects made with Telerik OpenAccess ORM

    Whether you have just installed the new release of Telerik OpenAccess ORM or downloaded a demo that has been built with an older version of our tool, you most certainly have had to remove and add again your OpenAccess references in your existing projects. In order to make it easier we have provided the option of doing this automatically. However it seems like this functionality has not been found by too many users. It can be found in the OpenAccess menu Telerik -> OpenAccess -> Upgrade References. Executing this will, in a second, upgrade all the references to OpenAccess in all...
    May 27, 2021 1 min read