Edit Question - KnowledgeHub

Title Body

I am using the Entity framework for the first time, and would like to know if I am using in the best practice. I have created a separate class in my business logic which will handle the entity context. the problem I have, is in all the videos I have seen they usually wrap the context in a using statement to make sure its closed, but obviously I can't do this in my business logic as the context will be closed before I can actually use it? So is this ok what I'm doing? A couple of examples: public IEnumerable<Article> GetLatestArticles(bool Authorised) { var ctx = new ArticleNetEntities(); return ctx.Articles.Where(x => x.IsApproved == Authorised).OrderBy(x => x.ArticleDate); } public IEnumerable<Article> GetArticlesByMember(int MemberId, bool Authorised) { var ctx = new ArticleNetEntities(); return ctx.Articles.Where(x => x.MemberID == MemberId && x.IsApproved == Authorised).OrderBy(x => x.ArticleDate); } I just want to make sure I'm not building something that's going to die when a lot of people use it?

Tags (comma-separated) Cancel