What you do today can improve all your tomorrows.
Bear in mind: S = Single Responsibility Principle
O = Opened Closed Principle
L = Liskov Substitution Principle
I = Interface Segregation Principle
D = Dependency Inversion Principle
摘要:
using (ExcelPackage excelPackage = new ExcelPackage(new FileInfo(xlsxfullname))){ ExcelWorkbook wp = excelPackage.Workbook; ExcelWorksheet sh = wp.Worksheets[sheetname]; int col = 1; //1 为起始列 int rowindex = 1; //1为起始行 while (... 阅读全文
摘要:
SqlParameter[] parms = new SqlParameter[2];SqlParameter id = new SqlParameter("ID", "11a44466-6d9c-4c7e-b9e4-5a1369061119");id.SqlDbType=SqlDbType.NVarChar;id.Size = 128;parms[0] = id; var outParam = new SqlParameter();outParam.ParameterName = "Name";outParam.SqlDbType 阅读全文
摘要:
Code First1. 基于Model中 字段 ID/ [className]+ID / 某字段有[Key] , 来自动生成主键的, 如果没有将会报如标题的错. public class Order{ public int ID{get;set;} } public class Order{ public int OrderID{get;set;} } public class Order{ [Key] public int CustomID{get;set;} }2. 当需要复合主键时,则要在各个主键上加 [Key, Column(Order=0)], ... 阅读全文