Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Alex 79 posts 416 karma points
    Jan 28, 2016 @ 11:35
    Alex
    0

    DataBase Connection

    Hi

    I have trying to simple display data from the Umbraco database, using only Razor But It gives error?

    @inherits Umbraco.Web.Mvc.UmbracoTemplatePage

@{ 
    var DB = Database.Open("umbracoDbDSN"); 
    var DataTypes = DB.Query("SELECT * FROM cmsDataType");
}

@{
    foreach (var item in DataTypes)
    {  
        @item
    }
}

    Using this code

    Copy Link
  • Alex 79 posts 416 karma points
    Jan 28, 2016 @ 11:36
    Alex
    0

    Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

    Copy Link
  • Samira 113 posts 452 karma points
    Jan 28, 2016 @ 11:40
    Samira
    100

    Hi

    Try this

    var db = Umbraco.Core.ApplicationContext.Current.DatabaseContext.Database;

    hope this help

    Copy Link
  • Alex 79 posts 416 karma points
    Jan 28, 2016 @ 11:43
    Alex
    0

    It now complains about the Open statement and did not work

    Copy Link
  • Nik 1625 posts 7295 karma points MVP 7x c-trib
    Jan 28, 2016 @ 13:00
    Nik
    0

    And what happens when you take the Open line out of your code?

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies