public void TsRankCd() { 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); context.SaveChanges(); var rank = context .Blogs .Select( x => NpgsqlTextFunctions.TsRankCd( NpgsqlTextFunctions.ToTsVector(x.Name), NpgsqlTextFunctions.PlainToTsQuery("cookie"))) .FirstOrDefault(); Assert.That(rank, Is.GreaterThan(0)); rank = context .Blogs .Select( x => NpgsqlTextFunctions.TsRankCd( NpgsqlTextFunctions.ToTsVector(x.Name), NpgsqlTextFunctions.PlainToTsQuery("cookie"), NpgsqlRankingNormalization.DivideByLength | NpgsqlRankingNormalization.DivideByUniqueWordCount)) .FirstOrDefault(); Assert.That(rank, Is.GreaterThan(0)); rank = context .Blogs .Select( x => NpgsqlTextFunctions.TsRankCd( 0.1f, 0.2f, 0.4f, 1.0f, NpgsqlTextFunctions.ToTsVector(x.Name), NpgsqlTextFunctions.PlainToTsQuery("cookie"))) .FirstOrDefault(); Assert.That(rank, Is.GreaterThan(0)); rank = context .Blogs .Select( x => NpgsqlTextFunctions.TsRankCd( 0.1f, 0.2f, 0.4f, 1.0f, NpgsqlTextFunctions.ToTsVector(x.Name), NpgsqlTextFunctions.PlainToTsQuery("cookie"), NpgsqlRankingNormalization.DivideByLength | NpgsqlRankingNormalization.DivideByUniqueWordCount)) .FirstOrDefault(); Assert.That(rank, Is.GreaterThan(0)); } }