Using (xsd) TableAdapters

[taMaule]

I am developing an ASP.NET site that will provide both searching and browsing for on line inventory. The inventory is in a SQL 2005 database. I want to use TableAdapters (xsd) to create the necessary browsing functions (GetInventoryBySectionID) and so on.

My question is this -- do these work well for very large databases (100,000 + records)? Will using this method create long load times when changing from section to section or page to page?

They work very well on the "local" sample database but it only contains about 50 records...

Anyone have a suggestion?

[taMaule]

I am guessing that either no one knows the answer to this question -or- it has been deemed too stupid to comment on. In either case I am going ahead with the use of table adapters in my project and will deal with whatever comes from this decision.

Thanks anyway!