@W3Max >> Thanks for nothing.
Please don't get me wrong, but I really would avoid using this statement (especially in public) at "all" times. Not trying to tell you what to do (sorry if sounds so), but really the guy is just trying to help in the way he sees appropriate. He sounds like saying that maybe you need to add some unit tests to capture such behaviors earlier or with better feedback or so .... >> Come on, I thought the user group would have been more friendly. Did I insulted you by asking this question? Well, welcome to nhusers group. That's just how it is. *Mohamed Meligy *Readify | Senior Developer M:+61 451 835006 | W: www.readify.net [image: Description: Description: Description: Description: rss_16] [image: Description: Description: Description: Description: cid:[email protected]] <http://www.linkedin.com/in/meligy> [image: Description: Description: Description: Description: cid:[email protected]] <http://twitter.com/meligy> <http://www.greatplacetowork.com.au/best/best-companies-australia.php><http://www.readify.net/AboutUs/NewsItem.aspx?id=10> On Wed, Dec 8, 2010 at 11:11 AM, W3Max <[email protected]> wrote: > I don't understand why you take some time to answer the question and > buck on some words I maybe misused!? > I don't care about using HQL as long as it works! And what is this > thing about unit tests ? > > Come on, I thought the user group would have been more friendly. Did I > insulted you by asking this question? > > Thanks for nothing. > > By the way, I resolved my problem by using a view. > > On Dec 6, 10:19 pm, Fabio Maulo <[email protected]> wrote: > > what mean, for you, "magic string"? > > if you will have an exception, for a wrong query, during the start-up > > of your application, in your opinion, is an HQL a "magic string"? > > > > P.S. If you have, at least, a test for that query perhaps a "magic > > string" can be only a mirage. > > > > -- > > Fabio Maulo > > > > El 06/12/2010, a las 21:14, W3Max <[email protected]> escribió: > > > > > > > > > > > > > > > > > Can you help me with this query (I'm using NHibernate 3 + > > > FluentNhibernate AutoMappings) > > > > > Copied from stackoverflow : > http://stackoverflow.com/questions/4351683/how-can-i-do-this-query-wi... > > > > > How can I do this query with NHibernate > > > > > select top 10 count(distinct classedition.createdby_id) as editions, > > > class.id, > > > class.name, class.createdon, class.createdby_id > > > from class > > > inner join classedition on class.id = classedition.class_id > > > group by class.id, class.name, class.createdon, class.createdby_id > > > order by editions desc, class.createdon desc > > > > > I'm using NHibernate 3. I tried to do it with the new Linq provider > > > without success. I don't care about the way of doing it as long as it > > > produce the exact sql query above. I would prefer writing a strongly > > > typed query, without magic string if possible. > > > > > I'm new to NHibernate so this question may be simple. > > > > > Here is a little more info > > > > > I use Fluent NHibernate with AutoMappings. The C# classes are very > > > simple: > > > > > public class Class > > > { > > > public virtual int Id { get; set; } > > > public virtual string Name { get; set; } > > > public virtual DateTime CreatedOn { get; set; } > > > } > > > > > public class ClassEdition > > > { > > > public virtual int Id { get; set; } > > > public virtual Class Class { get; set; } > > > public virtual User CreatedBy { get; set; } > > > } > > > > > public class User > > > { > > > public virtual int Id { get; set; } > > > public virtual string Name { get; set; } > > > } > > > > > -- > > > 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]<nhusers%[email protected]> > . > > > For more options, visit this group athttp:// > groups.google.com/group/nhusers?hl=en. > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
