Re: [sqlite] Selecting from view gives bad column information

I would add a couple more comments: No other ADO.NET data provider that is supported by OrmLite has this problem. All the others return column names that can be differentiated one from another without requiring an "AS" directive. Also, I don't think there is an "ADO.NET" standard as such, just M

Re: [sqlite] Selecting from view gives bad column information

RSmith wrote: >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 f

[sqlite] Selecting from view gives bad column information when view name is used in quotes in select statement

When you select columns from a view, the (ADO.NET) DbDataReader that is returned from the execute call does not contain sensible column names when the select statement specifies "view-name"."column-name" or [view-name].[column-name]. Instead of column names, it just contains the view name for e