You are mixing too much things here. Nhibernate is not abou UI,but surely you can do something alike. Your real question should be something like "i want to pivot these XYZ data on db side, can nhibernate do this pivot query with a hql, criteria or linq?“
The answer is no, you should use a db specific feature, you can use sqlquery tag. 2010/10/2, shousper <[email protected]>: > Hi! > > I've got a bit of a challenge.. > Basically, I have sets of integers that are stored by date, by client. > However, the interface needs to display the information similar to a > crosstab/pivot query. > So the user can edit the integer value per client per date easily. > > Below is a cut down structure to give you the idea of the sets of > data: > > Client > --id > --name > > Meals > --clientID > --date > --count > > So you end up with a date range query for say .. a quarter of the > year? and you have headers: > Client, 01/01/2010, 02/01/2010, 03/01/2010, ... etc. > > And values like: > Bob, 1, 1, 1 > > My question is.. > Is there any simple way of querying the data in this format and > binding it to a DataGridView in WinForms _with_ updating? > > I'm using FluentNH, .NET 4, C# if that at all helps. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" 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/nhusers?hl=en. > > -- Enviado desde mi dispositivo móvil -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
