//存储过程
create Proc GetUserAccountRe
@ClassId int,
@StuName varchar(20) output with encryption   //输出参数
as
  if(@ClassId is not null and @StuName is null)
    select * from StuClasss join Student on StuClasss.classId=Student.classId where StuClasss.classId=@ClassId
  else if(@ClassId is null and @StuName is not null)
    select * from StuClasss join Student on StuClasss.classId=Student.classId where Student.names=@StuName
  else if(@ClassId is not null and @StuName is not null)
    select * from StuClasss join Student on StuClasss.classId=Student.classId where StuClasss.classId=@ClassId and Student.names=@StuName
  else
    select * from StuClasss join Student on StuClasss.classId=Student.classId

GO





//调用方式
 public List<GetUserAccountRe_Result> SelStuInfo(Expression<Func<T, bool>> wherelambda)
        {
          
            //这里调用的存储过程 接收了一个结果集 但是还有一个返回参数怎么接收了？？
            var list=DBContext.GetUserAccountRe(1, "三").ToList();
            return list;
        }