MrDHelper 2.1.3

<div id="top"></div>

<br /> <div align="center"> <a href="https://github.com/dattiphu2022/MrDHelper"> <img src="Images/logo.jpg" alt="Logo" width="80" height="80"> </a>

<h3 align="center">Mrd common use helper</h3> </div>

<details> <summary>Table of Contents</summary> <ol> <li> <a href="#about-the-project">About The Project</a>
</li>
<li><a href="#usage">Usage</a></li> <li><a href="#roadmap">Roadmap</a></li> <li><a href="#contributing">Contributing</a></li> <li><a href="#license">License</a></li> <li><a href="#contact">Contact</a></li> <li><a href="#acknowledgments">Acknowledgments</a></li> </ol> </details>

About The Project

This project is providing "extension methods" that are usually used in short way.

New in 2.0.5 + 2.0.6 + 2.0.7

Add EfSqliteFts5

1. Kế thừa

using VietFtsSearch;

public sealed class DonVi : AuditableBase, IFtsIndexed, IHasGuidId
{
    public string PhienHieu { get; set; } = string.Empty;
    public string TenDayDu { get; set; } = string.Empty;
    public string? TenVietTat { get; set; }

    public string BuildFtsAllText()
        => string.Join(" | ", new[] { PhienHieu, TenDayDu, TenVietTat }
            .Where(x => !string.IsNullOrWhiteSpace(x)));
}

2. Đăng ký spec 1 lần khi app khởi động Ví dụ trong Program.cs (hoặc nơi cấu hình DI):

using VietFtsSearch;

FtsRegistry.Register<DonVi>(mainTable: "DonVis", ftsTable: "DonVi_fts", idColumn: "Id");
// sau này thêm entity khác => thêm 1 dòng Register

3. Gắn interceptor vào DbContextOptions

using VietFtsSearch;
using Microsoft.EntityFrameworkCore;

services.AddDbContext<AppDbContext>(opt =>
{
    opt.UseSqlite("Data Source=./applicationdatabase.db;");
    opt.AddInterceptors(new SqliteFtsSaveChangesInterceptor());
});

4. Ensure schema FTS (sau migrate)

using VietFtsSearch;

await db.Database.MigrateAsync();
await FtsSchema.EnsureFtsTablesAsync(db);

5. Search

using VietFtsSearch;

// FtsSearchOption.DefaultOrder + FtsSearchOption.Include
var search = new FtsSearchService(db);
var pagedResult = await search.SearchAsync<DonVi>(SearchQuery, FtsSearchOption, CancelationToken);

Roadmap

• Add Common functions.
• Add more functions.

See the open issues for a full list of proposed features (and known issues).

<p align="right">(<a href="#top">back to top</a>)</p>

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

<p align="right">(<a href="#top">back to top</a>)</p>

License

Distributed under the MIT License. See LICENSE.txt for more information.

<p align="right">(<a href="#top">back to top</a>)</p>

Contact

Nguyễn Quốc Đạt - @NguyenQuocĐat1989

Project Link: https://github.com/dattiphu2022/MrDHelper

<p align="right">(<a href="#top">back to top</a>)</p>

Acknowledgments

Use this space to list resources you find helpful and would like to give credit to. I've included a few of my favorites to kick things off!

• Choose an Open Source License
• GitHub Emoji Cheat Sheet
• Malven's Flexbox Cheatsheet
• Malven's Grid Cheatsheet
• Img Shields
• GitHub Pages
• Font Awesome
• React Icons

<p align="right">(<a href="#top">back to top</a>)</p>