[HOWTO] Create an EA Project in a Microsoft Azure SQL Database

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 Microsoft SQL Server Management Studio 18 (for direct download click here) Enterprise Architect Schema Creation Scripts for Microsoft SQL Server EASchema_1220_SQLServer.sql EASchema_1220_SQLServer_Update1.sql Enterprise Architect Initial […]

[HOWTO] Create LocalDB File (.mdf) manually in Visual Studio 2015

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 […]

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 […]

Module: biz.dfch.PS.System.Data

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 […]

[biz.dfch.PS.System.Data] Invoke-SqlCmd without the overhead

=== 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 […]