Finch is c# source generator designed to simplify database interactions by generating concise extension methods for database queries mappings.
-
Install the Finch NuGet packages:
$ dotnet add package Finch.Abstractions $ dotnet add package Finch.Generators
-
Mark the required type with an attribute corresponding to your desired database:
[GenerateSqlserverConnectionExtensions] public class TbUser { public int id { get; set; } public string name { get; set; } }
-
Use the extension method for your type:
var connection = new SqlConnection(connectionString); var items = await connection.QueryAsync<TbUser>("select * from tb_user");
Contributions to Finch are welcome! If you encounter any issues or have ideas for improvement, feel free to open an issue or submit a pull request on GitHub.
Finch is licensed under the MIT License.