How to call stored procedure in EF ADO.NET with DB Firsrt

Hi.

The return type of ExecuteSqlCommand is int as per this article (https://docs.microsoft.com/en-us/dotnet/api/system.data.entity.database.executesqlcommand?view=entity-framework-6.2.0). So it will return always int only.

It is not possible to return list data by using  ExecuteSqlCommand.

But if you want to call stored procedure using EF then follow below articles.

 

Thanks. 

Thank you for futher response.

 

Getting -1 value.

 

Code:

 

public JsonResult BidCategory(tblCategory objTblCategory)

{

SqlParameter companyid = new SqlParameter("@CompanyId",objTblCategory.CompanyId);

SqlParameter siteid = new SqlParameter("@SiteId",objTblCategory.SiteId);

SqlParameter isdeleted = new SqlParameter("@IsDeleted",objTblCategory.IsDeleted);

SqlParameter ispublished = new SqlParameter("@IsPublished",objTblCategory.IsPublished);

db = new ProductDBEntities();

var data = db.Database.ExecuteSqlCommand("uspGeCategory @CompanyId,@SiteId,@IsDeleted,@IsPublished",

companyid, siteid, isdeleted, ispublished);

return Json(data, JsonRequestBehavior.AllowGet);

}

 

Getting -1(minus one) value.

Hi Dilshad, 

 

Watch this vedio

 

https://www.youtube.com/watch?v=UpnJAMCryKE 

 

In this article explained how to call stored procedue using Entity Framework ADO.NET with Data First Approach in ASP.NET MVC.

 

https://www.c-sharpcorner.com/article/entity-framework-6-0-0-using-stored-procedure-in-asp-net-mvc/ 

 

https://www.aspsnippets.com/Articles/ASPNet-MVC-Entity-Framework-Database-First-Approach-example.aspx

 

Thanks 

Hey.

Probably you can follow these articles,

 

https://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx

 

https://www.entityframeworktutorial.net/EntityFramework4.3/execute-stored-procedure-using-dbcontext.aspx

 

https://www.entityframeworktutorial.net/EntityFramework5/CRUD-using-stored-procedures.aspx

 

https://www.youtube.com/watch?v=VFFM9o8fWPc

 

Thanks.