You can fork off a child process, run the sqlite shell in that and pipe your commands to it.
Or you could write a CSV virtual table and execute something like "insert into <csv> select ..." -----Ursprüngliche Nachricht----- Von: Frantisek Cerven [mailto:feri...@gmail.com] Gesendet: Freitag, 24. Jänner 2014 07:45 An: sqlite-users@sqlite.org Betreff: [sqlite] csv export Hello, I want to ask you if is any way to call sqlite special commands programatically from c#. E.g. I need something like this in code not in command line: sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout If not, what is the quicker way to export table programatically? Now I`m doing it with DbDataReader, but it is slow. Ps: There is not any support user forum?? Thank you, Fratnisek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
