开发者

llbl stored procedure

开发者 https://www.devze.com 2023-02-06 21:40 出处:网络
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.

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      INFORMA开发者_C百科TION_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


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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号