0

I have a problem on llbl. I have a stored procedure in my sql database and I want to get the stored procedure code in code(C#) side with llbl.

Sql Code:

SELECT    ROUTINE_DEFINITION
FROM      INFORMATION_SCHEMA.Routines
WHERE     ROUTINE_Name = 'FillStatistics'

This query is getting stored procedure code but I have to do this with llbl.

How can I do this?

Thanks, John

Greg B
  • 14,597
  • 18
  • 87
  • 141
John
  • 386
  • 1
  • 7
  • 22

2 Answers2

1

Add a call to the stored procedure in the designer, and then generating code which will contain a method to call the proc. See: http://www.llblgen.com/documentation/3.0/Designer/hh_goto.htm#How%20To/AddEditStoredProcedureCall.htm

Frans Bouma
  • 8,259
  • 1
  • 27
  • 28
0

I would suggest starting with the Online Docs for LLBL. In reference to your particular request i would start here. http://www.llblgen.com/documentation/3.0/Linq%20to%20Sql/hh_start.htm

David Yenglin
  • 675
  • 5
  • 14