i have successfully implemented data acquisition from a modbus slave device by making a modbus master application deployed on vf61 module on colibri evaluation board running wince8 1.3b, development environment VS2013 professional.
now i have to couple this with a database.
which database do you recommend?
how do i setup a basic ‘read table’ application?
are there any known issues related with the above database?
work done so far
- read the http://developer.toradex.com/knowledge-base/how-to-use-sql-database-in-vcsharp article and downloaded the source files, i tried to include the 7 dll files but i could not do it as it gave a compatibility error
- read this article PAVE OVER How to: Deploy a SQL Server Compact 4.0 Database with an Application | Microsoft Docs but it talks about a publish tab which i was unable to find in 2013
- i downloaded this toolbox plugin SQLite and SQL Server Compact Toolbox - Visual Studio Marketplace and was able to create a simple database (.sdf file) and a table, i even tried firing queries and was successful, but i was unable to find APIs to access this database and the steps necessary to deploy this on toradex
- i read this stackoverflow answer http://stackoverflow.com/questions/20363374/is-sql-server-compact-discontinued-from-visual-studio-2013 and learnt that the sql server compact support is not provided by MS for VS2013.
Long story short, how do i make a database oriented project given the above specifications?