Unable to find .net framework data provider in WFR Designer

Getting error Unable to find requested .net framework data provider in WFR Designer

When selecting use database check box under setting in designer getting error "Unable to find requested .net framework data provider in WFR Designer".

Resolution:

            First you should check if .net framework is installed or not.

Even if it is installed, you may also get this error because somehow the "machine.config file" for .net was not updated properly. So you should update it as below.

1. Goto "C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG"

2. Open "machine.config" file present under this folder and make sure you have required rights to edit this file.

3. Find "DbProviderFactories" tag which is under "system.data" tag.

4. Add below line under "DbProviderFactories" tag and but make sure not to delete existing data which is already present.

<system.data>

    <DbProviderFactories>

            <!-- You have to add below line in existing <DbProviderFactories> tag -->

            <add name="EF Oracle Data Provider" invariant="EFOracleProvider" description="EF Provider for Oracle testing"                type="EFOracleProvider.EFOracleProviderFactory, EFOracleProvider, Version=1.0.0.0, Culture=neutral,                PublicKeyToken=def642f226e0e59b"/>    

     </DbProviderFactories>

  </system.data>

5. Save changes.

6. Reopen WFR designer.