private IReadOnlyList <object> Load(Type type, string sql, params object[] values)
{
List <object> entities = new List <object>();
using (var sqlConnection = GetConnection())
{
using (var sqlCommand = new DbSqlCommand(sql))
{
sqlCommand.Connection = sqlConnection.SqlConnection;
QueryHelpers.AddSqlParameters(sqlCommand, values);
sqlConnection.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader(CommandBehavior.SequentialAccess))
{
var fillVisitor = new FillVisitor(
reader: reader,
db: this,
objectFillerFactory: new ObjectFillerFactory());
while (fillVisitor.Read())
{
object entity = QueryHelpers.Fill(type, entity: null, fillVisitor: fillVisitor);
entities.Add(entity);
}
}
}
}
var entitiesToReturn = new List <object>(entities.Count);
var configuration = GlobalDbConfiguration.GetConfigurationOrEmpty(type);
var entityFilter = configuration.EntityFilter;
var queryLogger = GlobalDbConfiguration.QueryLogger;
foreach (object entity in entities)
{
queryLogger.IncrementLoadedElementCount(increment: 1);
if (entityFilter.DoReturnEntity(Settings, entity))
{
entitiesToReturn.Add(entity);
}
}
OnEntitiesLoaded(entitiesToReturn
.Where(e => e is DbEntity)
.Select(e => e as DbEntity)
.ToList());
return(entitiesToReturn);
}
private bool InitConnection()
{
if (sqlConnection == null)
{
sqlConnection = new SqlConnection(db.Settings.ConnectionString);
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
sqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.SequentialAccess);
return(true);
}
return(false);
}
