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


  • Robin 37 posts 109 karma points
    May 04, 2013 @ 15:11
    Robin
    0

    Recommanded API to connect to database???

    Hello

    I am creating .NET user controls and need a database connection. Till now I used the .NET way of connection to a database (example: 

    Sql(Ce)Connection myConn = new Sql(Ce)Connection(umbraco.BusinessLogic.Application.SqlHelper.ConnectionString);

    )

    If someone uses a different database then my user control is useless. I almost can't believe there is no api who checks on wich type of database Umbraco is installed and we can use that to open/close the connection (How are packages developped who uses a database?) but I can't find.

    Which is the correct way to connect to the database and automatically use the database where Umbraco is installed on?

    Copy Link
  • Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib
    May 06, 2013 @ 10:39
    Dave Woestenborghs
    0

    You can use the SQL helper that comes with Umbraco.

    I think it's located in the namespace umbraco.DataLayer

    Copy Link
  • David Brendel 792 posts 2970 karma points MVP 3x c-trib
    May 06, 2013 @ 11:43
    David Brendel
    0

    If you're using Umbraco 6 than you can also use PetaPoco to connect to the database.

    It's very usefull if you want to get pocos from you're database query.

    Copy Link
  • Robin 37 posts 109 karma points
    May 08, 2013 @ 09:29
    Robin
    0

    Thanks a lot for the replies! I'll give it a try next week, unfortunately I'm not able to do it this week anymore

    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