How to continue a long query on a new line in c#.net
Posted on 2008-10-17
I have a long query like this:
"select requests.id,requests.disposition,requests.staff_ID,(contacts.First_Name+' ' +contacts.Last_Name) as Contact,contacts.Office_telephone,requests.project_title,requests.create_date,text_file.text_field from requests,contacts,text_file where requests.create_date >= (SELECT CAST(CONVERT(CHAR(11),GETDATE(),113) AS datetime)) and requests.Primary_contact_ID = Contacts.ID and requests.Project_Description_Id = text_file.id order by requests.id desc";
How do i write this query onmultiple lines in C#.net?
Is there some special character that you can put after the end of each line so that its recognized as a continuation of the query on the previous line?
Currently I have this query on one long line and I have to scroll all the way across to edit something at the end of the line