Fix Issue : Microsoft.Practices.EnterpriseLibrary.Data.Database, is an abstract class and cannot be constructed.

Server Error in '/' Application.

---

The current type, Microsoft.Practices.EnterpriseLibrary.Data.Database, is an abstract class and cannot be constructed. Are you missing a type mapping?

While deploying a web application which use Microsoft enterprise library for data access. If you get the above error. 

Please make sure all the dll is in bin folder and make sure to add the following section in web.config file 

   

       

       

     

 

   

     

     

   

 

SQL_NO_CACHE MySQl no cache

The mysql workbench return the cached value of data.

To get the latest data from db use the keyword SQL_NO_CACHE
 Select SQL_NO_CACHE * from UserDetail