Super simple example of using Database inside Umbraco V8

DatabaseExample.cs

using Umbraco.Core.Scoping;

namespace My.Website
    public class DatabaseExample
    {
        private IScopeProvider _scopeProvider;

        public DatabaseExample(IScopeProvider scopeProvider)
        {
            _scopeProvider = scopeProvider;
        }

        public void DoSomething()
        {
            using (var scope = _scopeProvider.CreateScope())
            {
                // Scope.Database has what you need/want
                scope.Database.Fetch<MyType>("Select * From MyTable");

                // You must always complete a scope
                scope.Complete();
            }
        }
    }
}