hotmail wrote:
Hello,
i tried it but ran into an issue (may be a bug?). All my Retrieval stored procedure has following name pattern Sp+EntityName+Sel, for example SpOrganizationSel, and i am using reverse engineer resultsets to typed view, while i want the same name for retrieval stored procedure, i want my Typed View to be named Tv+EntityName . i basically want to strip prifix Sp and suffix Sel).
when i set the value {Sp}{} in Typed view name strip pattern, it does not strip Sp in my Typed View name. This only seem to work if i set the value {pr, sp, Sp}{} in Stored proc name strip pattern, but this will strip Sp from both Typed View and Stored procedure.
how do i strip Sp only from the Typed View?
This isn't supported currently, but it should indeed do so. The strip patterns for procs are applied when an SP Call is created, but it should be applied also in this case. It's an oversight. We'll see if we can fix it in 5.2.2 otherwise we'll postpone it.
Also it seems like when i remove Row from the Template it still creates file with a Row in it. and QueryFactory Projection assumes a Row in the class name. is there an easier method to this?
All i want is a file name same as class name, and the class name that strips Sp and Sel from above Stored Procedure naming convention.
The 'Row' is a suffix we'd recommend to keep. If you want to have a file name without 'row' you have to alter the preset, not the template: the preset dictates the filename.
Our tasks are defined in the .tasks files which define the default parameters. If you want to override the parameter value for the typedview task, add the following parameter to the
<taskPreset name="SD.Tasks.Generic.TypedViewPocoRowClassGenerator">
task
<parameter name="filenameFormat" value="[elementName].[extension]"/>
You can do that by opening the preset view, select the right preset and click 'copy as new' to create a copy of the preset to alter.