Hi Castle Users!
Please, help-me with Projections and GridView:
# Chamado.cs
[ActiveRecord]
public class Chamado
{
[PrimaryKey]
public int Id { get; set; }
[Property]
public string Status { get; set; }
}
# ChamadoStatus.cs
public class ChamadoStatus
{
public string Status { get; set; }
public int QtdeChamados { get; set; }
}
# Test on aspx:
var projections = Projections.ProjectionList();
projections.Add(Projections.Property("Status"));
projections.Add(Projections.Count("Status"));
projections.Add(Projections.GroupProperty("Status"));
var query = new ProjectionQuery<Chamados,
ChamadosStatus>(projections);
GridView1.DataSource = q.Execute()
#### Error ####
Could not perform ExecuteQuery for Chamados ---> NHibernate.ADOException:
could not execute query [ SELECT this_.Status as y0_, count(this_.Status) as
y1_, this_.Status as y2_ FROM Chamados this_ GROUP BY this_.Status ]
Suggestioons?
Sorry by my poor english :(
Welkson Renny
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---