“Cannot drop database because it is currently in use”. How to fix?

by

The problem is that your application probably still holds some connection to the database (or another application holds connection as well). Database cannot be deleted where there is any other opened connection. The first problem can be probably solved by turning connection pooling off (add Pooling=false to your connection string) or clear the pool before you delete the database (by calling SqlConnection.ClearAllPools()).

Both problems can be solved by forcing database to delete but for that you need custom database initializer where you switch the database to single user mode and after that delete it. Here is some example how to achieve that.

More Related Contents:

  1. ADO.Net EF – how to define foreign key relation in model first approach?
  2. Best way to test a MS Access application?
  3. What’s the best strategy for unit-testing database-driven applications?
  4. What is database pooling?
  5. There is already an object named in the database
  6. How to unit test an object with database queries
  7. How to perform compound queries with logical OR in Cloud Firestore?
  8. MSSQL Error ‘The underlying provider failed on Open’
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. Surrogate vs. natural/business keys [closed]
  11. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  12. Do you use source control for your database items? [closed]
  13. database vs. flat files
  14. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  15. Can we update primary key values of a table?
  16. How do I output the results of a HiveQL query to CSV?
  17. Import SQL dump into PostgreSQL database
  18. Can I do transactions and locks in CouchDB?
  19. Elasticsearch query to return all records
  20. How are people unit testing with Entity Framework 6, should you bother?
  21. How to login and authenticate to Postgresql after a fresh install?
  22. How to update not every fields of an object using Entity Framework and EntityState.Modified
  23. What are the differences between B trees and B+ trees?
  24. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  25. What is the default Precision and Scale for a Number in Oracle?
  26. What is caching?
  27. How do I unit test jdbc code in java? [closed]
  28. How to use String property as primary key in Entity Framework
  29. Oracle: How do I convert hex to decimal in Oracle SQL?
  30. Model First with DbContext, Fails to initialize new DataBase

Leave a Comment