Getting value -1 when we are calling stored procdre with EF

Dilshad Ashraf

7y1.1kLearn iOS Programming

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

)

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dilshad Ashraf7y ago
Thank you further response.

When I am not passing any parameter in stored procedure and in code,its also returning -1(minus one) value.

var data = db.Database.ExecuteSqlCommand("exec uspGetCategory");//Getting -1
return Json(data, JsonRequestBehavior.AllowGet);

Thanks & Regards
Dilshad Ashraf

0
Priyanka Jain7y ago
Have you checked value that you are passing in your stored procedure as you have specified And operator if all your passed values satisfied by query than only it will return result else you need to specify query as below
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 IS NULL OR SiteId = @SiteId)
                    AND (@IsDeleted IS NULL OR IsDeleted = @IsDeleted)
                    AND (@IsPublished IS NULL OR IsPublished = @IsPublished)
                    AND ParentCategoryId IS NULL
END
+1