public CityData SelectById(object id) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <CityData> table = context.Set <CityData>(); return(table.Find(id)); } }
public List <UserRoleMapping> SelectAll() { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <UserRoleMapping> table = context.Set <UserRoleMapping>(); return(table.ToList()); } }
public List <CityData> SelectAll() { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <CityData> table = context.Set <CityData>(); return(table.ToList()); } }
public UserRoleMapping SelectById(object id) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <UserRoleMapping> table = context.Set <UserRoleMapping>(); return(table.Find(id)); } }
public OverseasTerritoriesData SelectById(object id) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <OverseasTerritoriesData> table = context.Set <OverseasTerritoriesData>(); return(table.Find(id)); } }
public List <OverseasTerritoriesData> SelectAll() { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet <OverseasTerritoriesData> table = context.Set <OverseasTerritoriesData>(); return(table.ToList()); } }
public void Update(CityData entity) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet table = context.CityData; table.Attach(entity); context.Entry(entity).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void Delete(UserRoleMapping entity) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet table = context.UserRoleMapping; table.Attach(entity); context.Entry(entity).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
public void Insert(RoleData entity) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet table = context.RoleData; table.Attach(entity); context.Entry(entity).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); } }
public void Delete(OverseasTerritoriesData entity) { using (WorldMapDBContext context = new WorldMapDBContext()) { DbSet table = context.OverseasTerritoriesData; table.Attach(entity); context.Entry(entity).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
public List <CityData> Search(Expression <Func <CityData, bool> > filter = null) { using (WorldMapDBContext context = new WorldMapDBContext()) { if (filter == null) { return(context.CityData.ToList()); } return(context.CityData.Where(filter).ToList()); } }
public List <UserRoleMapping> Search(Expression <Func <UserRoleMapping, bool> > filter = null) { using (WorldMapDBContext context = new WorldMapDBContext()) { if (filter == null) { return(context.UserRoleMapping.ToList()); } return(context.UserRoleMapping.Where(filter).ToList()); } }
public List <OverseasTerritoriesData> Search(Expression <Func <OverseasTerritoriesData, bool> > filter = null) { using (WorldMapDBContext context = new WorldMapDBContext()) { if (filter == null) { return(context.OverseasTerritoriesData.ToList()); } return(context.OverseasTerritoriesData.Where(filter).ToList()); } }
public DbSet GetEntites() { WorldMapDBContext context = new WorldMapDBContext(); return(context.CityData); }
public DbSet GetEntites() { WorldMapDBContext context = new WorldMapDBContext(); return(context.UserRoleMapping); }
public DbSet GetEntites() { WorldMapDBContext context = new WorldMapDBContext(); return(context.OverseasTerritoriesData); }