PublicIenumerable<statistic> Getstatistics (ienumerable<guid>itemids) { varCTX =NewDBContext (); returnCTx. Database.sqlquery<statistic> ("[dbo]. [Itemstatisticsselect] @Items, @IsPostModeration", NewSqlParameter ("Items",string. Join ("|", Itemids)),NewSqlParameter ("ispostmoderation",true)); }
/// <summary> ///execute the original SQL command/// </summary> /// <param name= "CommandText" >SQL command</param> /// <param name= "Parameters" >Parameters</param> /// <returns>number of records affected</returns> PublicObject[] Executesqlnonquery<t> (stringCommandText,paramsobject[] Parameters) { using(DBEntities context =Newdbentities ()) { varResults = context. Database.sqlquery<t>(commandtext, parameters); Results. Single (); returnparameters; } }
1) EF can execute stored procedures
2) EF can return non-DB entities
Goto: Entity framework executes stored procedures and returns parameters using Database.sqlquery<t>