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

SRT THE REAL HERO

Lets Start with something quite interesting. So I am selecting SRT ( As an Indian too much dedicated towards cricket). For me cricket means Sachin . When ever Sachin is in crease i never looks the score. Like to see Sachin plays at least 35 to 40 overs. Usually by that time he will reach his century. My passion is to study the statistics of Sachin. You know Sachin looks almost 72 games to hit his first century. After 17 years now ( more than 350 matches he played after) he had 46 ODI century, what an amazing batsman. Till 1992 -1993 if you looks his ODI average its in late twenties. But now its after that 350 matches now more than 45 . I know one thing Sachin will play till his wish. I like to see him score more than 100 odi century( Sachin personally enjoys this). Its not a barrier , but a guy got that much passion towards game can achieve it. I always ideals Sachin. While i am working and have difficult situations, I always think how Sachin played 137 against Australia ( dessert ...
2 comments
Read more

CV Preparation

An old saying, - First Impression is the best impression. When we are applying for the jobs, chances of getting interview depend mainly on CV . Each location has its own CV format. While applying for an UK based job you need to sent a standard UK  format CV (optional cases some organisations do not accepts CV ).  1 Header with Name, phone number and email address (avoid address) 2 Career Conspectus – Describe about your experience, what technology you familiar with, what domain you got experience etc 3. Technical Skills – Mention all the technical skills on this section (In good format, if necessary use tables) 4. Certifications - Mention about the Certifications passed. 5. Employment Chronicle- Mention about the professional experience (Most recent first).Include Project name/Client name  , a brief summary  of project, your responsibility (Means role in the project), and the environment(Which  technologies used) which the projects works 6....
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...
Post a Comment
Read more