public static List <FieldProperty> ToTableModel(this SqlDataReader reader)
{
List <FieldProperty> result = new List <FieldProperty>();
if (reader == null || reader.IsClosed)
{
return(result);
}
while (reader.Read())
{
var item = new FieldProperty(reader["columnName"].ToString(), reader["typeName"].ToString(), reader["isnullAble"].ToString());
result.Add(item);
}
return(result);
}
/// <summary>
/// 获取注释
/// </summary>
/// <param name="item"></param>
/// <param name="descriptionModels"></param>
/// <returns></returns>
private string BuildDescription(FieldProperty item, List <DescriptionModel> descriptionModels)
{
if (descriptionModels == null || !descriptionModels.Any())
{
return(string.Empty);
}
try
{
var desc = descriptionModels.FirstOrDefault(o => o.ColumnName.Equals(item.ColumnName, StringComparison.InvariantCultureIgnoreCase)).ColumnDescript;
return(desc);
}
catch
{
return(string.Empty);
}
}