EA 13 and Elements.AddNew

[Eamonn John Casey]

I am having trouble with preventing adding duplicate elements in EA 13 Desktop Edition. The code below does not find the element (foreach). Also for some strange reason the SQLQuery does not return values. But in EA the same SQL returns values.

Any ideas? Is there something that I need to do on the repository til ensure updates are written?

Code: [Select]

internal Element FindOrCreateElement(Package rootPackage, string elementName, string stereoType)
{
    Element returnElement = null;

    foreach (Element element in rootPackage.Elements)
    {
        if (0 == element.Name.ToLower().CompareTo(elementName.ToLower())
            && 0 == element.Stereotype.ToLower().CompareTo(stereoType.ToLower()))
        {
            returnElement = element;
            break;
        }
    }

    if (null == returnElement)
    {
        returnElement = rootPackage.Elements.AddNew(elementName, stereoType);
        returnElement.Update();
    }
    return returnElement;
}

[qwerty]

You are just looking in one package and not recursing. Try

Code: [Select]

Repository.GetElementSet("SELECT * FROM t_object WHERE Name = '...'") instead.

q.

[Eamonn John Casey]

Almost. But this bombs out too...

Code: [Select]

internal EA.Collection GetElementSet(int packageID, string stereoType)
{
    EA.Collection elements =
        eaRepository.GetElementSet(
        String.Format(
        "SELECT * FROM t_object WHERE Package_ID = {0} AND StereoType = {1}", packageID, stereoType), 0);

    return elements;
}

[qwerty]

You need to quote stereotype. It's a string.

q.