Skip to main content

Entity framework practices

People who are using entity framework for Dal single dbcontext is going to be a problem in BLL. I use the following structure

 

I used to get the single dbContext by:- Each single repo class should inherit from base repo class and in base repo class should initialise the dbcontext.

 

The BaseRepository

 

  public class BaseRepo

    {

       private readonly bool isNewInstance;

       protected OnlineProductLinkEntitiesdbContext;

 

 

       protected BaseRepository()

       {

           dbContext = newOnlineProductLinkEntities();

           isNewInstance = true;

       }

 

       protectedBaseRepository(OnlineProductLinkEntitiesdbContext)

       {

           isNewInstance = dbContext == null;

 

           if (isNewInstance)

               dbContext = newOnlineProductLinkEntities();

 

           this.dbContext = dbContext;

       }

 

       protected voidCheckAndTryToOpenConnection()

       {

           if (dbContext == null)

               dbContext = newOnlineProductLinkEntities();

           if (dbContext.Connection.State !=ConnectionState.Open)

               dbContext.Connection.Open();

       }

 

       public void Dispose()

       {

           if ((!isNewInstance) || (dbContext ==null))

               return;

 

           OnlineProductLinkEntities context = (OnlineProductLinkEntities)dbContext;

 

           if (context.Connection.State ==ConnectionState.Open)

           {

               context.Connection.Close();

           }

 

           context.Dispose();

           dbContext=null; 

       }

}

 

The single repo class constructor looks like

 

    public Cmo_SiteRepository(){}  

 

    public singleRepo (OnlineProductLinkEntitiesdbContext):base(dbContext), Irepository<model, entity>

       { }

 

 

A method inside the single repo class will look like this

 

    public int Create(SiteModel model)

       {

           try

           {

               CheckAndTryToOpenConnection();

               objectTable siteEntity = newobjectTable ();

           }

           catch (Exception ex)

           {

               throw new Exception("Exception", ex);

           }

       }

 

 

Comments

Post a Comment

Popular posts from this blog

Bootstrap Server Side Sorting Cont....

On my previous post   I had already mentioned about how to apply the sort to Bootstrap paginated tables. By making the following changes server side sorting can be achieved along with pagination. On Filter Model self.sortBy = ko.observable( 'Id' );//Default sort Column self.sortAscending = ko.observable( false ); self.iconType = ko.observable( 'glyphicon glyphicon-chevron-down' ); // Icon to appear near Column No Changes to Adarsh Log Model or Adarsh Log list Model Knockout.js View Model for Adarsh Log Changes Add the sortTable  method to it self.sortTable = function (viewModel, e) {             var columClicked = $(e.target).attr( "data-column" )             var sortAscending = (self.filter().sortAscending() === true ) ? false : true ;             self.filter().sortAscendi...
Post a Comment
Read more

#saynotointerview for recruitment process

I recently went for a training that consists of employees from multinational corporations. During the brainstorming sessions, one fellow gentleman started speaking about firing his colleague. This guy is actually a senior manager and he interviewed the departed. He was blaming the unfortunate guy told he knows all the job description and he was smart during the interview. So they selected him for the job. But in the job, he never raised to his potential and they sacked him. The senior manager was claiming in the brainstorming session the decision was correct. But lots of people in training disagreed with that. Majority people told the recruitment or interview process in the company flawed to test that lad's knowledge. I strongly believe this might not be a one of the situation in recruitment? How many of you came across similar experience in your professional career? Do you believe the things we put in the job description are the exact things the potential employees will be do...
2 comments
Read more

Emergence and Creative Confidence

I started my career on 1st of September 2008 as a software developer at Manchester. Some people in my personal life might know about it. I like to say, that day as the day I found an aura in my life, transformation from the worst possible situation into a new beginning in a matter of 1 hour. The week before, I got an interview confirmation from that company and I was not at all excited about it because I know it is going to be the final interview in UK if I am unsuccessful. I was in that mental state because I was not successful for past 12 such occurrences and not expecting anything different. This shows I was not a brilliant person but had a strong passion and hardworking nature to achieve success. I passed my masters on Sep 2007 and after that, I decided to work only in software development, and lots of people including my parents told this as a worst possible decision. To be precise, they have no issues in choosing software development, but on my adamant decision only software de...
1 comment
Read more