Telerik blogs
  • Release

    New and Updated OpenAccess ORM Resources Available

    As we are constantly trying to make the Telerik OpenAccess ORM learning resources and documentation better and easier to use, we have made some changes that you might find very useful. Getting Started Videos Recently we released two sets of entry level videos on working with Telerik OpenAccess ORM. You can choose your scenario between Database First or Model First approach the short series of 2-3 videos will guide you from creating your model to updating your changes to/from the database. Check them out and don't forget to LIKE them. Feel free to post some feedback about your learning experience either here or in YouTube! Online...
    October 20, 2011
  • Productivity

    Bend Telerik OpenAccess ORM to Your Will With Type Converters – Part 2 : Enums

    In my previous blog I showed the basics of using Type Converters in OpenAccess ORM.  I even walked through creating a very basic type converter for storing an int as a varchar in SQL Server.  The example converter was very basic, so in this blog I would like to take a look at something a little more practical.  In this example I will create a converter that tells OpenAccess ORM to store the value of an Enum property using the enum value’s name. Out of the box OpenAccess will persist enum’s using the enum’s underlying type which by default is int. In...
    October 13, 2011
  • Release

    Telerik OpenAccess ORM, MVC Extensions, and Dynamics!

    While playing around with OpenAccess the other day, I wondered if it would be possible to have OpenAccess return a dynamic list, and if so, could I bind it to an MVC grid without specifying any columns names.  This could prove to be helpful in some reporting scenarios, where you just want the grid to output whatever a sproc, or query, returns.  This blog shows how to accomplish just that! Step 1 To accomplish this task we will be taking advantage of the ADO API we released in Q2 2011.  To start out I simply created an extension method for the OpenAccessContext, which...
    October 05, 2011
  • Productivity

    Project Templates in Telerik OpenAccess ORM

    As we mentioned in our recent post we added new project templates to Telerik OpenAccess ORM, making it easier than ever to get an application up and running. In this blog we will take a look at each of the new templates, see what they provide, and see how you can leverage them with other Telerik Components. Using the Templates These templates are for .NET 4.0; so when adding a new project make sure that .NET Framework 4 is selected in the drop down above the project template list. Web Site Template To make it easier for developers using Web Site projects, we added a...
    September 27, 2011
  • Productivity

    Bend Telerik OpenAccess ORM to Your Will With Type Converters – Part 1

    In Q1 2011, Telerik OpenAccess ORM introduced a flexible type conversion system. This type conversion system allows developers to instruct OpenAccess on how to map types that it may not support out of the box. This feature makes it possible for OpenAccess to work with built in UDTs, such as SQL Spatial and XML, as well as any custom UDTs developers create. What is a User Defined Type? SQL Server 2005 introduced user-defined types (UDTs). UDTs extend the SQL type system by allowing you to store objects and custom data structures in a SQL Server database. UDTs can contain multiple data types...
    September 20, 2011