public mmBindingList<SUBSTANCEEntity> GetSubsBySubGroupFK(int? groupID) { mmBindingList<SUBSTANCEEntity> SubsList; if (groupID != null) { SubsList = this.GetEntityList("SUBSTANCESelectBySubGroupFK"); this.CreateParameter("@GROUP_ID", groupID); } else { this.GetEmptyDataSet(); SubsList = new mmBindingList<SUBSTANCEEntity>(); } return SubsList; //return null; }And here is the stored procedure:
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[SUBSTANCESelectBySubGroupFK] ( @GROUP_ID int ) AS SET NOCOUNT ON; SELECT [COMPANY_ID], [CRE_DATE], [CRE_USER], [GROUP_ID], [MOD_DATE], [MOD_USER], [SUBSTANCE], [SUBSTANCE_ID] FROM [dbo].[SUBSTANCE] WHERE ([GROUP_ID] = @GROUP_ID)Am I missing something? It works just fine with anothere entity/stored procedure, which is pretty similar to that. The parameter is not empty, but somehow it does not get passed on to the stored procedure.