dbTalk Databases Forums  

returning dataset from clr functions

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss returning dataset from clr functions in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Seba
 
Posts: n/a

Default returning dataset from clr functions - 02-18-2008 , 08:13 AM






Hi
Im trying to get dataset (table etc) from clr function/procedure. I know
there is VTF functions that allow return table of values. But this requires
specify columns that function returns.
There is also SqlContext.Pipe.Send - so I can pass sqlReader and get table
of values retuned by reader.

But i want to connect to another database (pervasive), get dataset from that
database and return table. I want to pass any query to function so i cant
use VTF function as query may be vary every time. And i cant use Pipe.Send
because im getting data from another database (using pervasive objects
including reader - so i have no sqlDataReader to pass it to pipe.send).

any idea how to return just DataSet?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.