Computer Environment Archives - {coding}Sight

Comparison of Tree Graphs

Dmitriy Vlasov — Fri, 06 Oct 2017 09:53:01 +0000

When developing an information system that also includes various processing of design and technological documentation, I faced the following problem. We have a certain product structure. During the day, different parts of this product are changed and by the evening, it is already unclear what has been changed. Sometimes, products can consist of more than …

The post Comparison of Tree Graphs appeared first on {coding}Sight.

Oracle as Workaround of Mutating Tables

Sergey Averin — Mon, 02 Oct 2017 11:47:13 +0000

The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger, resulting in the “ORA-04091: table name is mutating, trigger/function may not see it” message. Let’s have a look at the existing workarounds. The first one, through the package, is ancient and seems to be effective, however, it takes much …

The post Oracle as Workaround of Mutating Tables appeared first on {coding}Sight.

Oracle Regular Expressions. Dangerous Range

Sergey Averin — Fri, 29 Sep 2017 13:25:58 +0000

An Oracle developer who often uses regular expressions in code sooner or later can face a phenomenon that is indeed mystical. Long-term searches for the root of the problem can lead to weight loss, appetite and provoke various kinds of psychosomatic disorders – all this can be prevented with the help of the regexp_replace function. …

The post Oracle Regular Expressions. Dangerous Range appeared first on {coding}Sight.

How Generics save from Boxing

Nikolay Zdravkov — Mon, 18 Sep 2017 10:40:20 +0000

At the method input, we often perform a null test. Someone makes the test as a separate method, so that the code looks cleaner, and gets something like this: public void ThrowIfNull(object obj) { if(obj == null) { throw new ArgumentNullException(); } } The interesting thing about this test is that I see a frequent use …

The post How Generics save from Boxing appeared first on {coding}Sight.

Modular WPF Application using Caliburn.Micro and Castle.Windsor

Ivan — Wed, 30 Aug 2017 08:57:14 +0000

To start with, I want to specify what is meant by a modular application in this article. So, a modular application will be considered an application, which consists of the so-called shell and a set of plug-in modules. There is no direct dependence between them, only via contracts. This allows independently modify each of the …

The post Modular WPF Application using Caliburn.Micro and Castle.Windsor appeared first on {coding}Sight.

Key Indicators of Problem Design

Sergey Zolotaryov — Thu, 10 Aug 2017 10:34:53 +0000

The concept of good or bad design is relative. At the same time, there are some programming standards, which in most cases guarantee effectiveness, maintainability, and testability. For example, in object-oriented languages, this is the use of encapsulation, inheritance, and polymorphism. There is a set of design patterns that in a number of cases have …

The post Key Indicators of Problem Design appeared first on {coding}Sight.

Sliding Responsibility of the Repository Pattern

Aleksandr Goida — Thu, 03 Aug 2017 13:13:40 +0000

During numerous discussions about the applicability of the Repository pattern, I noticed that people are divided into two groups. In this article, I will call them abstractionists and concretists. The difference between them is in the way they treat the pattern value. The former believe that a repository is worthwhile, as it allows disregarding details …

The post Sliding Responsibility of the Repository Pattern appeared first on {coding}Sight.

Swashbuckle (Swagger) Customization for WebAPI

Aleksandr Goida — Thu, 27 Jul 2017 07:53:03 +0000

Who has ever tested their WebAPI knows such tools as Postman or Advanced REST (extensions for Chrome). These tools are convenient in every way, except that they are not able to recognize which models the API accepts, which ones it returns and do not provide information about all possible endpoints. The Swashbuckle package solves this …

The post Swashbuckle (Swagger) Customization for WebAPI appeared first on {coding}Sight.

DateTime to DateTimeOffset Transition

Aleksandr Goida — Tue, 25 Jul 2017 05:48:33 +0000

Imagine that you want to convert your system from one state to another. The initial state is when DateTime is used everywhere, both in C# code and in the database. The final state is when DateTimeOffset is used everywhere. You want to make the transition smooth and make as few changes as possible. This description …

The post DateTime to DateTimeOffset Transition appeared first on {coding}Sight.

Simplifying Converters for WPF

Ilya Mikhalin — Mon, 24 Jul 2017 09:30:42 +0000

I have been working with WPF for about a year and some things annoying me very much. One of such things is converters. Why do I need to declare the implementation of a dubiously looking interface somewhere at the deep of a project and then search for it through CTRL + F by name when …

The post Simplifying Converters for WPF appeared first on {coding}Sight.