PGroonga.EntityFrameworkCore
3.1.0
Extensão pgroonga para npgsql.entityframeworkcore.postgresql (provedor principal do PostgreSQL / NPGSQL Entity Framework). Ele permite a capacidade de fazer pesquisa completa de texto, especialmente chinesa, japonesa e assim por diante, com o EntityFramework Core, PostgreSQL e Groonga.


EF.Functions.Pgroonga* funciona apenas com Npgsql.EntityFrameworkCore.PostgreSQL > = 2.2.6 e> = 3.0.1 devido a aspnet/entityframeworkcore#13454.
public class ApplicationDbContext : DbContext
{
// ...
protected override void OnModelCreating ( ModelBuilder modelBuilder )
{
base . OnModelCreating ( modelBuilder ) ;
// ...
modelBuilder . Entity < Post > ( )
. HasIndex ( g => g . Content )
. HasMethod ( "pgroonga" )
. HasOperators ( "pgroonga_varchar_full_text_search_ops_v2" ) ;
}
}
public class Startup
{
// ...
public void ConfigureServices ( IServiceCollection services )
{
services . AddDbContextPool < ApplicationDbContext > ( options =>
options . UseNpgsql ( Configuration . GetConnectionString ( "DefaultConnection" ) ,
builder => builder . UsePGroonga ( ) ) ) ;
// ...
}
}
var posts = await _dbContext . Posts . Where ( g => g . Content . SimilarSearch ( q ) )
. OrderByDescending ( g => EF . Functions . PgroongaScore ( ) )
. ToArrayAsync ( ) ; Para obter mais informações, consulte PGroongaLinqExtensions e PGroongaDbFunctionsExtensions .
LIKELIKE ILIKEILIKE &@ Corresponder &@~ Query &@* Similarsearch &` ScriptQuery &@| Matchin &@~| Queryin &^ PrefixSearch &^~ Prefixrksarch &^| Prefixsearchin &^~| Prefixrksarchin &~ RegexpMatch pgroonga_commandpgroonga_command_escape_valuepgroonga_escapepgroonga_flushpgroonga_highlight_htmlpgroonga_is_writablepgroonga_match_positions_bytepgroonga_match_positions_characterpgroonga_normalizepgroonga_query_escapepgroonga_query_expandpgroonga_query_extract_keywordspgroonga_set_writablepgroonga_scorepgroonga_snippet_htmlpgroonga_table_namepgroonga_wal_applypgroonga_wal_truncateA licença do MIT
Mais informações veja a licença