How using DataContext from singleton in repository?

Question

Ef generate MyDataModel.edmx with class MyDataEntities for my database MyData. I create a singleton class SingletonMyDataContext

public sealed class SingletonMyDataContext
    {
        private static readonly MyDataEntities_instance = new MyDataEntities();
        private SingletonMyDataContext() { }
        static SingletonMyDataContext() { }

        public static MyDataEntitiesInstance { get; private set; }
    }

I want to create a Repository class for work with data in DB, but i don't now, how to use in repository context(MyDataEntities _instance), because after using need call dispose(). How using DataContext from singleton in repository?

public class Repository
{
private DbContext _context = SingletonMyDataContext.Instance;

//logic for work with data
}

Dennis · Accepted Answer · 2013-10-01 12:36:24Z

1

How using DataContext from singleton in repository

Obviously, you should not make your data context as a singleton. Moreover, in most cases it's a bad practice. EF data context caches metadata itself, after first creation of context instance. Don't try to do it twice.

answered Oct 1, 2013 at 12:36

Dennis

37.9k11 gold badges87 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

isxaker Over a year ago

Thats mean, don't create a singleton, simple use repisotory?

Dennis Over a year ago

Yes, this is exactly what I mean.

Collectives™ on Stack Overflow

How using DataContext from singleton in repository?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related