How to achieve multi-line strings in C#; an alternative to VB's XML Literals?

Question

I had a project in vb.net that used XML Literals to process large blocks of SQL like so:

Dim SQL As String = <a> Use test

alter table BarFoo alter column CouponName nvarchar(328)
alter table Foo alter column IngredientName nvarchar(328)
alter table Bar alter column IngredientShortDescription nvarchar(328)
alter table FooBar alter column ItemName nvarchar(328) </a>.Value

But cant seem to find its equivalent for C# Any suggestions?

Answer 1

You can prefix a string constant with @ to span multiple lines. The only thing that would need to be escaped is quotes (using the double quote).

string SQL = @"Use test
  alter table BarFoo alter column CouponName nvarchar(328)
  alter table Foo alter column IngredientName nvarchar(328)
  alter table Bar alter column IngredientShortDescription nvarchar(328)
  alter table FooBar alter column ItemName nvarchar(328)";