Entity Framework CTP5 - How to Call Stored Procedure?
You can execute database-wide sql statements like this
using(var context = new MyContext()){ // custum sql statement var c = context.Database.SqlQuery<int>("SELECT COUNT(*) FROM Employees"); // returned entity type doesn't have to be represented by ObjectSet/DBSet var e = context.Database.SqlQuery<Employee>("SELECT * FROM Employees"); // stored procedure var q = context.Database.SqlQuery<Employee>("GetEmployees");}