I am using C# Visual Studio 2010 with EF 4.1. I am receiving some SCADA data that I would like to log to the database, all is well, until the data comes in quickly (not really that quickly)
I parse and massage the data, and then call a "logMessageToDB" function.
now if I call the function again before the last message has been logged, I get an error in my error handler
logging the message caused the following error -> The underlying provider failed on Open.
How can I log the data more quickly? why does it take so long to add a new record.
My function is below, please excuse the uglyness of it (I have just started with C#, there is a bit of a learning curve)