As you can see, the SP has insert and update scenarios. Both the scenarios work fine if I execute in manually from SQL Server management studio.

Thanks,

Mavericky

Also, it gives me the same error if I execute in this manner:

Database.ReadResultSet(appConnection, sqlEntityEntry);

where sqlEntityEntry = string.Format("exec usp_{0}_InsUpdEntity @ID={1}, @Name='{2}', @ShortName='{3}', @Comments='{4}'",AppDbPrefix, entityEntry.ID, entityEntry.Name.Replace(@"'", @"''"), entityEntry.ShortName.Replace(@"'", @"''"), entityEntry.Comments.Replace(@"'", @"''"));

Here is the stored proc being called:

ALTER PROCEDURE [dbo].[usp_APPL_InsUpdEntity]

@ID INT=0, @Name VARCHAR (100)='', @ShortName VARCHAR (20)='', @Comments TEXT=''

AS

DECLARE @RID AS INT

-- =============================================

-- Description: Inserts/Updates Entity...