public override void DeleteAll() { //base.DeleteAll(); var db = new DbTableRepository <Device>(); db.DbContext.Database.ExecuteSqlCommand("DELETE FROM device"); db.DbContext.Database.ExecuteSqlCommand("ALTER TABLE device AUTO_INCREMENT = 1"); }
public virtual IEnumerable <DeviceSecurityCardDto> SelectCardList() { var db = new DbTableRepository <Device>().DbContext; return((from m in db.icmaps join d in db.Devices on m.C_entrancedoor equals d.roomid orderby m.C_entrancedoor select new DeviceSecurityCardDto { DeviceAddress = d.roomid, DeviceType = d.type, CardNumber = m.C_icno }) .ToList()); }