how can we call SQL stored procedure in Entity framework 6.1.3? -
we tried add sp through model, after adding sp model, following code generated , getting build-in errors. aren't able build project. please find below code (context.cs file) reference. please us.
public virtual objectresult<usp_getappusers_result> usp_getappusers(string displayname, string username, string userpassword, nullable<int> orgbranchid, string activestatus) { var displaynameparameter = displayname != null ? new objectparameter("displayname", displayname) : new objectparameter("displayname", typeof(string)); var usernameparameter = username != null ? new objectparameter("username", username) : new objectparameter("username", typeof(string)); var userpasswordparameter = userpassword != null ? new objectparameter("userpassword", userpassword) : new objectparameter("userpassword", typeof(string)); var orgbranchidparameter = orgbranchid.hasvalue ? new objectparameter("orgbranchid", orgbranchid) : new objectparameter("orgbranchid", typeof(int)); var activestatusparameter = activestatus != null ? new objectparameter("activestatus", activestatus) : new objectparameter("activestatus", typeof(string)); return ((iobjectcontextadapter)this).objectcontext.executefunction<usp_getappusers_result>("usp_getappusers", displaynameparameter, usernameparameter, userpasswordparameter, orgbranchidparameter, activestatusparameter); }
Comments
Post a Comment