Hey
When using stored procedures to get data - does the result need to be
able to map to a model class which maps to a table?
I.e. can the SP return cols from 1*n tables to map to a single nhib class?
Can I do the following:
<code>
create procedure Get_stuff_from_thing
as
select a.col1, a.col2, b.col1 as col3 from table1 as a join table2 b
on a.foreignkey = b.id
</code>
and map the result to a new class:
<code>
public class Stuff {
public string Col1{get;set}
public string Col2{get;set}
public string Col3{get;set}
}
</code>
Know what I mean?
--
Cheers,
w://
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---