On 2014/07/11 17:26, Bruce Cowan wrote:
When you select columns from a view, the (ADO.NET) DbDataReader that is
returned from the execute call does not contain sensible column names//....
...//This problem makes SQLite views completely unusable with ServiceStack.OrmLite version 4.0.23
or newer since it always uses the "view-or-table-name"."column-name" format for
select statements.
There is no contract of which column names should be returned, no "incorrect" headers and no guarantee, and no obligation from the
standard or any other requirement. If you need the returned names to be exactly something specific, then you need to use the "AS"
directive. I find it hard to imagine that ServiceStack.OrmLite does not know this - but it is possible. This question would
probably get more useful replies on an OrmLite forum.
Anyone else here using OrmLite with some success?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
