static void CheckDBConnection() { OTEntities ctx = new OTEntities(); var q = from p in ctx.OT_APP1 select p; if (q.Count() >-1) { Console.Write("db connection is good"); } ctx.Database.Connection.Close(); ctx.Dispose(); }
public override long findSeqNumByCode(string code) { OTEntities context = new OTEntities(); var q = from p in context.SYS_SEQ where p.SEQ_CODE == code select p; if(q.FirstOrDefault()!=null) { SYS_SEQ seq = q.FirstOrDefault(); long num =(long)seq.SEQ_NUM; seq.SEQ_NUM ++; context.SaveChanges(); return num; } /* SysSeq ss = sysSeqDao.findBySeqCode(code); long seqNum = ss.getSeqNum(); ss.setSeqNum(ss.getSeqNum() + 1); sysSeqDao.save(ss); return seqNum;*/ return 0; }