The Blog

The ALTER TABLE statement conflicted with the FOREIGN KEY constrain

I've been trying to apply a new migration and I was getting the following error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_dbo.Parent_dbo.Childs_ChildId". The conflict occurred in database "parents_db", table "dbo.Childs", column 'ChildId'. In my case, the table contained data. Therefore, either you have to assign a default value, set it as

Continue Reading

MediaElement Not Firing Events

Today, we encountered quite an interesting problem. MediaElement wasn't firing events. Using simple speech synthesis on Windows 8.1 using the speech synthesiser we tried:

None of the variations worked. The speech worked just the event wasn't getting fired. After a bit of digging it turned out that in order to fire events MediaElement must

Continue Reading

Implementation Overview in FHIR

Paradigms In order to make FHIR interoperable, it was based on 4 paradigms: RESTful API Documents Messages Services This is what's called an exchange framework. REST FHIR was primary designed to be used with Restful services which handle all requests. Restful service implies that we have a choice between using JSON or XML and it

Continue Reading

My Woes with Oracle Databases

I have been extensively working with the Oracle Database over the last couple of weeks. I thought I would share some of my experiences. The version I've been playing around isn't the newest, but, it roughly compares with the versions of MySQL and SQL Servers when I was learning databases. There is quite an interesting

Continue Reading

Architectural Views

Architectural views represent a perspective of looking at a particular problem solution. There are different standards. And different versions of diagrams. That is because one diagram rarely would give you everything you'd want. So you sort of mix and match. We have to recognize that there are many stakeholders in the system: from architects themselves,

Continue Reading

Databindings - small values treated as 0s

Today, I encountered an interesting problem with WinForms. In the application, NumericUpDowns (shown below) were used with small values e.g. 0.00001 etc. However, after we refreshed the panel, the value was being set to the default value. Digging further into the problem it turned out that the default Microsoft DataBinding converter was unable to convert

Continue Reading

How to use - (dash) in the ASP.NET MVC call?

ActionName attribute can be used:

 

Continue Reading

Undirected Graphs

Data structures capture relationship between the component values such as succession or relative magnitude. Graphs data structure is a very general representation of binary relations recorded as edges between a collection of vertices. There are many variations and extensions of graphs such as labelled vertices, labelled edges, root verities, multi-edges etc. However, in this article

Continue Reading

How to override MongoDB connection details in appsettings.json on Azure

It is actually pretty simple to override the connection settings in Azure. If you manage your connection inside the appsettings.json:

Then in Azure you should define these in Application Settings -> App settings. Seperate the layers by ":" (semi-colon). For example: Key: MongoConnection:ConnectionString Value: mongodb://admin:abc123!@localhost. Similarly, the database (key) MongoConnection:Database value: YourDb

Continue Reading

How to resolve: MongoDB.Driver.MongoAuthenticationException: Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1.

I came across this error today whilst trying to deploy my application on Azure. MongoDB.Driver.MongoConnectionException: An exception occurred while opening a connection to the server. ---> MongoDB.Driver.MongoAuthenticationException: Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1. As it turns out, MongoDB may have separate databases for authentication and data and therefore it is essential to specify

Continue Reading