C# breaking up long lines of code

[Newbie19]

I've searched a few websites and none of them meantion how to break up really long lines of code like a sql query.

The sql statement looks like this (I've broked it down so it can fit in the post):
String sSQL = "SELECT dbo.Issues.CreatedDate as Created, dbo.Issues.ModifiedDate as Modified, dbo.Issues.Field1 AS Repro, dbo.Issues.Field3 AS Notes dbo.Issues.Field2 as Priority, dbo.Issues.Field11 AS Build, dbo.Issues.Field12 as Description, dbo.Issues.Field25 AS VersionIn, dbo.Issues.Field26 As VersionFixed dbo.Issues.ID,dbo.Types.Name AS Type, dbo.Issues.Synopsis dbo.States.Name AS State, dbo.States.ID AS StatesID, dbo.Users.Name AS [User], dbo.Projects.Name AS Projects FROM dbo.Issues INNER JOIN dbo.Projects ON dbo.Issues.ProjectID = dbo.Projects.ID INNER JOIN dbo.States ON dbo.Issues.StateID = dbo.States.ID INNER JOIN dbo.Types ON dbo.Issues.TypeID = dbo.Types.ID INNER JOIN dbo.Users ON dbo.Issues.AssignedUserID = dbo.Users.ID WHERE ( dbo.Projects.ID = 66)";

I'm not sure if this post should be here, but I figured it is worth a shot. Thanks for any advice.
Newbie19

[weaknessforcats]

You shouold be able to:

String sSQL = "SELECT dbo.Issues.CreatedDate as Created,"
                     + " dbo.Issues.ModifiedDate as Modified,"
                     + " dbo.Issues.Field1 AS Repro,"
                     + " dbo.Issues.Field3 AS Notes dbo.Issues.Field2 as Priority,"
                     +etc....
 

[Newbie19]

You shouold be able to:

String sSQL = "SELECT dbo.Issues.CreatedDate as Created,"
                     + " dbo.Issues.ModifiedDate as Modified,"
                     + " dbo.Issues.Field1 AS Repro,"
                     + " dbo.Issues.Field3 AS Notes dbo.Issues.Field2 as Priority,"
                     +etc....
 

Thank you very much, C# is more like Java then I realized.

Thanks again,

Newbie19

[Plater]

Thank you very much, C# is more like Java then I realized.

Thanks again,

Newbie19

You can also do:

String sSQL = "";
sSQL += "SELECT dbo.Issues.CreatedDate as Created,";
sSQL += " dbo.Issues.ModifiedDate as Modified,"
sSQL += " dbo.Issues.Field1 AS Repro,"
sSQL += " dbo.Issues.Field3 AS Notes dbo.Issues.Field2 as Priority,"
//sSQL += etc....
 

(There is a "cost" with this as it re-creates the string everytime.)

[camel]

If you are going to need a lot of concatenations best option is likely the System.Text.StringBuilder which overcomes the performance issues of +=