The data reader is incompatible with the specified 'markfinmodel.mfreturndetail'. A member of the type, 'SLNO', does not have a corresponding column in the data reader with the same name.

See more:

ASP.NET

SQL

SQL-Server

error at:
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<mfreturndetail>("ADDMFRETURNDETAILS", mergeOption, sLNOParameter, rTNIDParameter, cOMMODITYIDParameter, cRDATEParameter, mARKETYARDIDParameter, nETVALUEParameter, qTYParameter, vALUEParameter, eXEMPTEDParameter, mFAMTParameter);

What I have tried:

model1.context.cs
__________________

public virtual ObjectResult<mfreturndetail> ADDMFRETURNDETAILS(Nullable<long> sLNO, Nullable<long> rTNID, Nullable<int> cOMMODITYID, Nullable<system.datetime> cRDATE, Nullable<int> mARKETYARDID, Nullable<decimal> nETVALUE, Nullable<decimal> qTY, Nullable<decimal> vALUE, Nullable<decimal> eXEMPTED, Nullable<decimal> mFAMT, MergeOption mergeOption)
{
var sLNOParameter = sLNO.HasValue ?
new ObjectParameter("SLNO", sLNO) :
new ObjectParameter("SLNO", typeof(long));

var rTNIDParameter = rTNID.HasValue ?
new ObjectParameter("RTNID", rTNID) :
new ObjectParameter("RTNID", typeof(long));

var cOMMODITYIDParameter = cOMMODITYID.HasValue ?
new ObjectParameter("COMMODITYID", cOMMODITYID) :
new ObjectParameter("COMMODITYID", typeof(int));

var cRDATEParameter = cRDATE.HasValue ?
new ObjectParameter("CRDATE", cRDATE) :
new ObjectParameter("CRDATE", typeof(System.DateTime));

var mARKETYARDIDParameter = mARKETYARDID.HasValue ?
new ObjectParameter("MARKETYARDID", mARKETYARDID) :
new ObjectParameter("MARKETYARDID", typeof(int));

var nETVALUEParameter = nETVALUE.HasValue ?
new ObjectParameter("NETVALUE", nETVALUE) :
new ObjectParameter("NETVALUE", typeof(decimal));

var qTYParameter = qTY.HasValue ?
new ObjectParameter("QTY", qTY) :
new ObjectParameter("QTY", typeof(decimal));

var vALUEParameter = vALUE.HasValue ?
new ObjectParameter("VALUE", vALUE) :
new ObjectParameter("VALUE", typeof(decimal));

var eXEMPTEDParameter = eXEMPTED.HasValue ?
new ObjectParameter("EXEMPTED", eXEMPTED) :
new ObjectParameter("EXEMPTED", typeof(decimal));

var mFAMTParameter = mFAMT.HasValue ?
new ObjectParameter("MFAMT", mFAMT) :
new ObjectParameter("MFAMT", typeof(decimal));

return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<mfreturndetail>("ADDMFRETURNDETAILS", mergeOption, sLNOParameter, rTNIDParameter, cOMMODITYIDParameter, cRDATEParameter, mARKETYARDIDParameter, nETVALUEParameter, qTYParameter, vALUEParameter, eXEMPTEDParameter, mFAMTParameter);
}

stored procedure:
___________________

alter PROCEDURE [dbo].[ADDMFRETURNDETAILS]
( @SLNO bigint,
@RTNID BIGINT,
@COMMODITYID INT ,
@CRDATE DATETIME,
@MARKETYARDID INT,
@NETVALUE NUMERIC(18,2),
@QTY NUMERIC(18,2),

@VALUE NUMERIC(18,2),
@EXEMPTED NUMERIC(18,2),
@MFAMT NUMERIC(18,2)



)
AS
SET IDENTITY_INSERT MFReturnDetails ON
DECLARE @CMDTNAME VARCHAR(50)
IF (@RTNID=0)
BEGIN
SET @MARKETYARDID=(SELECT ISNULL(MAX(MARKETYARDID),0)+1 FROM MFReturnDetails)
--SET @COMMODITYID=(SELECT CMDTID FROM Commodity WHERE CMDTNAME=@CMDTNAME)
SET @RTNID=(SELECT ISNULL(MAX(RTNID),0)+1 FROM MFReturnDetails)

INSERT INTO [dbo].[MFReturnDetails]
( SLNO ,
RTNID ,
COMMODITYID ,
CRDATE ,
MARKETYARDID ,
NETVALUE ,
QTY ,

VALUE ,
EXEMPTED ,
MFAMT)
VALUES
( @SLNO ,
@RTNID ,
@COMMODITYID ,
@CRDATE ,
@MARKETYARDID ,
@NETVALUE ,
@QTY ,

@VALUE ,
@EXEMPTED ,
@MFAMT )

IF @@ROWCOUNT>0
SELECT @SLNO
END
___________________