public ResultSet(SqlCommand command, System.Data.DataSet dataSet, IModelValueBinder modelValueBinder)
{
this.CommandText = command.CommandText;
_dataSet = dataSet;
_modelValueBinder = modelValueBinder;
for (int i = 0; i < command.Parameters.Count; i++)
{
var prm = command.Parameters[i];
_parameters.Add(prm.ParameterName, prm.Value);
}
ReturnValue = Convert.ToInt32(GetParameterValue(ReturnValueParameterName) ?? 0);
}
private TModel[] ToModel <TModel>(System.Data.DataTable table)
where TModel : class, new()
{
var models = new List <TModel>();
IModelValueBinder binder = _modelValueBinder ?? new DefaultModelValueBinder(typeof(TModel));
if (typeof(TModel) == typeof(System.Dynamic.ExpandoObject))
{
foreach (System.Data.DataRow row in table.Rows)
{
var model = new System.Dynamic.ExpandoObject();
foreach (System.Data.DataColumn col in table.Columns)
{
var val = row[col];
if (val != null && val.GetType() == typeof(DBNull))
{
val = null;
}
var dictionary = (IDictionary <string, object>)model;
dictionary.Add(col.ColumnName, val);
}
models.Add(model as TModel);
}
}
else
{
foreach (System.Data.DataRow row in table.Rows)
{
var model = new TModel();
foreach (System.Data.DataColumn col in table.Columns)
{
var val = row[col];
if (val != null && val.GetType() == typeof(DBNull))
{
val = null;
}
binder.SetValue(model, col.ColumnName, val);
}
models.Add(model);
}
}
return(models.ToArray());
}
public PBL(string connectionString, IModelValueBinder modelValueBinder)
: base(connectionString, modelValueBinder)
{
}
public Database(string connectionString, IModelValueBinder modelValueBinder)
{
_connectionString = connectionString;
_modelValueBinder = modelValueBinder;
}