How do we switch from Telerik Open Access to anything else?

Thread is closed for posting
2 posts, 0 answers
  1. Dan
    Dan avatar
    12 posts
    Member since:
    Jul 2011

    Posted 19 Jan 2017 Link to this post

    Our company has been using Telerik Open Access for years. We have multiple projects using it including some in development and some in production that need updated. Because Telerik no longer updates or supports Open Access, we are having a variety of problems. We've got users that have to go to another work station because we can't get Open Access on their computers and we've got projects where we can't add or update tables because the visual designer doesn't work in modern Visual Studio versions. So my question is, how do we convert these and what do we convert these to?

    I've heard of Microsoft Entities Framework and we used to just call stored procedures instead of having a separate data project. Obviously our clients aren't going to pay us for hours to switch so we need something that works quick. How do we convert our existing Telerik Open Access project to Microsoft Entities Framework, straight SQL queries, or some other data layer option?

    Our company has been using Telerik Open Access for years. We have multiple projects using it including some in development and some in production that need updated. Because Telerik no longer updates or supports Open Access, we are having a variety of problems. We've got users that have to go to another work station because we can't get Open Access on their computers and we've got projects where we can't add or update tables because the visual designer doesn't work in modern Visual Studio versions. So my question is, how do we convert these and what do we convert these to?

    I've heard of Microsoft Entities Framework and we used to just call stored procedures instead of having a separate data project. Obviously our clients aren't going to pay us for hours to switch so we need something that works quick. How do we convert our existing Telerik Open Access project to Microsoft Entities Framework, straight SQL queries, or some other data layer option?

    Here's an example of what we have currently.

    A separate Visual Studio project that acts as our data layer where all the code was created by Telerik Open Access's visual designer:

    enter image description here

    We then have a DataAccess.cs class in our main project that creates the instance of the data layer:

    enter image description here

    Then we call it by using linq statements in the main project:

    enter image description here

  2. Bernd
    Bernd avatar
    91 posts
    Member since:
    Feb 2013

    Posted 24 Jan 2017 Link to this post

    Import your rlinq into the devart Entity Developer and export/save it as whatever you like.
Back to Top