On 24 Jan 2014, at 6:24am, Frantisek Cerven <[email protected]> wrote:
> I want to ask you if is any way to call sqlite special commands > programatically from c#. These 'special commands' are not in SQLite at all. They are features of the command-line shell application. SQLite does not understand any command starting with a dot. > 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. I'm afraid that the way to do that quickly is to write some C# code which does it. A slower way to do it would be to have C# issue an operating system command that makes the shell tool do it. > Ps: There is not any support user forum?? This is it ! Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

