Entity Framework4.1调用存储过程示例

Create PROCEDURE [dbo].[Do]
	@a int,
	@b int
AS
BEGIN
	select @a + @b  --不能用return
END

public int Do(int a, int b)
{
    SqlParameter[] parameters = new SqlParameter[]{
		new SqlParameter("@a", SqlDbType.Int),
		new SqlParameter("@b", SqlDbType.Int)
	};
    parameters[0].Value = a;
    parameters[1].Value = b;

    //Database是testContext对象属性，从DbContext继承而来
    return Database.SqlQuery<int>("exec Do @a,@b", parameters).FirstOrDefault();
}

testContext context = new testContext();
int result = context.Do(7, 8);
Console.WriteLine(result);

Create PROCEDURE [dbo].[Do]
    @a int,
    @b int
AS
BEGIN
    select @a as f1, @b as f2 --必须有f1,f2
    union all
    select 10 as f1,20 as f2
END

public List<TestClass> Do(int a, int b)
{
	SqlParameter[] parameters = new SqlParameter[]{
		new SqlParameter("@a", SqlDbType.Int),
		new SqlParameter("@b", SqlDbType.Int)
	};
	parameters[0].Value = a;
	parameters[1].Value = b;

	return Database.SqlQuery<TestClass>("exec Do @a,@b", parameters).ToList();
}

public class TestClass
{
	public int f1 { get; set; }
	public int f2 { get; set; }
}

testContext context = new testContext();
List<TestClass> test = context.Do(7, 8);
foreach (TestClass item in test)
    Console.WriteLine("{0},{1}", item.f1, item.f2);