Hi All,
I am using first time Entity Framework with stored procedure for getting records based on parameters.
I am getting -1(minus one) value. I'm not getting the records.
Why value -1 is coming and why records are not coming.
Below are the code:
public JsonResult BidCategory(tblCategory objTblCategory)
{
db = new ProductDBEntities();
var companyid = new SqlParameter("@companyid", objTblCategory.CompanyId);
var siteid = new SqlParameter("@siteid", objTblCategory.SiteId);
var isdeleted = new SqlParameter("@isdeleted", objTblCategory.IsDeleted);
var ispublished = new SqlParameter("@ispublished", objTblCategory.IsPublished);
var data = db.Database.ExecuteSqlCommand("uspGetCategory @CompanyId,@SiteId,@IsDeleted,@IsPublished", companyid, siteid, isdeleted, ispublished);//Getting -1
return Json(data, JsonRequestBehavior.AllowGet);
}
Below are the stored procedure:
CREATE PROC uspGetCategory
(
@CompanyId INT,
@SiteId INT,
@IsDeleted BIT,
@IsPublished BIT
)
AS
BEGIN
SELECT CategoryId,
CategoryName
FROM tblCategory WITH(NOLOCK)
WHERE CompanyId = @CompanyId
AND SiteId = @SiteId
AND IsDeleted = @IsDeleted
AND IsPublished = @IsPublished
AND ParentCategoryId IS NULL
END
Please give me solution for above code.
Find the attachments screens and code
Thanks & Regards
Dilshad Ashraf