search

yasser777 / nettiers

Automatically exported from code.google.com/p/nettiers
0 stars 0 forks source link

Single result custom SPs and custom SPs with paging #133

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I love how custom stored procedures work.

1)  Can we enhance NetTiers to include one additional setting for defining
the stored procedure (SP) name format for custom SPs that return 0 or 1
record? I have lots of cases where my SPs return 0 or 1 records and I
always have to handle the results using the Entity collections. The code
will be more much better if I don’t have to use the coll[0].Column.

2)  Can you make NetTiers recognize custom SPs, by using a name format, that
can do paging just like GetPaged methods. I have lots of places where I do
advanced searching (search thru other tables that are somehow joined) and I
want to page the results in the SP.

Original issue reported on code.google.com by Aleksand...@gmail.com on 25 Nov 2008 at 10:21

GoogleCodeExporter commented 9 years ago 
I am also looking for enhancement # 2. I have implemented paging in custom 
stored 
procedure. It will be great if the template can recognize paging in custom SPs.

Original comment by aroke...@dacor.com on 4 May 2009 at 11:34

GoogleCodeExporter commented 9 years ago

Original comment by bniemyjski on 25 May 2009 at 3:30

GoogleCodeExporter commented 9 years ago

Original comment by bniemyjski on 25 May 2009 at 4:18

GoogleCodeExporter commented 9 years ago 
I also have had to implement paging in a custom stored procedure. I have a 
master 
and a detail table. I have created a simple view that combines these tables. 
However 
I do not use this view it is only there to have nettiers create the domain 
object.

I have to be able to return a master record together with the latest detail 
record 
and also be able to search on a combination of fields from the master table and 
the 
detail table. I have created a stored procedure like the nettiers GetPaged 
stored 
procedures but I have added an extra select * from view to trick nettiers into 
believing it has to return a VList<ViewEntity> instead of a DataSet or a 
IDataReader. 

So far everything works. However nettiers generates a method that does not 
include 
the rowcount like the Getpaged in table and the Get in view generated code. Now 
I 
have to create an extra stored procedure just to get the rowcount.

Martin van der Linden.
(Netherlands)

Original comment by i...@lindenict.nl on 13 Aug 2009 at 9:26