getting the database in v8

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Søren Kottal 712 posts 4570 karma points MVP 6x c-trib

Dec 28, 2018 @ 10:40

0

Getting the Database in v8

How can I get the database in v8?

In v7 I can find it in ApplicationContext.Current.DatabaseContext.Database

Copy Link
Marc Goodson 2155 posts 14408 karma points MVP 9x c-trib

Dec 29, 2018 @ 19:16
103
Hi Soren

From a conversation here: https://github.com/umbraco/UmbracoDocs/issues/745

I'm deducing the Database is now available via a scope object?

eg
```
using (var scope = ApplicationContext.Current.ScopeProvider.CreateScope())
{
  var database = scope.Database;  
  // use database  
  scope.Complete();
}
```
??

but is a bit of a guess.

regards

marc
Copy Link
Søren Kottal 712 posts 4570 karma points MVP 6x c-trib

Dec 31, 2018 @ 09:27

0

Thanks Marc, that seems to work :)

Also used this var db = new Database("umbracoDbDsn"); but I guess a magic string is bad practice, and maybe also storing the database in a variable?

It just feels cumbersome to do all that using and Complete() stuff whenever I need something from the database.

Copy Link
Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq

Feb 28, 2019 @ 11:03

1

Do read this comment from Stephane,

https://github.com/umbraco/Umbraco-CMS/issues/3866#issuecomment-466907932

The "cumbersome" using and Complete() stuff is there for safety, mostly for when database updates fail and need to be rolled back.

For querying, use IUmbracoDatabaseFactory and make sure to dispose after usage so you don't keep connections to the db open. I don't know if NPoco's Database class doesn't dispose either, so you will in all cases need that using stuff. :)

Copy Link
Marcio Goularte 388 posts 1360 karma points

Feb 28, 2019 @ 01:37

0

Kevin jump answered this to me in this post

https://our.umbraco.com/forum/umbraco-8/95939-create-custom-tables-migration-umbracodatabase-npoco#comment-303475

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?