C#

["name_data1", "123"],
["name_data2", "456"]"
["name_data3", "789"]

ID        INT, IDENTITY

ID        INT,IDENTITY
DataType  NVARCHAR

ID        INT, IDENTITY
MasterID  INT, FOREIGN KEY to Master.ID
RowID     INT, FOREIGN KEY to RowDesc.ID
VALUE     Your type for the data

public class Foo
{
    public event EventHandler Test;
}

public class Foo
{
    [CompilerGenerated]
    [DebuggerBrowsable(DebuggerBrowsableState.Never)]
    private EventHandler Test;
    
    public event EventHandler Test
    {
        [CompilerGenerated]
        add
        {
            EventHandler eventHandler = this.Test;
            EventHandler eventHandler2;
            do
            {
                eventHandler2 = eventHandler;
                EventHandler value2 = (EventHandler)Delegate.Combine(eventHandler2, value);
                eventHandler = Interlocked.CompareExchange(ref this.Test, value2, eventHandler2);
            }
            while ((object)eventHandler != eventHandler2);
        }
        [CompilerGenerated]
        remove
        {
            EventHandler eventHandler = this.Test;
            EventHandler eventHandler2;
            do
            {
                eventHandler2 = eventHandler;
                EventHandler value2 = (EventHandler)Delegate.Remove(eventHandler2, value);
                eventHandler = Interlocked.CompareExchange(ref this.Test, value2, eventHandler2);
            }
            while ((object)eventHandler != eventHandler2);
        }
    }
}

protected void OnTest(EventArgs e)
{
    Test?.Invoke(this, e);
}

Gerry Schmitz wrote:

What makes you "read" in the first place? I've never worked on a "port" application where you just read all the time.

You request, then read before the timeout interval.

// stop timer
// start timer
try
{
	while (myPort.BytesToRead > 0)
		logText += myPort.ReadExisting();   
}
catch (Exception ex)
	// handle exception

// stop timer
// display timer
// write file
// clear data buffer (String)

Member 12632601 wrote:

I receive only NullReferenceException

dynamic result = comobject.ExecuteQuery();

public async Task<LMSResponseParser> ScanForServer()
{
    using (var listener = new UdpClient(UDPPort))
    {
        this.ReceiveIP = new IPEndPoint(IPAddress.Broadcast, UDPPort);
        
        var result = await listener.ReceiveAsync();
        var requestData = result.Buffer;
        this.ReceiveIP = result.RemoteEndPoint;
        
        this.BytesSent = await listener.SendAsync(requestData, requestData.Length, this.ReceiveIP);
        
        result = await listener.ReceiveAsync();
        var bytesReceived = result.Buffer;
        if (bytesReceived != null && bytesReceived.Length != 0)
        {
            this.RetVal = Encoding.UTF8.GetString(bytesReceived);
        }
        
        return new LMSResponseParser(bytesReceived);
    }
}