Configuring A Specific Data Provider
Invariant Name: System.Data.SqlClient

SQL Statement: SELECT Description FROM SpecialOffer WHERE DiscountPct > @discount

Products on sale with discount greater than 25.00 %:
- Mountain-100 Clearance Sale
- Road-650 Overstock
- Mountain Tire Sale
- LL Road Frame Sale
- Half-Price Pedal Sale
- Mountain-500 Silver Clearance Sale
- Mountain-100 Clearance Sale
- Road-650 Overstock
- Mountain Tire Sale
- LL Road Frame Sale
- Half-Price Pedal Sale
- Mountain-500 Silver Clearance Sale

web.config contains:

<configuration>
  <appSettings>
    <add name="provider-type" value="System.Data.SqlClient" />
  </appSettings>
</configuration>
  ©2005 Dave And Al.net