title: Use Excel import with entity framework while inseting records
body: <p>i am using nopcommerce 1.9 and in creating discount i have the following code </p>
  
  <pre><code>discount = new Discount()
              {
                  DiscountTypeId = (int)discountType,
                  DiscountRequirementId = (int)discountRequirement,
                  RequirementSpentAmount = requirementSpentAmount,
                  RequirementBillingCountryIs = requirementBillingCountryIs,
                  RequirementShippingCountryIs = requirementShippingCountryIs,
                  DiscountLimitationId = (int)discountLimitation,
                  LimitationTimes = limitationTimes,
                  Name = name,
                  UsePercentage = usePercentage,
                  DiscountPercentage = discountPercentage,
                  DiscountAmount = discountAmount,
                  StartDate = discountStartDate,
                  EndDate = discountEndDate,
                  RequiresCouponCode = requiresCouponCode,
                  CouponCode = couponCode
              };
              this.DiscountService.InsertDiscount(discount);
  </code></pre>
  
  <p>now my task is that in <code>'CouponCode = couponCode'</code> i have to replace this coupon code from excel sheet column which is uploaded by client when he save the discount.</p>
  
  <p>and this excel sheet can have 50000 coupon codes so each coupon have the same info of discount .</p>
  
  <p>in this solution we have entity framework. and we have to store the data in this format </p>
  
  <pre><code>D1   10%    C1(coupon code from excel sheet)
  D1   10%    C2(coupon code from excel sheet)
  D1   10%    C3(coupon code from excel sheet)
  D1   10%    C4(coupon code from excel sheet)
  D1   10%    C5(coupon code from excel sheet)
  D1   10%    C6(coupon code from excel sheet)
  D1   10%    C7(coupon code from excel sheet)
  </code></pre>