public void TsHeadline() { using (var context = new BloggingContext(ConnectionString)) { context.Database.Log = Console.Out.WriteLine; var blog1 = new Blog { Name = "cooky cookie piano pianos" }; context.Blogs.Add(blog1); var blog2 = new Blog { Name = "blue crab denominates elephant" }; context.Blogs.Add(blog2); context.SaveChanges(); var headlines = context .Blogs .Select( x => NpgsqlTextFunctions.TsHeadline( x.Name, NpgsqlTextFunctions.ToTsQuery("cookie"), "StartSel=<i> StopSel=</i>")) .ToList(); Assert.That(headlines.Count, Is.EqualTo(2)); Assert.That(headlines[0], Is.EqualTo("<i>cooky</i> <i>cookie</i> piano pianos")); Assert.That(headlines[1], Is.EqualTo(blog2.Name)); headlines = context .Blogs .Select( x => NpgsqlTextFunctions.TsHeadline( "english", x.Name, NpgsqlTextFunctions.ToTsQuery("piano"), "StartSel=<i> StopSel=</i>")) .ToList(); Assert.That(headlines.Count, Is.EqualTo(2)); Assert.That(headlines[0], Is.EqualTo("cooky cookie <i>piano</i> <i>pianos</i>")); Assert.That(headlines[1], Is.EqualTo(blog2.Name)); } }