Use stored procedure in EF(MVC4)

Question

I have a storedprocedure "SelectKP" (Datetime bt,Datetime et), please help to create a class and a repository for this procedure.

score 0 · Answer 1 · edited May 23 '17 at 12:04

0

There is not a function generated manually, but it executes stored procedure

edited May 23 '17 at 12:04

Community

answered May 28 '12 at 11:12

karaxuna

1

thanks for the answer, but I was a little mistake in the question, i need add function manual – He11b0rn May 28 '12 at 11:28
Sorry, I don't understand meaning of the word manual in this context – karaxuna May 28 '12 at 11:39
@He11b0rn, so you mean a user-defined function? – Gert Arnold May 28 '12 at 15:08

score 0 · Answer 2 · answered May 28 '12 at 12:16

0

Here is simple example.

using (var db = new ModelEntities())
{
  var query = db.ExecuteStoreQuery<ModelClass>("StoreProcedureName '" + UserId +"'");
}

answered May 28 '12 at 12:16

Imran Rashid

2 Answers2