Re: Unknown column 'Distinct1.nCdSite' in 'where clause'
Posted by: Fernando Gonzalez.Sanchez
Date: February 27, 2013 05:43PM


I checked this and is actually a bug in Connector/NET, we have created a public bug at:

You can subscribe to mail notification to get know the progress of the bug fix.

As a temporary workaround, you can rephrase the query into a SQL view like

select vis.nCdSite, count( distinct vis.sDsIp ) as Online1
from visitante as vis inner join Pagina as pag
on vis.nCdVisitante = pag.nCdVisitante
inner join site on vis.nCdSite = site.nCdSite
group by vis.nCdSite

Then map the view to a code first class as described here:

Thanks for your bug report.

Options: ReplyQuote

Written By
Re: Unknown column 'Distinct1.nCdSite' in 'where clause'
February 27, 2013 05:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.