On 27 Aug 2014, at 8:30pm, Zachary Yates <zachary.ya...@orolia.com> wrote:
> When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method > returns only the table name, in my case "Country". You do not provide your own names for the columns returned. Therefore SQLite is free to use whatever column names it likes including ones which make no sense to you. If you find it useful to have certain column names, then specify them yourself, like the following: SELECT "Country"."Id" AS CId, "Country"."Code" AS CCode, "Country"."Title" AS CTitle ... You might get behaviour more to your liking by omitting the quotes around table and column names, since they aren't needed. However the same rule applies: if you do not provide your own names for columns in the result, SQLite can pick whatever it wants. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
