C# DataTableをモデルクラスへ代入

直接カラム名を書いてしまうことが多いけど、リフレクションで作ってみる。

        public List<DataGridViewModel> CreateModel(Query query)
        {
            var temp = new BaseDbLoadEvent().CreateModel(query, new DataGridViewModel());
            return temp.ConvertAll(x => (DataGridViewModel)x);
        }

public List<DataGridViewModel> CreateModel(Query query)

{

var temp = new BaseDbLoadEvent().CreateModel(query, new DataGridViewModel());

return temp.ConvertAll(x => (DataGridViewModel)x);

}

    public class BaseDbLoadEvent
    {
        public List<IDataGridViewModel> CreateModel(Query query, IDataGridViewModel targetModel)
        {
            var modelType = targetModel.GetType();
            var models = new List<IDataGridViewModel>();
            List<string> propNameList = new List<string>(modelType.GetProperties().Select(x => x.Name));
            var dt = query.ExecuteQuery();

            for (int r = 0; r < dt.Rows.Count; r++)
            {
                var ci = modelType.GetConstructor(System.Type.EmptyTypes);
                var model = (IDataGridViewModel)ci.Invoke(null);
                // あるいは
                //var model = (IDataGridViewModel)Activator.CreateInstance(targetModel.GetType());

                foreach (var propName in propNameList)
                {
                    var columnName = propName;
                    var fi = modelType.GetProperty(propName);
                    fi.SetValue(model, dt.Rows[r][columnName]);
                }
                models.Add(model);
            }
            return models;
        }
    }

public class BaseDbLoadEvent

{

public List<IDataGridViewModel> CreateModel(Query query, IDataGridViewModel targetModel)

{

var modelType = targetModel.GetType();

var models = new List<IDataGridViewModel>();

List<string> propNameList = new List<string>(modelType.GetProperties().Select(x => x.Name));

var dt = query.ExecuteQuery();

for (int r = 0; r < dt.Rows.Count; r++)

{

var ci = modelType.GetConstructor(System.Type.EmptyTypes);

var model = (IDataGridViewModel)ci.Invoke(null);

// あるいは

//var model = (IDataGridViewModel)Activator.CreateInstance(targetModel.GetType());

foreach (var propName in propNameList)

{

var columnName = propName;

var fi = modelType.GetProperty(propName);

fi.SetValue(model, dt.Rows[r][columnName]);

}

models.Add(model);

}

return models;

}

投稿(更新順)