Hi, My code is generated correctly in the designer, however, when compiled in VS2010, I get some errors....anyhoo...I narrowed it down to...I have a stored procedure with a parameter "date" so the generated code in the RetrievalProcedures.vb is this

' //////////////////////////////////////////////////////////////////////////////////////////////////////// ' // This is generated code. ' //////////////////////////////////////////////////////////////////////////////////////////////////////// ' // Code is generated using LLBLGen Pro version: 3.1 ' // Code is generated on: Tuesday, April 12, 2011 11:13:55 PM ' // Code is generated using templates: SD.TemplateBindings.SharedTemplates.NET20 ' // Templates vendor: Solutions Design. ' // Templates version: ' //////////////////////////////////////////////////////////////////////////////////////////////////////// Imports System Imports System.Data Imports System.Data.Common Imports SD.LLBLGen.Pro.ORMSupportClasses Imports MacolaImports.Data.DaoClasses Imports SD.LLBLGen.Pro.ORMSupportClasses.SelfServicingSpecific

Namespace MacolaImports.Data.StoredProcedureCallerClasses ''' <summary>Class which contains the static logic to execute retrieval stored procedures in the database.</summary> Public Class RetrievalProcedures ''' <summary>private CTor so no instance can be created.</summary> Private Sub New() End Sub

    ''' <summary>Calls stored procedure 'app_mac_gerpubpurchases'.<br/><br/>
    ''' </summary>
    ''' <param name="date">Input parameter of stored procedure. </param>
    ''' <param name="ref">Input parameter of stored procedure. </param>
    ''' <param name="createdby">Input parameter of stored procedure. </param>
    ''' <returns>Filled DataTable with resultset of stored procedure</returns>
    Public Overloads Shared Function App_Mac_Gerpubpurchases(date As System.DateTime, ref As System.String, createdby As System.String) As DataTable
        Return App_Mac_Gerpubpurchases(date, ref, createdby, Nothing)
    End Function

    ''' <summary>Calls stored procedure 'app_mac_gerpubpurchases'.<br/><br/>
    ''' </summary>
    ''' <param name="date">Input parameter of stored procedure. </param>
    ''' <param name="ref">Input parameter of stored procedure. </param>
    ''' <param name="createdby">Input parameter of stored procedure. </param>
    ''' <param name="transactionToUse">the transaction to use, or null if no transaction is available.</param>
    ''' <returns>Filled DataTable with resultset of stored procedure</returns>
    Public Overloads Shared Function App_Mac_Gerpubpurchases(date As System.DateTime, ref As System.String, createdby As System.String, transactionToUse As ITransaction) As DataTable
        Using spCall As StoredProcedureCall = CreateApp_Mac_GerpubpurchasesCall(New DataAccessCoreImpl(New CommonDaoBase(), transactionToUse), date, ref, createdby)
            Dim toReturn As DataTable = spCall.FillDataTable()
            Return toReturn
        End Using
    End Function

    ''' <summary>Creates an IRetrievalQuery Object For a Call To the procedure 'app_mac_gerpubpurchases'.
    ''' </summary>
    ''' <param name="date">Input parameter of stored procedure</param>
    ''' <param name="ref">Input parameter of stored procedure</param>
    ''' <param name="createdby">Input parameter of stored procedure</param>
    ''' <returns>IRetrievalQuery Object which Is ready To use For datafetching</returns>
    Public Shared Function GetApp_Mac_GerpubpurchasesCallAsQuery( date As System.DateTime, ref As System.String, createdby As System.String) As IRetrievalQuery 
        Return CreateApp_Mac_GerpubpurchasesCall(New DataAccessCoreImpl(New CommonDaoBase(), Nothing), date, ref, createdby).ToRetrievalQuery()
    End Function

    ''' <summary>Creates the Call Object For the Call 'App_Mac_Gerpubpurchases' to stored procedure 'app_mac_gerpubpurchases'.</summary>
    ''' <param name="dataAccessProvider">The data access provider.</param>
    ''' <param name="date">Input parameter</param>
    ''' <param name="ref">Input parameter</param>
    ''' <param name="createdby">Input parameter</param>
    ''' <returns>Ready To use StoredProcedureCall Object</returns>
    Private Shared Function CreateApp_Mac_GerpubpurchasesCall(dataAccessProvider As IDataAccessCore, date As System.DateTime, ref As System.String, createdby As System.String) As StoredProcedureCall
        Return New StoredProcedureCall(dataAccessProvider, "[Accounting].[dbo].[app_mac_gerpubpurchases]", "App_Mac_Gerpubpurchases") _ 
                        .AddParameter("@date", "SmallDateTime", 0, ParameterDirection.Input, True, 0, 0, date) _ 
                        .AddParameter("@ref", "Char", 8, ParameterDirection.Input, True, 0, 0, ref) _ 
                        .AddParameter("@createdby", "VarChar", 10, ParameterDirection.Input, True, 0, 0, createdby)
    End Function

Region "Included Code"

End Region

End Class

End Namespace

If I replace "date" with "[date]" works fine....is there a way to add the square brackets in the code generation process?

EDIT - Found solution in designer, edit SP parameter and change name.