I'm using entity framework in asp.net and now i want to call

Ajay Antala

Hi, I'm using entity framework in asp.net and now i want to call mysql stored-procedure,ok it's call but it return int valu(0-1),but i want to return list,that use to bind gridview. search in google but only suggestion import funcation and call it,but my requirement is call without use this function,how to solve this query,,any one expert can suggestion me, Thank you.

3 Replies

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

Ajay Antala8y ago
ok I'm
solved this

create an object that has the same property names as the results returned by the stored procedure.

public class city
{
public long CityId { get; set; }
public string CityName { get; set; }
public System.DateTime ModifyDate { get; set; }
}

storeprodemoEntities context = new storeprodemoEntities();
var result = context.Database.SqlQuery("sp_city").ToList();
GridView1.DataSource = result;
GridView1.DataBind();

Thanx For Help.
+1
Ketan Hirapara8y ago
hi ajay,

go to below link for reference,

http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-make-custom-login-register-and-logout-in-mvc-4-usin/
+1
Ramesh Palanivel8y ago
Hi Ajay,

If you are using entity framework, instead calling stored procedure you can use linq query to get the list.

Still if you want to get the list, you can write sql query in linq. please refer the below URL

http://www.c-sharpcorner.com/UploadFile/dhananjaycoder/executing-sql-query-using-linq-to-sql/
+1