public IEnumerable <dynamic> InvokeGet(TModel model)
{
var parameters = BindingModelPropertyToParameter(
model,
_strategy.GetModelPropertyBindings(),
_strategy.GetDbParameters()).ToList();
try
{
_serviceProvider.Open();
var reader = _serviceProvider.RunStoredProcGetReader(_strategy.GetDbProcName(), parameters);
var items = new List <dynamic>();
var records = DbModelBindingHelper.GetDataRecords(reader);
foreach (var record in records)
{
dynamic item = new ExpandoObject();
var itemProps = (IDictionary <string, object>)item;
for (var i = 0; i < record.FieldCount; i++)
{
try
{
itemProps.Add(record.GetName(i).Trim(), reader.GetValue(i));
}
catch (IndexOutOfRangeException)
{
itemProps.Add(record.GetName(i).Trim(), DBNull.Value);
}
}
items.Add(item);
}
reader.Close();
return(items);
}
catch (Exception exception)
{
throw new DbOperationException(
"ERROR_SQL_PROCEDURE_EXECUTION_FAILED",
exception,
_strategy.GetDbProcName(),
parameters);
}
finally
{
_serviceProvider.Close();
}
}
public IEnumerator <TModel> GetEnumerator()
{
var queryStrategy = _queryStrategyProvider.GetSelectStrategy(
_queryTable.ModelStrategy, _skipCount, _takeCount, _whereClauses, _orderbyClauses);
var sql = queryStrategy.GetDbQueryScript();
var dbparams = queryStrategy.GetDbParameters();
IDataReader reader = null;
var items = new List <TModel>();
_serviceProvider.Open();
try
{
reader = _serviceProvider.QueryGetReader(sql, dbparams);
if (_skipCount == 0 && _takeCount == 0)
{
var records = DbModelBindingHelper.GetDataRecords(reader);
items.AddRange(
records.Select(record =>
DbModelBindingHelper.BindingRecordToModel <TModel>(
record, _queryTable.ModelStrategy.PropertyStrategies))
);
}
else
{
while (reader.Read())
{
items.Add(DbModelBindingHelper.BindingRecordToModel <TModel>(
reader,
_queryTable.ModelStrategy.PropertyStrategies));
}
}
}
catch (Exception exception)
{
throw new DbOperationException("ERROR_SQL_EXECUTION_FAILED", exception, sql, dbparams);
}
finally
{
reader?.Close();
_serviceProvider.Close();
}
return(items.GetEnumerator());
}
public IEnumerable <dynamic> ExecuteQuery(string sql, object queryParams = null)
{
var autoClose = !(_provider.IsConnectionOpen());
if (autoClose)
{
_provider.Open();
}
var dbParams = GetQueryDataParameters(queryParams);
var reader = _provider.QueryGetReader(sql, dbParams);
var records = DbModelBindingHelper.GetDataRecords(reader);
var result = FormatDataRecordToDynamicModel(records);
reader.Close();
if (autoClose)
{
_provider.Close();
}
return(result);
}