//delete
 public void DeleteCaracteristiciModel(Guid ID)
 {
     //get exising record to delete
     Models.DbObjects.Caracteristici recordToDelete = dbContext.Caracteristicis.FirstOrDefault(x => x.ID_Caracteristica == ID);
     if (recordToDelete != null)
     {
         dbContext.Caracteristicis.DeleteOnSubmit(recordToDelete);
         dbContext.SubmitChanges();
     }
 }
 //update
 public void UpdateCaracteristiciModel(CaracteristiciModel caracteristiciModel)
 {
     //get existing record to update
     Models.DbObjects.Caracteristici existingModel = dbContext.Caracteristicis.FirstOrDefault(x => x.ID_Caracteristica == caracteristiciModel.ID_Caracteristica);
     if (existingModel != null)
     {
         //map updated values with keeping the orm reference
         existingModel.ID_Caracteristica    = caracteristiciModel.ID_Caracteristica;
         existingModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica;
         existingModel.NumeCaracteristica   = caracteristiciModel.NumeCaracteristica;
         dbContext.SubmitChanges();
     }
 }
        // map Model to ORM
        private Models.DbObjects.Caracteristici MapModelsToDbObject(CaracteristiciModel caracteristiciModel)
        {
            Models.DbObjects.Caracteristici dbCaracteristiciModel = new Models.DbObjects.Caracteristici();
            if (dbCaracteristiciModel != null)
            {
                dbCaracteristiciModel.ID_Caracteristica    = caracteristiciModel.ID_Caracteristica;
                dbCaracteristiciModel.ID_TipCaracteristica = caracteristiciModel.ID_TipCaracteristica;
                dbCaracteristiciModel.NumeCaracteristica   = caracteristiciModel.NumeCaracteristica;

                return(dbCaracteristiciModel);
            }
            return(null);
        }
        // map orm to model - mapper method
        private CaracteristiciModel MapDbObjectToModel(Models.DbObjects.Caracteristici dbCaracteristici)
        {
            CaracteristiciModel caracteristiciModel = new CaracteristiciModel();

            if (dbCaracteristici != null)
            {
                caracteristiciModel.ID_Caracteristica    = dbCaracteristici.ID_Caracteristica;
                caracteristiciModel.ID_TipCaracteristica = dbCaracteristici.ID_TipCaracteristica;
                caracteristiciModel.NumeCaracteristica   = dbCaracteristici.NumeCaracteristica;

                return(caracteristiciModel);
            }
            return(null);
        }