Build a C# configurable console application

I need a C# configurable console-based Windows application that reads twenty (20) elements from an OPC DA server and writes them in tables within a SQL Server 2017 database. The main features and requirements are:

– Must be built using C# programming language.
– Must run in console mode and not-blocking I/O (asynchronous communication).
– Must run in recent Windows-based operating systems.
– Must have a control to start, restart, stop and check the status of the implementation.
– Must generate an event and error logs while executing.
– Must generate a record of the OPC-SQL transactions approved and failed.
– Must use MatrikonOPC Simulation Server (“Matrikon.OPC.Simulation.1”) as OPC DA server for tests.
– Must use a separated configuration file for all basic options available.
– Must allow browsing of OPC DA servers in remote nodes of the same network subnet.
– Must read all OPC items from a file used as a template.
– Template parameters for OPC tags are shown in one of the attached files.
– Each OPC tag is linked to a table within the SQL Server 2017 database.
– Backup (.bak) for SQL Server 2017 “system_db” database is also attached.
– Schema for every table is also shown.
– The write operation of the OPC tags to the SQL tables must be done all together, in one cycle, to fulfill the specified update rate (1000 ms).

The project will be considered finished when:
– The implementation is verified completely and the source code is delivered.