[Table("DemoTable")]
public class DemoTable:BaseEntity,ISoftDelete
{
    public bool isDelete { get; set; }
    [Key]
    [Comment("主鍵")]
    public int id { get; set; }
    [Comment("姓名")]
    [MaxLength(20)]
    public string name { get; set; }
    [Comment("身份證號")]
    [MaxLength(18)]
    public string idCard { get; set; }
    public string test { get; set; } 
}

private string GetTableName() => typeof(T).Name;
public async Task<int> CreateAsync(T entity)
{
    try
    {
        using IDbConnection db = GetOpenConn();
        var type = entity.GetType();
        //在這里我們略過了 id 和test 字段，這樣在生成sql時就不會包含
        var properties = type.GetProperties(BindingFlags.Instance | BindingFlags.Public)
                            .Where(prop => !string.IsNullOrWhiteSpace(prop.GetValue(entity))&& prop.Name != "id" && prop.Name != "test ");
        var columns = string.Join(", ", properties.Select(prop => prop.Name));
        var values = string.Join(", ", properties.Select(prop => $"@{prop.Name}"));
        var query = $"INSERT INTO {GetTableName()} ({columns}) VALUES ({values})";
        return Convert.ToInt32(await db.QueryAsync(query, entity));
    }
    catch (Exception e)
    {
        throw new Exception(e.Message);
    }
}

using Dapper.Contrib.Extensions;
	[Write(false)]
	public int id { get; set; }
	[Write(false)]
    public string test { get; set; } 
using Dapper.Contrib.Extensions;
	[Write(false)]
	public int id { get; set; }
	[Write(false)]
    public string test { get; set; } 

public async Task<int> CreateAsync(T entity)
{
    try
    {
        using IDbConnection db = GetOpenConn();
		return db.Insert<T>(entity);
    }
    catch (Exception e)
    {
        throw new Exception(e.Message);
    }
}