run sp with ef

runsp.cs

private DataSet GetDataSetBySp(string inName, SqlParameter[] inParams)
{
    using (var IPPDB = new IPPEntities())
    {
        using (var spCmd = new SqlCommand())
        {
            DataSet ds = null;

            IPPDB.Database.Connection.Open();
            spCmd.Connection = (SqlConnection)(IPPDB.Database.Connection);
            spCmd.CommandText = inName;
            spCmd.CommandType = CommandType.StoredProcedure;
            spCmd.CommandTimeout = 0;
            if (inParams != null)
            {
                spCmd.Parameters.AddRange(inParams);
            }
            var da = new SqlDataAdapter(spCmd);
            ds = new DataSet();
            da.Fill(ds);

            return ds;
        }
    }
}

protected void ExecNonQuerySp(string inName, SqlParameter[] inParms)
{
    using (var IPPDB = new IPPEntities())
    {
        IPPDB.Database.Connection.Open();
        DbCommand cmd = IPPDB.Database.Connection.CreateCommand();
        cmd.CommandText = inName;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandTimeout = 0;
        cmd.Parameters.AddRange(inParms);
        cmd.ExecuteNonQuery();
    }
}

protected int ExecNonQuerySpWithResult(string inName, SqlParameter[] inParms)
{
    using (var IPPDB = new IPPEntities())
    {
        IPPDB.Database.Connection.Open();
        DbCommand cmd = IPPDB.Database.Connection.CreateCommand();
        cmd.CommandText = inName;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandTimeout = 0;
        cmd.Parameters.AddRange(inParms);
        cmd.ExecuteNonQuery();

        var ret = Convert.ToInt32(cmd.Parameters["@Result"].Value);
        return ret;
    }
}