摘要： 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 { 阅读全文

摘要： SQL2008 Tools->Designers->Table and Database Designers=>untick the 'Prevent saving changes that require table re-creation'SQL2008:Back Up->Options->Set backup compression:Compress backup对于有主外键关系的表注意是否要指定Cascade属性。双击Keys下面的某个外键关系，‘INSERT And UPDATE Specifical’选择 'Cascade 阅读全文