AndotNet.MariaDB 1.0.0

Add connection string in Startup.cs constructor

    public Startup(IConfiguration configuration)
    {
        DataAccessLayer.DBTools.DBConfig.ConnectionString = Configuration.GetSection("DBConfig").GetValue<string>("ConnectionString");
    }

Create class Person, add [JsonConvertable] attribute, and implement IErrMsg interface

[JsonConvertable]
public class Person : Base, IPerson, IErrMsg
{
    public int? ID { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string ErrMsg { get; set; } // implemented from IErrMsg interface

    public Person()
    {
            
    }
}

Create function, call stored procedure from MariaDB

    public async Task<Person> GetAsync()
    {
        try
        {
            //stored procedure parameters
            List<SPParam> par = new List<SPParam>
            {
                new SPParam("id", this.ID),
                new SPParam("languageID", this.Language?.ID),
                new SPParam("RoleInAction",this.RoleInAction),
                new SPParam("UserInAction",this.UserInAction),
            };
            Person item = await MySQLDataAccess<Person>.ExecuteSPItemAsync("GetPerson", par); // GetPerson is the name of stored procedure
            return item;
        }
        catch (Exception ex)
        {
            return null;
        }
        finally
        {
        }
    }