public SqlConnection OpenConnection(ISQLConnectionCredentials ConnectionCredentials)
{
SqlConnection SqlConnection = new SqlConnection(ConnectionCredentials.ToString( ));
_OpenSQLConnection(SqlConnection);
return(SqlConnection);
}
private dynamic _GetSchema(ISQLConnectionCredentials _ConnectionCredentials, Enum _SchemaType, ISchemaRestrictions _SchemaRestrictions)
{
using (SqlConnection _SqlConnection = new SqlConnection(_ConnectionCredentials.ToString( )))
{
_OpenSQLConnection(_SqlConnection);
//System.Diagnostics.Debug.WriteLine( $"{_SchemaType?.GetDescription( )} _ { String.Join(", ", _SchemaRestrictions?.ToArray( ) ) }" );
return((_SchemaRestrictions == null) ? _SqlConnection.GetSchema(_SchemaType.GetDescription( ))
: _SqlConnection.GetSchema(_SchemaType.GetDescription( ), _SchemaRestrictions.ToArray( )));
}
}
public SqlConnection CreateConnection(ISQLConnectionCredentials ConnectionCredentials)
{
return(new SqlConnection(ConnectionCredentials.ToString( )));
}