SQL != SP.
In any case, the problem with SPs (as you have already found out) is that it
is an island: if you need to extend it, it's a lot more work.
Diego
On Mon, Jul 12, 2010 at 13:40, Mike <[email protected]> wrote:
> I was unable to recreate my grid stored procedure in NHibernate. I
> believe I even received a note from you stating that using SQL Queries
> shouldn't be considered bad, unless I misunderstood what you are
> saying. I wish to avoid rewriting the query simply for the sake of
> rewriting it - I was hoping there was an effective way to make a SQL
> query play nice with another HQL or Criteria query.
>
> On Jul 12, 11:04 am, Fabio Maulo <[email protected]> wrote:
> > Yes!!
> > throw the SP and use HQL to return classes instead a DTO, then you can
> > create the DTO in RAM using a simple LINQ.Select
> >
> >
> >
> >
> >
> > On Mon, Jul 12, 2010 at 11:24 AM, Mike <[email protected]> wrote:
> > > Hello,
> > > I have a situation where I have a complex stored procedure returning
> > > records for a grid. At this point I do not have a business case to
> > > rewrite this Stored Procedure using NHibernate, so I am calling it as
> > > a named query and populating a DTO. This is working great.
> >
> > > However, now I need to supplement my DTO with my domain logic to add
> > > another column to the grid. I am still hoping to avoid having to
> > > rewrite this Stored Procedure. Initially, I was returning my DTO,
> > > using LINQ to extract an array of IDs, and calling an NHibernate query
> > > where my record ID's where in that list. This worked great until I
> > > tried to pull all of the records and hit the limit of allowed
> > > parameters in SQL Server 2005.
> >
> > > Are there any creative ways I can accomplish this successfully?
> > > Thanks!
> >
> > > --
> > > 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]>
> <nhusers%[email protected]<nhusers%[email protected]>>
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/nhusers?hl=en.
> >
> > --
> > Fabio Maulo
>
> --
> 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.
