Custom Unit of Work Interface - Why No Stored Procedure Listings?

This is a migrated thread and some comments may be shown as answers.

5 Answers 92 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

5 Answers, 1 is accepted

answered on 10 Apr 2012, 04:18 PM

Context.zip

Hello Brian,

I have slightly modified the context code generation template to enable the generation of the stored procedure method definitions within the IUnitOfWork interface.

Please find the modified template attached to my answer. You need to place the template under the following directory [OpenAccess_Install_Dir]\dsl2010\CodeGenerationTemplates\CSharp\Includes.

Hope that helps.

All the best,
Damyan Bogoev
the Telerik team

Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>

answered on 11 Apr 2012, 09:53 AM

Hello Brian,

Firstly I want to apologize for the inconvenience caused.
I have done the following changes in the Context.ttinclude template in order to generate the stored procedure methods in the IUnitOfWork interface:
- Modified the GenerateContextInterface method to accept one additional parameter and added an additional method call to the GenerateContextInterfaceMethods method in the GenerateContextInterface;

private void

GenerateContextInterface(Telerik.OpenAccess.CodeGeneration.CodeInterface codeInterface, Telerik.OpenAccess.CodeGeneration.CodeClass context)

{

this.PushIndent("\t");

this.GenerateComments(codeInterface.Comments);

string interfaceSignature = GetInterfaceSignature(codeInterface);

this.WriteLine(interfaceSignature);

this.WriteLine(classOpenToken);

this.GenerateContextInterfaceMembers(codeInterface);

this.GenerateContextInterfaceMethods(context);

this.WriteLine(classCloseToken);

PopIndent();

}

- Defined a new method which generates the needed method definitions in the interface:

private void GenerateContextInterfaceMethods(Telerik.OpenAccess.CodeGeneration.CodeClass context)

{

System.Collections.Generic.IEnumerable<Telerik.OpenAccess.CodeGeneration.CodeFunction> functions = context.Functions;

PushIndent("\t");

functions.ForEach(

function =>

{

bool generateRef= false;

if(function.FunctionType == Telerik.Data.Dsl.DomainFunctionType.Void)

{

generateRef = true;

}

string clrParametersDeclaration = GetClrParametersDeclarationForFunction(function, generateRef);

string returnType = function.ReturnType;

if (string.IsNullOrEmpty(returnType))

{

returnType = "object";

}

string methodToBeExecuted= string.Concat("this.ExecuteQuery<",returnType,">");

string resultType= string.Concat("IEnumerable<", returnType, ">");

if(function.FunctionType == Telerik.Data.Dsl.DomainFunctionType.Void)

{

methodToBeExecuted = "this.ExecuteNonQuery";

resultType = "int";

}

else if(function.FunctionType == Telerik.Data.Dsl.DomainFunctionType.PrimitiveType)

{

methodToBeExecuted = string.Concat("this.ExecuteScalar<", returnType,">");

resultType = function.ReturnType;

}

this.WriteLine(string.Empty);

#>

<#=resultType#> <#= function.Name #>(<#= clrParametersDeclaration #>);

<#+

});

this.PopIndent();

}

- Modified the GenerateContextFileBlock to call the GenerateContextInterface method by passing the context variable:

this.GenerateContextInterface(contextInterface, context);

Hope that helps. If any other question arises, do not hesitate to contact us back.

Kind regards,
Damyan Bogoev
the Telerik team

Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>