HowTo Add TaggedValueType by AddIn

[RainerQ]

Hello,

what would be the appropriate way to add a TaggedValueType through a AddIn?

Thanks for hints and links.

Regards
Rainer

[RainerQ]

Hello,

ok, I found the answer  

private void AddPropertyTypeIfNotExisting(Repository repository, string property, string description, string notes)
        {
            if(this.PropertyExists(property, repository)) return;

            string sql = string.Empty;
            sql = "INSERT INTO t_propertytypes (Property, Description, Notes) VALUES (";
            sql = sql + "'" + property + "', ";
            sql = sql + "'" + description + "', ";
            sql = sql + "'" + notes + "')";
            repository.Execute(sql);
        }

Regards
Rainer

[Eve]

The appropriate way would be more like

Code: [Select]

EA.PropertyType tagType = rep.PropertyTypes.AddNew(property, "");
tagType.Description = description;
tagType.Detail = notes;
tagType.Update()
Your code will break if any of those strings contain '.

[RainerQ]

Hello Simon,

thank you very much for your advise!
I will refactor my code right away, since the appropriate way looks much nicer.

Regards
Rainer