Using EntityFramework with Sqlite in-memory and concurrency support, that is fully unit-testable and supports migrations.
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 […]
While working with Enterprise Architect (EA), it has already happened a few times that for unknown reasons objects in EA database referred to classifier GUIDs that are not or no longer existing. If the underlying database is an oracle database, such entries can be found by using the following SQL query.
[SecondFirstTry] Connecting to a server based repository in Sparx Enterprise Architect with TLS 1.2 correctly
I grabbed the task to transfer a Enterprise Architect repository from one MSSQL server to another. Sparx Enterprise Architect ships with an action called “Project Transfer” that supports repository transfer […]
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 […]
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 […]
This blog post serves as a thought support and describes the necessary steps to create a Sparx Enterprise Architect project in a Microsoft Azure SQL database. Prerequisites Enterprise Architect v14 […]
If you are using LocalDB and want to create an empty database you should perform the following steps. Go to Visual Studio Server Explorer | Data Connections Select Add Connection from the context menu Change Data Source to Microsoft SQL Server Database File (i.e. LocalDB) Set the Database file name by entering a database name and path that corresponds to […]
ODataQueryOptions do not correctly apply $filter and $orderby Options to IQueryable when using EntityFramework 6 with SQL Server
This blog post is a bit more lengthly than my usual posts and the idea came from an issue I faced when working in one of our project where we use an OData v3 REST interface that talks to an MS SQL Server (2012 R2) via EntityFramework v6.1.3. In short: we wanted to implement ‘entity framework row level security’ (in […]
This module provides Cmdlets that let you work with Microsoft SQL Server database (regular and LocalDB) by utilising System.Data.SqlClient (instead of relying on the buggy ‘SqlServerCmdletSnapin100’ snapin and its ‘Invoke-Sqlcmd’ implementation. You can set a ‘DefaultPrefix’ or an alias to call it the same as the Microsoft SQL Server supplied ‘Invoke-Sqlcmd’. Furthermore you can work with LocalDB instances (as used […]
=== UPDATE 2014-10-19 === I created a separate module that uses the SqlClient where you do not have to specify the command type and where you can also use LocalDB connections. === For the full module and description see my Post Module: biz.dfch.PS.System.Data. === UPDATE 2013-12-21 === added an additional parameter to specify the command type manually === Sometimes we […]