Connect to SQL Server from Microcontroller (Arduino or Fez with .Net Micro Framework)

.net sql microcontroller arduino .net-micro-framework
Tim picture Tim · Sep 16, 2010 · Viewed 19.9k times · Source

I'm looking for examples, tutorials, or just "this+this+this should work" for reading from and writing to a SQL server (2008) from a microcontroller such as the Arduino board. I've also looked at (and will probably go with) devices with the .Net Micro Framework such as the Fez Cobra. The Micro Framework does not include ADO. I'm sure this is going to involve some XML, but I can't figure out which technology to further investigate. I do not want to have an PC application to serve as a go-between.

Thanks!

Answer

joshperry picture joshperry · Sep 16, 2010

Honestly, I would make a thin service that would sit in-front of your database and use something lightweight like protobuf to get the data into your micro.

I doubt you'll be able to implement TDS in the limited power and memory of an AVR.

Related questions

What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More
how to insert datetime into the SQL Database table?

How can I insert datetime into the SQL Database table ? Is there a way to insert this query through the insert command in C# / .NET?

Read More
Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More