AnantLabs / codesmith

Automatically exported from code.google.com/p/codesmith
1 stars 0 forks source link

CSLA vb.net r2497 Selecting a Command (Stored Procedure) Fails #629

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. EditableChildList.cst with SourceCommand
2. Various standard settings for v35 StoredProcedure generation (this is a bit 
confusing, because we have an SP driving the Business Object).
3. Tried to generate the output but got error messages in VS2010 output window. 
(See below)

What is the expected output? What do you see instead?

What version of the product are you using?
1. CS Generator 6.0.3.14219
2. SVN r2497
3. CSLA VB.net templates
4. SQL Server 2008R2.

Please provide any additional information below.
SQL Procedure.
CREATE PROCEDURE [dbo].[spGetPoliciesByClient]
    @lngPoliciesFKClient int
AS

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SELECT
    [idsPoliciesID],
    [lngPoliciesFKClient],
    [lngPoliciesFKFM],
    [txtPoliciesNumber],
    [lngPoliciesFKCovenant],
    [FMName]
FROM
    [dbo].[tblPolicies]
INNER JOIN tblFundManagers ON FMId = lngPoliciesFKFM
WHERE
    [lngPoliciesFKClient] = @lngPoliciesFKClient

Output Window text
C:\Users\JenasysDesign\Documents\Visual Studio 
2010\Projects\xxx\xxxx\Main\src\xxxx.BL\Clients\ClientEntities.csp(0,0) Object 
reference not set to an instance of an object.
Stack Trace:
   at Generator.CSLA.EntityCodeTemplate.GetTableOwner(Boolean includeDot)
   at Generator.CSLA.EntityCodeTemplate.GetTableOwner()
   at Generator.CSLA.EntityCodeTemplate.GetSelectStoredProcedureName()
   at _CodeSmith.EditableChildList_cst.EditableChildListDataAccessStoredProcedures.DataPortalFetchList.__RenderMethod1(TextWriter writer, Control control)
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at Generator.CSLA.CSLABaseTemplate.RenderHelper[T](T template, Boolean renderOptionalContent)
   at Generator.CSLA.CSLABaseTemplate.RenderHelper[T](T template)
   at _CodeSmith.EditableChildList_cst.EditableChildListDataAccessStoredProcedures.__RenderMethod1(TextWriter writer, Control control)
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at CodeSmith.Engine.CodeTemplate.RenderToFile(OutputFile outputFile, Boolean overwrite)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, String dependentUpon, Boolean overwrite)
   at Generator.CSLA.EntityCodeTemplate.RenderToFileHelper[T](String filePath, String dependentUpon, Boolean overwrite)
   at _CodeSmith.EditableChildList_cst.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at CodeSmith.Engine.ProjectCodeGenerator.GenerateCode(CodeSmithProject csp)

Unable to render output ClientPolicies_EditableChildList, skipping...

Done rendering outputs: 0 succeeded, 1 failed, 6 skipped (1280ms).

Original issue reported on code.google.com by jamie.cl...@jenasysdesign.com.au on 7 Mar 2012 at 8:02

GoogleCodeExporter commented 9 years ago
This issue was updated by revision r2573.

CSLA vb.net r2497 Selecting a Command (Stored Procedure) Fails

Original comment by bniemyjski on 16 Mar 2012 at 2:34

GoogleCodeExporter commented 9 years ago

Original comment by bniemyjski on 16 Mar 2012 at 2:34