Hi, I am developing an application for Windows Compact Embedded 7 using .net 3.5 and sqlite.
We have two databases, db1, db2. A table shall b e copied from db1 to db2 using .net and c#. INSERT INTO db1.table SELECT * FROM db2.table How can I execute this command using ado.net 3.5 (Ce.net 3.5), how to connections to two databases. Is there an enviroment/console where I can run this (and other) command directly, to test them? Thank you very much.