Thanks for looking into it! I'll follow up with the ORM package authors. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, August 28, 2014 11:41 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)
Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mprod.RegisteredMid = m.Id) > join Product p on (p.Id = mprod.ProductId) > join MidProtocol mprot on (mprot.RegisteredMid = m.Id) > join ProtocolType pt on (pt.Id = mprot.ProtocolId) > join ProductProtocol pp on (pp.ProductId = p.Id and pp.ProtocolTypeId = pt.Id) > ; > Thanks. It should be noted that the above view refers to other tables as well. Anyhow, the best I can come up with at this point is that the ORM package(s) really should include AS clauses in the generated SQL in order to get the desired column names, per the SQL standard. This is not a bug in SQLite nor System.Data.SQLite. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
