c# code cleanup to break statement in multiple line

Question

I have this c# code to make a database. It is working code. But it ugly because of a single line. I want to break it into multiple lines. If I just put line break by the enter key, it gives syntax error. How to beak it a cleaner way:-

 string createDataBase = $"CREATE DATABASE {dataBaseName} ON PRIMARY (NAME = {dataBaseName}_Primary, FILENAME = '{primaryPath}'), FILEGROUP {dataBaseName}_FileStreamGroup CONTAINS FILESTREAM(NAME = {dataBaseName}_Filestream, FILENAME = '{filePath}')";

Please let me know how to break it?

add `@` sign after `$` to mark it as a verbatim string – hcerim Jan 06 '18 at 10:18 — hcerim, Jan 06 '18 at 10:18

score 0 · Answer 1 · answered Jan 06 '18 at 10:13

You are using an interpolated string. I believe you can do this:

string createDataBase = $@"CREATE DATABASE {dataBaseName} ON PRIMARY (NAME = {dataBaseName}_Primary, FILENAME = '{primaryPath}'), 
FILEGROUP {dataBaseName}_FileStreamGroup CONTAINS FILESTREAM(NAME = 
{dataBaseName}_Filestream, FILENAME = '{filePath}')";

As described more here: Long string interpolation lines in C#6

aleha_84 · Accepted Answer · 2018-01-06T10:22:55.953

0

Just use $@ combination

string createDataBase = 
$@"CREATE DATABASE {dataBaseName} 
    ON PRIMARY (NAME = {dataBaseName}_Primary, FILENAME = '{primaryPath}'), 
    FILEGROUP {dataBaseName}_FileStreamGroup 
    CONTAINS FILESTREAM(NAME = {dataBaseName}_Filestream, FILENAME = '{filePath}')
";

edited Jan 06 '18 at 10:22

answered Jan 06 '18 at 10:16

aleha_84

8,309
2
38
46

1

You can move `$@"` on same line with `CREATE ..` - will save one redundant line break – Fabio Jan 06 '18 at 10:19
Thanks! it is fine. – masiboo Jan 06 '18 at 10:24

c# code cleanup to break statement in multiple line

2 Answers2