Entity frame work

Eswar Datta

I created stored procedure for retrieve data by Id in sql server

Now goto visual studio create project and take web-aplication in that added ADO.NET EntityModel.

And i try to call that SP but i don't know how do it.

but its not retieving any data.

8 Replies

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

Eswar Datta8y ago
Column names cannot get intellisense
Jenith Thakkar8y ago
Okay show me that error
Eswar Datta8y ago
Yes i'm getting. But i try below code, its shows compile time error.

void Edit()
{
str = Convert.ToInt16(Request.QueryString["id"]);
var dbb = db.Edit_Hwdb(assetID: str);
TextBox1.Text = dbb.AssetName;
TextBox2.Text = dbb.Manufacturer;
TextBox3.Text = dbb.Model;
}
Jenith Thakkar8y ago
When you scaffold Entity Framework from Stored Procedure that time if that Procedure is for select then it will create result kind of class which is 'Edit_Hwdb_Result' so when you do this
var dbb=db.Edit_Hwdb(assetID: str);
then by default dbb is define as 'Edit_Hwdb_Result'

are you getting my point?
Eswar Datta8y ago
Edit_Hwdb is a procedure name, not a table name/model name
Jenith Thakkar8y ago
db.Edit_Hwdb(assetID: str); will also return an one model please check that
Eswar Datta8y ago
With out Initializing model how can i call the Column names
Jenith Thakkar8y ago
Why are you initialise model again
just do it like this way

void Edit()
{
str = Convert.ToInt16(Request.QueryString["id"]);
var dbb = db.Edit_Hwdb(assetID: str);
TextBox1.Text = dbb.AssetName;
TextBox2.Text = dbb.Manufacturer;
TextBox3.Text = dbb.Model;
}