PGroonga.EntityFrameworkCore
3.1.0
Extensión de Pgroonga para npgsql.entityframeworkcore.postgresql (PostgreSQL / NPGSQL Entity Framework Core Provider). Habilita la capacidad de hacer una búsqueda de texto completo, especialmente chino, japonés, etc., con EntityFramework Core, PostgreSQL y Groonga.


EF.Functions.Pgroonga* Solo funciona con Npgsql.EntityFrameworkCore.PostgreSQL > = 2.2.6 y> = 3.0.1 debido 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 obtener más información, consulte PGroongaLinqExtensions y PGroongaDbFunctionsExtensions .
LIKELIKE ILIKEILIKE &@ Fósforo &@~ Consulta &@* SimilarSearch &` ScriptQuery &@| Matar &@~| Consulta &^ PrefixSearch &^~ PrefixrkSearch &^| Prefixsearchin &^~| Prefixrksearchin &~ 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_truncateLa licencia del MIT
Más información ver licencia