public async Task <Guid> Create(Models.Competences comp)
        {
            try
            {
                var context = CreateContext();
                var created = new Data.Competences
                {
                    Id            = comp.Id,
                    UniversId     = comp.UniversId,
                    NomCompetence = comp.NomCompetence,
                    EstNumerique  = comp.EstNumerique,
                };
                var enr = await context
                          ._Competences
                          .AddAsync(created);

                await context.SaveChangesAsync();

                return(enr.Entity.Id);
            }
            catch (DbUpdateException e)
            {
                Console.WriteLine(e.Message);
                return(comp.Id);
            }
        }
        public async Task Delete(Models.Competences comp)
        {
            try
            {
                var context  = CreateContext();
                var toDelete = await context._Competences.FindAsync(comp.Id);

                if (toDelete != null)
                {
                    context._Competences.Remove(toDelete);
                    await context.SaveChangesAsync();
                }
            }
            catch (DbUpdateException e)
            {
                Console.WriteLine(e.Message);
            }
        }
        public async Task Update(Models.Competences comp)
        {
            try
            {
                var context  = CreateContext();
                var toUpdate = await context._Competences.FindAsync(comp.Id);

                if (toUpdate != null)
                {
                    toUpdate.Id            = comp.Id;
                    toUpdate.UniversId     = comp.UniversId;
                    toUpdate.NomCompetence = comp.NomCompetence;
                    toUpdate.EstNumerique  = comp.EstNumerique;

                    await context.SaveChangesAsync();
                }
            }
            catch (DbUpdateException e)
            {
                Console.WriteLine(e.Message);
            }
        }