PGroonga.EntityFrameworkCore
3.1.0
npgsql.entityframeworkcore.postgresql(PostgreSQL / NPGSQL Entity Entity Framework核心提供商)的pgroonga扩展名。它可以使用EntityFramework Core,PostgreSQL和Groonga进行全文搜索,尤其是中文,日语等。


EF.Functions.Pgroonga*仅与Npgsql.EntityFrameworkCore.PostgreSQL > = 2.2.6 and> = 3.0.1配合使用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 ( ) ;有关更多信息,请参见PGroongaLinqExtensions和PGroongaDbFunctionsExtensions 。
LIKELIKE ILIKEILIKE相同&@匹配&@~查询&@*类似的搜索&` scriptquery &@|火柴&@~| queryin &^ 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_truncate麻省理工学院许可证
更多信息请参阅许可证