Using EntityFramework with Sqlite InMemory, DbConcurrency and Migrations
Using EntityFramework with Sqlite in-memory and concurrency support, that is fully unit-testable and supports migrations.
Combining Expression[Func[T, bool]] of different Types
The other day, I was tasked with the problem of selecting entities from IQueryable<T> based on specific filter criteria that were only known at run-time. Basically, I had objects of different type with a set of properties. Here is an example, of what we were trying to solve. We have two expressions that apply to different types and both return […]
Converting Sparx Enterprise Architect Baseline Information from XML into C# objects
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()). […]
[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 […]
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 […]
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 […]
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 […]
Using Enterprise Architect Add-In Search Methods with XmlSerializer
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 […]
[NoBrainer] Simplifying Sparx Enterprise Architect Development with C# Interactive (CSI)
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 […]
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 […]
[NoBrainer] Connecting Enterprise Architect Interfaces with PowerShell
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 […]
[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 is: The requested connection is […]
Bugslayer: 10 days into EA14
My first 10 days into EA14 have passed by and I am discovering some issues ranging from nuisances to real distractors … So here is my list of bugs and […]
Extracting RTF Documents from XMI Files with PowerShell
Enterprise Architect allows you to create custom document templates to be used in your reports. Internally EA uses the oldie-goldie RTF document format for these templates. When exporting these templates […]
[NoBrainer] Automating Sparx Enterprise Architect with PowerShell
It has been some time since I have last posted something on our blog, so I will start with something easy: today I made the switch from Sparx Enterprise Architect […]
[NoBrainer] Adding meaningful error messages when using Contract.Result in C#
We at d-fens use Microsoft Code Contracts every day. And certainly with every great tool there are some things that might benefit from some improvement – and code contracts are […]
d-fens GmbH 