OpenDNS on Linksys Routers SmartWIFI, How to make it just WORK!

If you have a SmartWIFI router version like me , then you most likely are not able to use OpenDNS the nice and easy way as shown here from OpenDNS: Configuration for Linksys Cisco AC175, EA6300, EA6500, ..... 

Well guess what these directions don't tell you HOW to fix the KNOWN issue (or the as designed feature that breaks OpenDNS) with Linksys SmartWifi and OpenDNS not working together. Instead the article just states: "If the OpenDNSn addresses are not displaying here, the solution at this time is to roll back the firmware..." Well that is a flash in the pan hail mary to solve this issue, because barely anyone has gotten success from rolling back the firmware! 

 Well I wasn't about to rollback without a fight, so I looked around theses forums and found that many people also cant get OpenDNS to work with SmartWifi EA* routers,  people tried everything from firmware, varying DNS entries, StaticIP assignments, ect ect. Of course most forum posts were little on detail and damn near none had screenshots.  Both the Linksys and OpenDNS communities lack a consistent documented work-around anywhere, just message board blurbs, and that is what I had to start with, from these I found a solution:

Some of the message board links describing the SmartWIFI LinkSys routers/DNS issues:
EA6350 DHCP/DNS Issues
OpenDNS Testing

So using these message board blurbs (and many more) from various sources and around 4 hours of my life I finally got a solution so I can use my EA6350 LinkSys Router to work with OpenDNS!!!

PreReq: My firmware version is: 1.0.4.164719
1. Set IPv4 connection
2. Set Local Network DNS's
3. Disable IPv6

Related Links

1. OpenDNS FamilyShield
Preferred DNS Server: 208.67.222.123
Alternate DNS Server: 208.67.220.123

2. BrightHouse DNS Servers

Local DB from SQL Server Command Line Create with EF Conn Strings

Command
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\windows\system32>SqlLocalDb info
Projects
v11.0

C:\windows\system32>SqlLocalDb create "MyInstance"
LocalDB instance "MyInstance" created with version 11.0.

C:\windows\system32>SqlLocalDb start "MyInstance"
LocalDB instance "MyInstance" started.

C:\windows\system32>SqlLocalDb info "MyInstance"
Name:               MyInstance
Version:            11.0.2100.60
Shared name:
Owner:              DoyleJWin7\DoyleJ
Auto-create:        No
State:              Running
Last start time:    2/18/2016 2:57:13 AM
Instance pipe name: np:\\.\pipe\LOCALDB#DCDDFF50\tsql\query

C:\windows\system32>

Attach

<add name="NORTHWNDConnectionString" connectionString="Data Source=(LocalDb)\MyInstance;Initial Catalog=NorthWind;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True"
   providerName="System.Data.SqlClient" />

Use:

<connectionStrings>
  <add name="constring" connectionString="Data Source=(LocalDb)\MyInstance;Initial Catalog=NorthWind;integrated security=true"/>
</connectionStrings>

Disable Visual Studio Auto Update of HTML / MarkUp on Paste with Pesky Tags/Attributes

Here's how to stop the MarkUP and JS Updating by VS.Net on paste of source into IDE:

  MarkUP

1.  Go to the menu bar and click on 'Tools' and then 'Options'. 
2.  On the popup screen than appears there is a little checkbox in the lower left corner that says 'Show All Settings'. Make sure that is selected. 
3.  Expand the 'TextEditor' option and expand the 'HTML' option. 
4.  Click on 'Miscellaneous' and untick the option 'Auto ID elements on paste in Source view'.
5.  Click on 'Formatting' and untick the option 'Format on Paste'.
6.  Click OK and now when you paste any html content or code with the same ID values as what is in your project Visual Studio will not rename the IDs. 

JScript

1.  Go to the menu bar and click on 'Tools' and then 'Options'. 
2.  On the popup screen than appears there is a little checkbox in the lower left corner that says 'Show All Settings'. Make sure that is selected.
3.  Expand the 'TextEditor' option and expand the 'JScript' option. 
4.  Click on 'Formatting' and untick the option 'Format on Paste'. 
5.  Click OK and now when you paste any html content or code with the same ID values as what is in your project Visual Studio will not rename the IDs.