使用Linq如何从存储过程获取数据到数据集

问题描述:

使用Linq,我需要检索数据集的值..



正常查询,



i已经尝试过这样的正常选择语句,





using Linq, i need to retrieve value to dataset..

for normal query,

i have tried like this for normal select statement,


DataClassesDataContext obj = new DataClassesDataContext();







public DataSet display()
   {
       var temp = from value in obj.employees
                  select value;
       SqlCommand cmd = (SqlCommand)obj.GetCommand(temp);
       SqlDataAdapter da = new SqlDataAdapter(cmd);
       DataSet ds = new DataSet();
       da.Fill(ds);
       return ds;
   }







但对于存储过程..




But for stored procedure..

create procedure spdisplay
as
begin
select * from employee
end







public DataSet sp_display()
   {
       var temp = obj.spdisplay();

   }





如何将值反转到数据集。



how to retrive the values to dataset.