Hello,
>From what I can tell, this is the place to ask about a bug in the ADO.Net
>driver for SQLite. If it's not, my apologies.
I've run into an issue while using System.Data.Sqlite.Core v 1.0.93.0 to
execute select queries like the following:
SELECT "Country"."Id", "Country"."Code", "Country"."Title",
"Country"."ShortTitle", "Country"."ModifiedOn", "Country"."ModifiedBy"
FROM "Country" INNER JOIN "ProgrammingMapView" ON ("Mid"."Id" =
"ProgrammingMapView"."Mid") INNER JOIN "Mid" ON ("Country"."Code" =
"Mid"."CountryCode")
WHERE ("ProgrammingMapView"."ProductId" = 87)
ORDER BY "Country"."Title" ASC
When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method
returns only the table name, in my case "Country".
There's a lot more detail to this question posted at:
http://stackoverflow.com/questions/25534898/trouble-with-sqlexpressiont-join-and-column-names
Thanks in advance for any help,
Zachary Yates
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
