C#/.NET 0

[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 to write unit/integration tests that […]

C#/.NET 0

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 I show you how these […]

C#/.NET 0

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 all connectors of an element […]

C#/.NET 1

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) the more versatile Repository.SQLQuery only […]

Enterprise Architect 0

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 in the tutorial, in addition […]

C#/.NET 0

Transient Error Handling with automatic Retries in C#

Inspired by Transient Fault Handling we created a quick helper class to faciliate the automatic retry of various operation that may fail in today’s interconnected environments. Large parts of our Appclusive framework deal with fetching from and pushing information to various backend systems. As they all can (and eventuall will) fail we needed a flexible approach on how to retry […]

C#/.NET 0

Creating SignalR Hub Classes on the fly

Recently I wanted to create SignalR hubs for client notification based on a list of internal queues. As SignalR is creating Hubs based on their type names I had to find an approach for dynamically defining classes based on the given queue list. In this blog post I show a way on how to do this The Situation In our […]