I'm sure there's probably something dumb that I,ve done or overlooked but following Chapter 6 Try it Out example, when run the application I keep getting the following message

Enter table to count records for:
Character
An attempt to attach an auto-named database for file C:\Visual C# 2005 Databases
\Chapter06 Ex0601 - Executing Comm
ands\FolktaleDB.mdf failed. A database with the same name exists, or specified f
ile cannot be opened, or it is located on UNC share.
There are -1 rows in the table [Character].
Press ENTER to close.

has anyone got any ideas ? as this is very frustrating

The trick here is to know that there are two ways to deal with database connections. The first is to attach the database at the time of connection which is useful if you want to work with multiple versions. The second is to attach a single database permanently and refer to it by name in the connection. However, these techniques are not compatible. What the connection is complaining about when it says 'A database with the same name exists' is that the database named FolktaleDB.mdf is already attached to the server. So you need to use Management Studio to detach this database so you can attach it at connection time. I prefer to use a single database permanently attached to the server which requires a different connection string.
This connection works for me:
<connectionStrings>
    <add name="FolktaleDBConnectionString"
      connectionString="Data Source=.\SQLEXPRESS;
      Database=FolktaleDB;
      Integrated Security=True"/>
  </connectionStrings>

Thanks for that....kinda got confused over this issue,learning from ASP.NET I found that I like to place the DB in the application directory and use a standard format connection string :-
<add name="MyConnectionString"
             connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Test.mdf;Integrated Security=True;User Instance=True"/>
as apposed to path directory names of C:/dir/dir or issues when connecting to db's on the server, this works fine for me and ensures that I don't get tripped up again.