Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • BaconBeastNz 40 posts 60 karma points
    Mar 16, 2011 @ 07:24
    BaconBeastNz
    0

    Is it possible to access the Umbraco DataContext (I.E SQL connection) ?

    Hi there

    I am doing some LINQ2SQL, as I have a pretty unique DB schema I'd like to stay out of the Umbraco system (I.E using Nodes & properties to store this particular data)
    I'm trying to link my C# classes to the DB tables using E.G

    "Table<Customer> Customers = db.GetTable<Customer>();"

    but I first need to setup a DataContext db = new DataContext();

    As I'm already connected to the DB with Umbraco, is it possible to grab that DataContext instead of creating a new one?

    Thanks any help appreciated! :)

    Copy Link
  • Harald Ulriksen 207 posts 249 karma points
    Mar 16, 2011 @ 09:21
    Harald Ulriksen
    0

    Hi,

    umbraco use old style queries and execute*.

    You can access sql helpers in umbraco.BusinessLogic.Application.SqlHelper located in buisnesslogic.dll, the rest of the data things are in umbraco.datalayer.dll

    Hope this helps,
    H.

    As note I used Simple.Data, https://github.com/markrendle/Simple.Data, for the last project. Simple.data works great with umbraco 4.6 and sql compact 4. I had a very simple schema for my non-umbraco data, not sure how suitable this will be for more advanced schemas.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft