Hello Anton,
Thanks for the reply. I did manage to get the custom method working shortly before your reply, but I’m still glad of the example - I’ll be using the Schema.DeriveDataReaderSchema instead of the manual creation of field and table schema data for the custom data I am returning. I’ll probably also make use of the AllowExecuteSQL property instead of the separate MSSQL.NET connection that I am currently using.
The key part I had been missing was the use of the overloaded WriteDataReader method - the one that includes the Boolean to indicate whether the schema should be returned or not. The version of the custom call Andrey quoted from last year did not make use of that overload.
The other issue I had about passing parameters into the call was my mistake. For some reason I was trying to pass Int32 types and not Integer.
Thanks Again,
Paul.