title: Database already exist. Choose a Different Name using CreateDatabase()
body: <p>I got an issue and learned something at the same time....</p>
  
  <p>I created a DBML from an existing server database.</p>
  
  <p>From the DBML I wanted to create local database (an .mdf file).  I created the database <code>using DataContext.CreateDatabase("C:\xxxx.mdf")</code> .   </p>
  
  <p>Then I decided to delete it (MANUALLY, which is a bad thing evidentally) because when I try to recreate the database with the same name (eventhough the files are deleted), I get the error  <strong>Database already exist. Choose a Different Name using CreateDatabase()</strong></p>
  
  <p>I tried looking through the registry, no luck... I tried searching the whole hard drive for the file.. no luck.</p>
  
  <p>After googling, I found that you delete a database that was created with <code>CreateDatabase()</code> with <code>DeleteDatabase()</code>.... Then you can recreate the database again.</p>
  
  <p>Well problem is, now I still can't recreate the old database because the system thinks the name already exists.  </p>
  
  <p>Is there a way to get rid of the reminents of the old databse file the "does not exist"</p>