A verbatim string literal consists of an @ character followed by a double-quote character, zero or more characters, and a closing double-quote character.... A verbatim string literal may span multiple lines.
var qry = @"SELECT NewsArticle.NewsId, NewsArticle.NewsDate, NewsArticle.NewsTitle,
NewsArticle.NewsText NewsArticle.NewsPictureUrl, NewsArticle.Newslink NewsArticle.IsVisible,
UserProfile.Membername, UserProfile.Firstname UserProfile.Lastname, NewsCategory.CategoryName
FROM NewsArticle
INNER JOIN UserProfile ON UserProfile.UserId = Newsarticle.UserId
INNER JOIN Newscategory ON Newscategory.CategoryId = Newsarticle.CategoryId
WHERE Newsarticle.Isvisible = 1
ORDER BY Newsarticle.Newsdate DESC";
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Please Help with Sql INNER JOIN
Jan 07, 2012 07:12 AM|LINK
For readability, you are much better off using the verbatim string literal:
var qry = @"SELECT NewsArticle.NewsId, NewsArticle.NewsDate, NewsArticle.NewsTitle, NewsArticle.NewsText NewsArticle.NewsPictureUrl, NewsArticle.Newslink NewsArticle.IsVisible, UserProfile.Membername, UserProfile.Firstname UserProfile.Lastname, NewsCategory.CategoryName FROM NewsArticle INNER JOIN UserProfile ON UserProfile.UserId = Newsarticle.UserId INNER JOIN Newscategory ON Newscategory.CategoryId = Newsarticle.CategoryId WHERE Newsarticle.Isvisible = 1 ORDER BY Newsarticle.Newsdate DESC";Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter