version 5.3 how to use typedview from results of stored procedure call

Posts   
 
    
M6rk
User
Posts: 37
Joined: 29-Sep-2004
# Posted on: 14-Jun-2018 16:50:26   

Using LLBGen 5.3 self service. I have a stored procedure that returns a datatable. I want to return a strongly typed view of the results though. I am looking at the help but cannot decode how to get results of the stored procedure call into a typed view.

My typed view is called SpPublishBulkDequeueResultTypedView My stored proc is called spPublishBulkDequeue My stored proc does not have any input parameters.

Example of call to retrieve as datatable

        var dt = Datalayer.StoredProcedureCallerClasses.RetrievalProcedures.SpPublishBulkDequeue();

How do retrieve and use as strongly typed view?

Thanks!

M6rk
User
Posts: 37
Joined: 29-Sep-2004
# Posted on: 14-Jun-2018 18:33:25   

Ha! Too simple i missed it. Here is my answer:

SpPublishBulkDequeueResultTypedView tv = new SpPublishBulkDequeueResultTypedView(); tv.Fill(null);