Re: Unknown column 'Distinct1.nCdSite' in 'where clause'

[Fernando Gonzalez.Sanchez]

Hi,

I checked this and is actually a bug in Connector/NET, we have created a public bug at: http://bugs.mysql.com/bug.php?id=68513

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:

http://social.msdn.microsoft.com/Forums/en-US/adonetefx/thread/f154595c-717e-4703-a81d-ee63633a481e

Thanks for your bug report.