EF 执行带参数返回值的存储过程示例

public Booking_ProductCount GetProductCountByBookingNo(string BookingNo, string CompanyNo, string BookingID)
        {
            Booking_ProductCount bookCountInfo = new Booking_ProductCount();
            try
            {
                using (T2BookingEntities context = new T2BookingEntities())
                {
                    ObjectParameter para1 = new ObjectParameter("PassengerCount", typeof(int));
                    ObjectParameter para2 = new ObjectParameter("PackageCount", typeof(int));
                    ObjectParameter para3 = new ObjectParameter("AirTicketCount", typeof(int));
                    ObjectParameter para4 = new ObjectParameter("HotelCount", typeof(int));
                    ObjectParameter para5 = new ObjectParameter("MiscCount", typeof(int));
                    ObjectParameter para6 = new ObjectParameter("TransferCount", typeof(int));
                    ObjectParameter para7 = new ObjectParameter("TourCount", typeof(int));
                    ObjectParameter para8 = new ObjectParameter("TravelInsureCount", typeof(int));
                    context.GetBookingForm_PoductsCount(BookingNo, CompanyNo, BookingID, para1, para2, para3, para4, para5, para6, para7, para8);
                    bookCountInfo.PassengerCount = (int)para1.Value;
                    bookCountInfo.PackageCount = (int)para2.Value;
                    bookCountInfo.AirTicketCount = (int)para3.Value;
                    bookCountInfo.HotelCount = (int)para4.Value;
                    bookCountInfo.MiscCount = (int)para5.Value;
                    bookCountInfo.TransferCount = (int)para6.Value;
                    bookCountInfo.TourCount = (int)para7.Value;
                    bookCountInfo.TravelInsureCount = (int)para8.Value;
                }
            }
            catch (Exception e)
            {
            }

            return bookCountInfo;
        }