public SqlReflection(OracleConnectionProvider provider)
{
_provider = provider;
_schema = ConfigurationManager.AppSettings.AllKeys.Contains("Simple.Data.Oracle.Schema") ? ConfigurationManager.AppSettings["Simple.Data.Oracle.Schema"] : provider.UserOfConnection;
_buildData = new Task(BuildData);
_buildData.Start();
}
public OracleProcedureExecutor(OracleConnectionProvider connectionProvider, ObjectName procedureName)
{
_connectionProvider = connectionProvider;
_schema = DatabaseSchema.Get(_connectionProvider, new ProviderHelper());
_procedureName = procedureName;
_executeImpl = ExecuteReader;
}
public OracleProcedureExecutor(OracleConnectionProvider connectionProvider, ObjectName procedureName)
{
_connectionProvider = connectionProvider;
_schema = DatabaseSchema.Get(_connectionProvider, new ProviderHelper());
_procedureName = procedureName;
_executeImpl = ExecuteReader;
}
public SqlReflection(OracleConnectionProvider provider)
{
_provider = provider;
_schema = new ConfigurationProvider().ConnnectionSchemaOverride ?? provider.UserOfConnection;
_buildData = new Task(BuildData);
_buildData.Start();
}
public SqlReflection(OracleConnectionProvider provider)
{
_provider = provider;
_schema = new ConfigurationProvider().ConnnectionSchemaOverride ?? provider.UserOfConnection;
_buildData = new Task(BuildData);
_buildData.Start();
}
public SqlReflection(OracleConnectionProvider provider, ISchemaConfiguration schemaConfiguration)
{
_provider = provider;
_schema = schemaConfiguration.Schema;
_buildData = new Task(BuildData);
_buildData.Start();
}
public SqlReflection(OracleConnectionProvider provider)
{
_provider = provider;
_schema = ConfigurationManager.AppSettings.AllKeys.Contains("Simple.Data.Oracle.Schema") ? ConfigurationManager.AppSettings["Simple.Data.Oracle.Schema"] : provider.UserOfConnection;
_buildData = new Task(BuildData);
_buildData.Start();
}
public static IEnumerable <T> ReaderFrom <T>(this OracleConnectionProvider provider, string sqlText, Action <OracleCommand> modCommand, Func <IDataReader, T> select)
{
using (var cn = provider.CreateOracleConnection())
{
var command = cn.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sqlText;
modCommand(command);
cn.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
yield return(select(reader));
}
}
}
}
public OracleSchemaProvider(OracleConnectionProvider connectionProvider)
{
_sqlReflection = new SqlReflection(connectionProvider);
}
public SqlReflection(OracleConnectionProvider provider)
{
_provider = provider;
_buildData = new Task(BuildData);
_buildData.Start();
}
public OracleSchemaProvider(OracleConnectionProvider connectionProvider)
{
_sqlReflection = new SqlReflection(connectionProvider);
}
public static IEnumerable <T> ReaderFrom <T>(this OracleConnectionProvider provider, string sqlText, Func <IDataReader, T> select)
{
return(provider.ReaderFrom(sqlText, _ => { }, select));
}
public DefaultSchemaConfiguration(OracleConnectionProvider provider)
{
_provider = provider;
}
public OracleSchemaProvider(OracleConnectionProvider connectionProvider, ISchemaConfiguration schemaConfiguration)
{
_sqlReflection = new SqlReflection(connectionProvider, schemaConfiguration);
}