public static CodeTable GetById(int codeTableId) { using (var context = new ATSCEEntities()) { return context.CodeTables.Single(r => r.CodeTableId == codeTableId); } }