1.
public IEnumerable<RiskInfo> GetRisksByUsername()
{
AuroraDataContext db = new AuroraDataContext();
var list = db.GetRisksByUsername().Select(c => new RiskInfo { Number = c.Number, Name = c.Name });
return list;
}
public class RiskInfo
{
public int? Number { get; set; }
public string Name { get; set; }
}
2.
下面给出个简单的例子:
publicinterface IStockStatistics
{
IT_Modelnumber ModelNumber { get; set; }
int TotalAmount { get; set ;}
}
{
IT_Modelnumber ModelNumber { get; set; }
int TotalAmount { get; set ;}
}
public class StockStatistics:IStockStatistics { private int _id; private IT_Modelnumber _model; private int _amount; public int Id { get{return _id ;} set{_id =value ;} } public IT_Modelnumber ModelNumber { get { return _model; } set { _model = value; } } public int TotalAmount { get { return _amount; } set { _amount = value; } } }
public ICollection<IStockStatistics > GetStatistics() { var result = from p in Database.StockDS group p by p.ToModelnumber into g select new StockStatistics { Id = g.Key.Id, ModelNumber = g.Key, TotalAmount = g.Sum(p => p.Amount) }; return result.AsEnumerable().Cast<IStockStatistics>().ToList().AsReadOnly(); }
简单的说这个方法就是将原本匿名的类型转换成我们已知的类型,但这个类型不存在,所以需要我们先进行定义。
select new StockStatistics :new 后面的类型有些资料中省略了,但我在自己的环境中省略后编译没有通过。