set sql database name with an alphanumeric phrase - C#

Question

I'm trying to make a simple thing but it has become difficult as I do not understand why I proves a mistake like that, I'll explain , I would like to set the database name as well : "FD65F10A-0F6F-487C-A5E4-18A783DC18AE" (PID variable)

But if I leave this , I get this error :

the problem seems to be the hyphen , because if I remove it and septum so : FD65F10A0F6F487CA5E418A783DC18AE everything works , saves me the db and I can go way on the debug..Come I can use the hyphen ? you need to use it , I have to find a solution . Thank you

I have to set the name of a database dynamically created with the "-" character , for example: this-is- my-name-of-db.mdf . The problem is that I do not accept the "- " . I found nothing in the literature to say that the " - " is forbidden in the naming to db . — Mr. Developer, Mar 10 '16 at 15:55
@believeme In fact, I gave you reason , maybe my bad English I explained badly — Mr. Developer, Mar 10 '16 at 15:57
Side note - you should just do `throw;` instead of `throw ex;` - otherwise you may lose some of the exception information. — Joe Enos, Mar 10 '16 at 16:16

score 0 · Answer 1 · answered Mar 10 '16 at 16:09

0

You can use delimited characters for naming.

String str = "CREATE DATABASE '" + PID + "' ON PRIMARY "........

Noting the single quotes in the string on either side of the PID variable.

answered Mar 10 '16 at 16:09

Kramb

1,082
10
18

Does not work I had already tried before to the question , I think , at this time, the use of " - " is not allowed in the file name. – Mr. Developer Mar 10 '16 at 16:11
@Mr.Developer Could you use an underscore instead maybe? – Kramb Mar 10 '16 at 16:11
underscore works, but would hyphenated the name of the file ... so I guess the last resort is to do the replace . – Mr. Developer Mar 10 '16 at 16:13
Yea just change the string variable with PID = PID.Replace("-", "_") and that will allow it. – Kramb Mar 10 '16 at 16:14
it is clear know how you program , are only new sql server, sql lite you can name as you like, for what I opened the question . Thanks anyway – Mr. Developer Mar 10 '16 at 16:15

score 0 · Accepted Answer · answered Mar 10 '16 at 16:27

0

Not only is the database name failing, but also your LOG ON line.

Put square brackets around the database name and around the log name:

"CREATE DATABASE [" + PID + "] ..."
...
"LOG ON (NAME = [" + PID + "Log_Log] ..."

answered Mar 10 '16 at 16:27

Joe Enos

39,478
11
80
136

how could I not have thought of that before ? ! through works – Mr. Developer Mar 10 '16 at 16:31

set sql database name with an alphanumeric phrase - C#

2 Answers2