123insight MRP ERP Software

  MRP/ERP/CRM/Accounts Software.

Home: 123insight Version 7 - A true .NET application

For the benefit of the more technically-literate layman, what do we mean by the term .NET application?

A .NET application gives both the programmer and the end-user many advantages, but the key ones from the point of view of 123insight are:

  • The end of “DLL hell”
  • Object Oriented Programming (OOP)
  • Direct data layer interaction with the SQL database


Previously, before .NET, this used to be a major issue. "DLL Hell" is a well known term in the world of software and refers to the set of problems caused when multiple applications attempt to share a common component like a dynamic link library (DLL) or a Component Object Model (COM) class. In the most typical case, one application will install a new version of the shared component that is not backward compatible with the version already on the machine. Although the application that has just been installed works well, existing applications that depended on a previous version of the shared component might no longer work. In many cases there is a significant delay before a user discovers that an application has stopped working.  As a result, it is often difficult to remember when a change was made to the machine that could have affected the application. A user may remember installing something a week ago, but there is no obvious correlation between that installation and the behavior they are now seeing. The reason for these issues is that version information about the different components of an application aren't recorded or enforced by the system. Also, changes made to the system on behalf of one application will typically affect all applications on the machine.

.NET has introduced the concept of “run once – run forever” meaning that if a .NET application is installed and works then it will remain working forever, regardless of what other applications (.NET or non .NET) are installed on to that machine.


OOP is a type of programming in which programmers define not only the data type of a data structure (like a stock record), but also the types of operations (functions) that can be applied to the data structure. In this way, the data structure becomes an object that includes both data and functions.
A discipline is forced on the programming team insofar as functions (like how a stock record is read, updated, and created) are defined up front and then are called upon whenever needed by the application – so these functions become commonly used by multiple routines. This makes object-oriented programs significantly easier to modify and maintain.


123insight uses a direct database layer underneath its business logic layer to read and write to / from SQL directly, the entire application was written to take full advantage of every aspect of the SQL Server Database Engine

In many other applications the interaction with SQL was a second phase development using ODBC and this just cannot offer the speed and stability that 123insight offers

More info:







dot net logo












  © 123 Solutions Ltd Top