// Note : snippet is name your table
// select records in your table
var snippets = (from snippet in context.Snippets
              select snippet).ToList();

// join records by "\r\n"
var joinSnippets = string.Join("\r\n", snippets.Select(x => x.Body).ToArray());

// get total lines
var count = joinSnippets.Split('\n').Length;