Bridging the gap between Business and IT

Working for my company mainly involves me in the areas of accounting, automation, and integration of disparate infrastructures and systems.

About Ronald Rink

I am a senior auditor and consultant at d-fens for business processes and information systems.

Converting Sparx Enterprise Architect Baseline Information from XML into C# objects

PackageBaselines

In this post I will show you how to easily work with Sparx Enterprise Architect Baseline information in C#. Baseline processing in Enterprise Architect is exposed via the ProjectClass (EA.Repository.GetProjectInterface()). From there we have to use a two-step approach to get a baseline and its stored information: Invoke project.GetBaselines() with a PackageGuid to get the […]

[NoBrainer] Simplifying and Speeding Up Testing in Sparx Enterprise Architect

Today’s post will be rather quick. I will show you how a unit/integration test class that can interact with real model data in Sparx Enterprise Architect. Beyond the well known Interop.EA assembly there is another assembly called SparxSystems.Repository that provides the intersting feature to connect to a running EA instance: Services.GetRepository(). We can use this […]

Dynamically registering UserControls in Sparx Enterprise Architect AddIns for showing them with Repository.AddTab

Sparx Enterprise Architect provides a means for AddIns to display Windows via Repository.AddTab() which are based on System.Windows.Forms.UserControl. However the call AddTab expects a name for the actual tab and a PROGID. EA actually takes this PROGID and loads the UserControl via the registry (as it is actually an Active COM Control). In this post […]

Improvements on the SqlXmlSerialiser

This is a followup to the last article Easy Conversion from Enterprise Architect XML SQL Queries to C# Objects. Every time we execute a query that returns results from more than one table we have to use aliasing in the SQL statement to differentiate columns with the same name. See below a query that retrieves […]

Easy Conversion from Enterprise Architect XML SQL Queries to C# Objects

In this article I show you how to easily convert arbitrary SQL query results in Enterprise Architect to native C# objects. The Enterprise Architect object model provides several methods which you can use to make direct SQL queries against the underlying database. And while Repository.GetElementSet really returns a Collection of native EA.Elements (but not connectors) […]

Using Enterprise Architect Add-In Search Methods with XmlSerializer

SearchResults

Sparx Systems Enterprise Architect supports the extension of the built-in search functionality by creating search queries with add-ins called Add-In Search. In this article I show you how to create an Add-In search that returns results to the “Find in Project” dialogue using an XML serialiser. Add-In Search Methods XML structure Serialisation Add-In Search Methods […]

[NoBrainer] Simplifying Sparx Enterprise Architect Development with C# Interactive (CSI)

CSharpInteractiveConsole

Developing an AddIn for Sparx Enterprise Architect is tedious, even with the existence of support such as the great work of Geert Bellekens. However, since Visual Studio 2015 we can use the C# Interactive Console which allows us to fire up an instance of Enterprise Architect and test our code interactively before putting it into […]

Registering a Sparx Enterprise Architect AddIn on Windows 10 x64 without administrative permissions

Sparx Enterprise Architect supports AddIns so we can enhance its functionality and behaviour in our daily work life as an architect. This is normally done by adding a subkey to the HKEY_LOCAL_MACHINE\Software\Sparx Systems\EAAddins key. This is described in Geert Bellekens’ Tutorial: Create your first C# Enterprise Architect addin in 10 minutes. As we can read […]

[NoBrainer] Connecting Enterprise Architect Interfaces with PowerShell

Enterprise Architect ProvidedInterface

In one of our projects we needed to create a lot of components that expose interfaces. The steps to design this in EA are quite tedious: Link the Interface to the diagram of our component. Create a ProvidedInterface and attach it to the component Set the name of the ProvidedInterface to the name of the […]

[Bug] Sparx Enterprise Architect v14.0 Build 1421 breaks using Deployment Diagrams

A quick one: last Friday, Sparx released an update to its Enterprise Architect v14.0. When I installed it today I noticed that all of a sudden I could no longer use the Deployment Connector to connect an Artifact with an Execution Environment. However, the same morning it still worked. The error message I now get […]