PomeloFoundation/Home

Hi everybody, I just have a simple question and I hope someone here can answer that. I am using MariaDb in my production environment so Pomelo is my hero. But in developement I user sql server and one of my crud actions needs to return the id of a newly inserted entity. It was working just fine with sql server but when I changed it to MariaDB and uploaded to my online server it started returning a 500 error. When I inspected the trace, I saw that the entity is inserted to the db but next operations have failed. Those are rely on the Id that has been created when the entity being inserted.

public async Task<TEntity> AddAsync(TEntity entity)
        {
            using (TContext context = new TContext())
            {
                //var addedEntity = context.Entry(entity);
                //addedEntity.State = EntityState.Added;
                context.Add(entity);
                await context.SaveChangesAsync();

                //var value = addedEntity.GetDatabaseValues().GetType().GetProperty("Id").GetValue(entity, null);
                return entity;
            }
        }

I tried using quoted lines but when I do that, the manager operation says int has no awaiter, so I changed it to entity but no luck. It keeps throwing. How can I safely retrieve the id in a generic pattern like this? I have a business layer and I am calling db operations in that section, then in my API controllers, I just call an operation and return ok or badrequest according to the status. Thanks in advance.

Could you use this pattern? I have it working on my side:

   public virtual async Task<TEntity> AddAsync(TEntity entity)
   {
       var ent_entry = await _entities.Set<TEntity>().AddAsync(entity);
       return ent_entry.Entity;
   }

But I must confess, my db of choice is mysql-8