Advertisement
dimitrova_elka

Advanced Querying Task 8. Book Search

Nov 22nd, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.68 KB | None | 0 0
  1. static void Main()
  2.         {
  3.             var input = Console.ReadLine();
  4.             using (var db = new BookShopContext())
  5.             {
  6.                 string result = GetBookTitlesContaining(db, input);
  7.                 Console.WriteLine(result);
  8.             }
  9.         }
  10.  
  11.  
  12. public static string GetBookTitlesContaining(BookShopContext context, string input)
  13.         {
  14.             var titles = context.Books
  15.                 .Where(b => b.Title.Contains(input.ToLower()))
  16.                 .Select(b => b.Title)
  17.                 .OrderBy(t => t)
  18.                 .ToArray();
  19.             var result = String.Join(Environment.NewLine, titles);
  20.             return result;
  21.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement