I love FillbyPrimaryKey with the overload that accepts a paramarray of keys. But I would like to us a SPROC to get the data on the back end as there are a number of joins I'd prefer to handle there.



What is the syntax for calling using FillbyStoreProcedure or cmd.CommandType = StoredProcedure and having, as a parameter, a list(of T)



( need to do this with both integer keys and system.guid keys )



TIA

Well, this is some really cool stuff. The third article also introduced the hierarchyid data type in SQL which is just bloody awesome! I use hierarchies quite a lot and it was a pain in the...er...posterior. I also notices that it appears that T-SQL now can do OOP type stuff now. I.e. a variable that is a hierarchyid has methods! When did this happen?!?! Anyway, I'm very excited to delve into this more and hope to install SQL Server 2008 soon....Now back to planing for the migration of my companies SQL Server 2000 servers to SQL Server 2005....sigh...