Referencing PetaPoco from App_Code class (Umbraco 7)

Question

Trying to create a web service to use Petapoco, I have created the following in a cs file in App_code

using System;
using Umbraco.Core;
using Umbraco.Core.Persistence;

namespace utData{

    public class MyDB{
        public string demo(){
             var dataContext = new PetaPoco.Database("umbracoDbDSN");
            return "demo - OK";
        }
    }
}

However, using this from a web service call results in

 CS0246: The type or namespace name 'PetaPoco' could not be found (are you missing a using directive or an assembly reference?)
 var dataContext = new PetaPoco.Database("umbracoDbDSN");

Any way to fix this?

Try to place your cs file outside of the `App_Code` folder. Rebuild and see if that works — Mivaweb, May 30 '16 at 11:22

Jannik Anker · Answer 1 · 2016-06-01T07:41:07.687

Umbraco wraps its use of PetaPoco, so if you want "clean" and separate use of PetaPoco, you will need to reference it in your project or in your case (when not compiling) place PetaPoco DLL(s?) in the bin folder.

Or you could google PetaPoco Umbraco and see how PetaPoco is used in Umbraco context. According to http://www.wiliam.com.au/wiliam-blog/using-petapoco-with-umbraco-is-pretty-sweet it goes something like this (for your example):

var db = applicationContext.DatabaseContext.Database;
// or ApplicationContext.Current.DatabaseContext.Database

if (!db.TableExist("blahblah"))
{
    db.CreateTable(false);
}

Referencing PetaPoco from App_Code class (Umbraco 7)

1 Answers1