The ado.net context is not able to properly read a connection string from the config file

[johelvisguzman]

The ado.net context assumes that the connection string passed in can be found in the app.config, however; this is not a how it should work.

This method is not working!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
This will return an invalid connection string settings in some cases. Needs to investigate...

private static ConnectionStringSettings GetConnectionStringSettings(string nameOrConnectionString)
{
    var css = ConfigurationManager.ConnectionStrings[nameOrConnectionString];

    if (css == null)
    {
        for (var i = 0; i < ConfigurationManager.ConnectionStrings.Count; i++)
        {
            css = ConfigurationManager.ConnectionStrings[i];

            if (css.ConnectionString.Equals(nameOrConnectionString))
                break;
        }
    }

    if (css == null)
        throw new ArgumentException("The connection string does not exist in your configuration file.");

    return css;
}

Maybe do this

private static ConnectionStringSettings GetConnectionStringSettings(string nameOrConnectionString)
{
    var css = ConfigurationManager.ConnectionStrings[nameOrConnectionString];

    if (css == null)
    {
        for (var i = 0; i < ConfigurationManager.ConnectionStrings.Count; i++)
        {
            css = ConfigurationManager.ConnectionStrings[i];

            if (css.ConnectionString.Equals(nameOrConnectionString))
                return css;
        }
    }

    return css;
}

public AdoNetRepositoryContext
{
...
    var css = GetConnectionStringSettings(nameOrConnectionString);
    var connectionString = css != null
         ? css.ConnectionString
         : nameOrConnectionString;
...
}