I'm trying to generate Action Stored Procedure code using LLBLGen Pro 2.6. The generated code includes the helper namespace and a couple types that aren't defined. Unless I include all generator tasks, I'm missing the interface ITransaction and under no circumstances does the DbUtils class generate. I've included SD.LLBLGen.Pro.DQE.SqlServer.Net20.dll, LinqSupportClasses.Net35.dll, ORMSupportClasses.Net20.dll and TypeConverters.dll. This gets me my interface, but not the DbUtils class.

Is there some other library I need to include a reference to? Exactly what generator tasks do I need to include in order to use an action stored procedure?

I've been digging most of the day for an answer to this with no luck.

Thanks ahead of time for any assistance.

Are you using one of the shipped template sets? Which one (Adapter or SelfServicing)?

Normally this is available by default, and I'm not sure if you have been modifing these templates and/or tasks or not.

Walaa wrote:

Are you using one of the shipped template sets? Which one (Adapter or SelfServicing)?

Normally this is available by default, and I'm not sure if you have been modifing these templates and/or tasks or not.

I'm using the Linq to Sql template. To my knowledge, this template has not been modified. I think I'll do some digging and find out if stored procedure calls are even supported using this template. From what I've seen, it's supposed to.

stickman wrote:

I'm using the Linq to Sql template. To my knowledge, this template has not been modified. I think I'll do some digging and find out if stored procedure calls are even supported using this template. From what I've seen, it's supposed to.

Linq to Sql templates are additional templates for v2.6 (they are shipped as a target framework on v3.x). Linq to Sql has nothing to do with LLBLGen Runtime Framework, which means that you don't need to reference the SD.LLBLGen.Pro.DQE.SqlServer.Net20.dll, LinqSupportClasses.Net35.dll or ORMSupportClasses.Net20.dll.

DBUtils class is generated when you choose SelfServicing Template group. So, I think you are trying to generate LLBLGen Runtime code, choose either Adapter or SelfServicing. If you plan to use MS Linq to Sql, then choose that template and don't reference LLBLGen runtime assemblies. Here is more on Template Groups.

Note that Linq to Sql is not the same that Linq2LLBL. Linq to Sql is a MS Framework and at the generated code it has nothing to do with LLBLGen. The templates are there in case you want to use it. Linq2LLBL is LLBLGen's own Linq API that is built on top on LLBLGen runtime libraries. You can use Linq2LLBL in either Adapter or SelfServicing.

Please let us know if you have further questions about this. Hope helpful

daelmo wrote:

DBUtils class is generated when you choose SelfServicing Template group. So, I think you are trying to generate LLBLGen Runtime code, choose either Adapter or SelfServicing. If you plan to use MS Linq to Sql, then choose that template and don't reference LLBLGen runtime assemblies. Here is more on Template Groups.

Please let us know if you have further questions about this. Hope helpful

That sheds some light on my problem. I've got a couple more questions, but those I can find answers to just by playing with the program.

Thanks.