RE: [Firebird-net-provider] Questions about the .NET Data provider

[Alan M. <al...@me...>]

> Well i have no experience with ASP.NET ( i will try to start to see it
> after try to implement Events API i'm going to start witrh it today ),
> but now you can exec command with FIRST/SKIP clausule, are you thinking
> in make it automatic or how ??
>

I assume that all this .NET stuff and all the older ASP stuff has been
written with both eyes firmly planted on MSSQL. I have no experience with
MSSQL so I could never confirm if certain efficiencies were being used which
were not accessible to users of other backends. I know I can now use
FIRST/SKIP clause but the use of these keywords in themselves is not readily
integrated into the ASP.NET model. They are certainly not surfacing in any
of the ASP server objects. I will have to look more closely now at the
sample ASP.NET apps. I will be looking eagerly at your employee.gdb example
app. Maybe I can contribute.

Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alan McDonald
> Sent: Thursday, 12 June 2003 7:12 PM
> To: CAR...@te...
> Cc: fir...@li...
> Subject: [Firebird-net-provider] Questions about the .NET Data provider
>
>
> Carlos,
> Can you tell me:...
> The ASP.NET coponents include a datagrid (much like the old datagrid for
> ASP) but it now sports a page numbering navigation bar (instead on the old
> first, last, previous, next links)
> I'm not sure how the old one handled this in terms of the query and paging
> but I suspect that even with large queries, the component, in conjunction
> with the recordset object would retrieve all records in the
> query, then page
> down/up to the required start point for the page control, then render the
> records required for the page. Obviously this is quite a heavy
> solution for
> larger datasets/queries. I have to suspect this to be so since
> the old ODBC
> drivers and the old IB (up to 6.0) never had the FIRST and SKIP commands.
>
> Now that FB has the FIRST and SKIP commands, will the ASP.NET provider be
> able to use them for the purpose of efficiently delivering page-sized
> recordsets to this new grid control? Is there another way it does this
> efficiently? Is there something I am missing?
>
> Thanks
> Alan McDonald
> PS - glad to see you are back on line - thanks to Sean - perhaps
> contact me
> offline - maybe there is something else you need which I might be able to
> provide you.
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>