//IDbConnection
public static IDbConnection MySqlConn()
{
    IDbConnection conn = new MySqlConnection(MySqlConnettionString);
    if (conn.State == ConnectionState.Closed)
        conn.Open();
    return conn;
}

public static MyConnection GetMyConn()
{
    return MyConnection.CreateMySqlConn(MySqlConn()); //mysql
    //return MyConnection.CreateSqlServerConn(IDbConnection...); //sqlserver
    //return MyConnection.CreateSqliteConn(IDbConnection...); //sqlite
}

[Table(TableName = "people", KeyName = "Id", IsIdentity = true)]
public class peopleT
{
    public int Id { get; set; }

    public string Name { get; set; }

    public int Score { get; set; }

    public DateTime Time { get; set; }

    [Igore]
    public int age { get; set; } //no table column
}

using(var conn = GetMyConn())
{
    peopleT p = new peopleT();
    p.Name = "Jone";
    p.Score = 100;
    p.Time = DateTime.Now;

    int result = conn.Insert(p); //insert
    int identityId = conn.GetIdentity<int>();

    p.Id =1;
    conn.Update(p) //update ... where Id=@id

    conn.Delete<peopleT>(1) //delete by id

    peopleT p = conn.GetById<peopleT>(1); //get by id

    //More Method
    InsertMany，InsertKeyIfExistUpdate，InsertIdentity，Update，UpdateByWhere，DeleteByIds，DeleteAll，GetAll
    GetByWhere，GetByWhereFirst，GetCount，GetByIdsWhichField，GetBySkipTake，GetByPage......

    //Transaction (事物)
    conn.BeginTran()
    try
    {
        //...some options

        conn.CommitTran(); //commit
    }
    catch
    {
        conn.RollBackTran(); //if error rollback
    }

    //StoredProcedure (存储过程)
    conn.commandType = CommandType.StoredProcedure;
    var data = conn.Query("ProduceName");
}