nerdDoro meets ms ef cf for ndXml
Jeffa
Posts: 80
Using Microsoft Entity Framework code first I've created a C# console application to poll the Spinneret nerdDoro project every 5 seconds to deserialize and persist the dateTime and temperature data that nerdDoro serves as XML. I have over 4,000 rows collected and the poller is still running. Cool!
Check out some queries I ran in ms SQL server management studio:
I've moved the Sensirion very close to my store bought RadioShack clock/thermometer with the two reporting temperatures within 2 degrees of each other.
ndXml solution attached.
Check out some queries I ran in ms SQL server management studio:
- minimum temperature is recorded on this date
- average temperature
- maximum temperature is recorded on this date
- rows in db
I've moved the Sensirion very close to my store bought RadioShack clock/thermometer with the two reporting temperatures within 2 degrees of each other.
ndXml solution attached.
1024 x 877 - 129K