What is the SQL query, may I ask? RP
On Friday, November 21, 2014 12:55:27 AM UTC, Bryan Valencia wrote: > > I have an ad hoc object type, CombinedData and a T-SQL query that fetches > the right data. I want to load a list of the CombinedData objects from the > results of the query. > > The column names in the result set do not exactly match the Object field > names. > > So far I have... > > ISQLQuery Query = myDB.Session.CreateSQLQuery(SQL); > ICollection<CombinedData> coll = Query.List<CombinedData>(); > > This fails miserably because: > > 1. it seems to be fetching ALL the data from the database (not lazy > loading) > 2. it crashes because whatever the hell is coming back, it's not a > "CombinedData" type. > > Here's what I want. > I want to get this Massive, ugly query (SQL) to push back an IENUMERABLE, > that I can then add my WHERE and ORDERBY clauses to, so that I can databind > it to a grid. > > I have googled for this and found NO EXAMPLES. > > There is some chat about AddEntity, but I have no idea what that does. > > There is some chat about SetResultTransformer but no examples of > implementing the interface. > > I am exceedingly new to NHibernate, so if you're gonna RTFM me, tell me > where the FM is that shows examples how to get there from here. > > -- 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.
