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 […]
[HOWTO] Create Model Document using Sparx Enterprise Architect API
This blog post is about how to create model documents by using the Sparx Enterprise Architect (EA) API. Model documents are part of EA Virtual Documents and are modeled as child elements of report packages. Therefore the creation of model documents described hereafter requires an existing report package. Of course, report packages can also be created using the Sparx EA […]
Converting notes of Sparx Enterprise Architect custom scripts from XML into C# object
While I was working on a feature for an Enterprise Architect (EA) Add-In I had to get information about the scripts, which are stored in EA. The scripts are stored in table t_script and the information I needed was Name and Language. Both properties reside inside the Notes column. Selecting Notes of table t_script with the following SQL query in […]
[HOWTO] Use Sparx Enterprise Architect API method Repository.InvokeConstructPicker
To implement a feature for an Enterprise Architect (EA) Add-In I needed to show a dialog to the user, which allows him to select a package. The repository class provides a method called InvokeConstructPicker to do so. It seemed to be pretty simple. It was, but you have to consider a small detail, which I did not do in the […]
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 […]
WPF Series -13- Advanced Installer
The last post in this series deals with the packaging of a WPF application. To simplify the installation of our WPF application we decided to package the application as MSI […]
WPF Series -12- Global Exception Logging
During development and debugging of our WPF application some exceptions occurred which were not caught by the code. Such unhandled exceptions are not logged automatically. In order to obtain information about any unhandled exceptions in production and to simplify error analysis, we looked for a way to handle and log unhandled exceptions. After some research we ended up with the […]
WPF Series -11- Custom MetroDialog
After a long break it’s finally time to continue with the WPF series. Today I’ll show you how we implemented a custom metro dialog. Our dialog contains 2 comboboxes and […]
[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 […]
WPF Series -10- InkCanvas with initial StrokeCollection
One of the requirements our WPF project had to meet describes the ability to create a sketch of the sewage shaft for which data is collected. The functional acceptance criteria […]
d-fens GmbH 