关于ASP.NET MVC开发设计中出现的问题与解决方案汇总 【持续更新】

public static class DataContextExtensions
{
    public static List<T> ExecuteQuery<T>(this DataContext dataContext, IQueryable query)
    {
        DbCommand command = dataContext.GetCommand(query);
        dataContext.OpenConnection();
 
        using (DbDataReader reader = command.ExecuteReader())
        {
            return dataContext.Translate<T>(reader).ToList();
        }
    }
 
    private static void OpenConnection(this DataContext dataContext)
    {
        if (dataContext.Connection.State == ConnectionState.Closed)
        {
            dataContext.Connection.Open();
        }
    }
}

var query=dbDataContext.TableName.Select();
var modelList=dbDataContext.ExecuteQuery<数据表映射实体类>(query);

ModelState.AddModelError(“字段名1”，“错误信息1”);
ModelState.AddModelError(“字段名9”，“错误信息2”);
ModelState.AddModelError(“字段名6”，“错误信息3”);
ModelState.AddModelError(“字段名3”，“错误信息4”);
ModelState.AddModelError(“字段名5”，“错误信息5”);

错误信息1
错误信息4
错误信息5
错误信息3
错误信息9

ModelState.AddModelError(“”，“错误信息1”);
ModelState.AddModelError(“”，“错误信息2”);
ModelState.AddModelError(“”，“错误信息3”);
ModelState.AddModelError(“”，“错误信息4”);
ModelState.AddModelError(“”，“错误信息5”);

Controller中：

var result= dbDataContext.TableName.Select(s=>Tuple.Create(参数赋值));

View中使用：
@model IEnumerable<dynamic>

            foreach (var item in Model)
            {
            <tr>
                <td>@item.Item1</td>
                <td>@item.Item2</td>
                <td>@item.Item3</td>
                <td>@item.Item4</td>
                <td>@item.Item5</td>
            </tr> 
            }

Controller中：

public ActionResult UsingExpando()  
{  
    dynamic viewModel = new ExpandoObject();  
    viewModel.TestString = "This is a test string";  
   
    return View(viewModel);  
}  

View中使用：

<p> @Model.TestString </p>

T_SysUser user = asotsDb.T_SysUser.Where(u => u.userid == model.userid).SingleOrDefault();
UpdateModel(user);

        [HttpPost]
        public ActionResult Test(FormCollection form)
        {
             string[] userRoles = form.GetValues("params[]");//这里就可以直接获取AJAX POST过来的数组
            
            return View();
        }

[HttpPost]
public ActionResult Test(FormCollection form)
{
    var models=form.GetValues("params[]").Select(p=>p.Single<Model>()).ToArray();
}

    public class JQAjaxModelBinder : DefaultModelBinder
    {

        public override object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
        {
            if (bindingContext.ModelType.IsArray) //判断是否为数组
            {
                var key = bindingContext.ModelName + "[]";
                var valueResult = bindingContext.ValueProvider.GetValue(key);
                if (valueResult != null && !string.IsNullOrEmpty(valueResult.AttemptedValue))
                {
                    bindingContext.ModelName = key;
                }
            }
            return base.BindModel(controllerContext, bindingContext);
        }
    }

        [HttpPost]
        public ActionResult Test([ModelBinder(typeof(JQAjaxModelBinder))] Model[] models)
        {
             Model model=models[0]; //这里举例获取数组中某个对象
             model.name="zuowenjun";
             model.sex=1;
             model.url="www.zuowenjun.cn";
            return View();
        }