Ok guys, thank you!
On Wed, May 20, 2015 at 9:43 AM, Richard Wilde <[email protected]> wrote: > ;). Decisions decisions. > > Sent from my Windows Phone > ------------------------------ > From: Ricardo Peres <[email protected]> > Sent: 20/05/2015 12:29 > To: [email protected] > > Subject: Re: [nhusers] Get Meta Data from Database table name and column > > I think so! > > RP > > On Wednesday, May 20, 2015 at 12:00:05 PM UTC+1, Rippo wrote: >> >> ummmm yes of course , but if he already has tables names and columns >> wouldn’t he be better off using CreateSQLQuery rather than transforming >> these into classes and props and using HQL? >> >> >> >> *From:* [email protected] [mailto:[email protected]] *On >> Behalf Of *Ricardo Peres >> *Sent:* 20 May 2015 11:12 >> *To:* [email protected] >> *Subject:* Re: [nhusers] Get Meta Data from Database table name and >> column >> >> >> >> Richard: >> >> CreateQuery uses HQL whereas CreateSQLQuery uses SQL. >> >> >> >> Felipe: >> >> You want to know to which tables and columns the entities and their >> properties map to, right? I once wrote a post on this, you can find it >> here: https://weblogs.asp.net/ricardoperes/nhibernate-metadata. >> >> >> >> RP >> >> >> >> On Wednesday, May 20, 2015 at 7:25:38 AM UTC+1, Rippo wrote: >> >> Quick question what is difference between? >> >> >> >> CreateQuery and CreateSQLQuery >> >> >> >> Many Thanks >> Richard >> >> >> >> *From:* [email protected] [mailto:[email protected]] *On >> Behalf Of *Felipe Oriani >> *Sent:* 19 May 2015 23:31 >> *To:* [email protected] >> *Subject:* Re: [nhusers] Get Meta Data from Database table name and >> column >> >> >> >> Yes, I know it does not sounds good but I'll try explain. >> >> >> >> My customer will develop some reports using the Telerik Report and the >> customer does not have knowledge of the model mapped with nhibernate, only >> the database. So, we are using some internal configurations of the telerik >> reports to create a dynamic filter on the page and one of these parameter >> are DropDownLists. The customer will configure the dropdownlists with >> database information like table, key/value columns. We could use SQL >> language to hit on database, but I would like to pass this responsability >> to NHibernate, using HQL. I am not sure if it is the best solution, but I >> think it works. >> >> >> >> I don't know how to get these information from NHibernate. Can you help >> me? >> >> >> >> >> >> >> >> >> >> On Tue, May 19, 2015 at 6:21 PM, Gunnar Liljas <[email protected]> >> wrote: >> >> But why use the table name and column name as parameters? Wouldn't the >> entity name and property name be better? Or even better, a property lambda. >> >> >> — >> Sent from Mailbox <https://www.dropbox.com/mailbox> >> >> >> >> On Tue, May 19, 2015 at 8:00 PM, Felipe Oriani <[email protected]> >> wrote: >> >> Hi all, >> >> >> >> I have a method which receives tree parameters that holds a table name >> and two columns. I would like to hit an HQL command using this information >> to create an list as a result. I know how to deal with HQL but I would like >> to know, how can I get the entity name and properties from these >> parameters, for sample: >> >> >> >> public IEnumerable<DropDownListDto> GetDropDownList(string tableName, >> string columnValue, string columnText) >> >> { >> >> string entityName = ???; >> >> string propertyValue = ???; >> >> string propertyText = ???; >> >> >> >> // I have the sessionFactory instance and session here. >> >> >> >> // execute hql and return results >> >> } >> >> >> >> Is there any way to do it? >> >> >> >> I have this parameters because it will be developed by a customer and not >> by the developer team. >> >> >> >> Thank you >> >> >> >> >> -- >> >> ______________________________________ >> Felipe B Oriani >> >> [email protected] >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> >> >> >> >> >> -- >> >> ______________________________________ >> Felipe B Oriani >> >> [email protected] >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > -- ______________________________________ Felipe B Oriani [email protected] -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
