/// <summary> /// Function to delete entity whose primary key is passes. /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> /// <param name="context">context to maintain transaction</param> public void Delete(object pk, CompatibilityEntities context) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> /// <param name="context">context to maintain transaction</param> public void Update(T entity, CompatibilityEntities context) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; }
/// <summary> /// Function to select entity by primary key /// </summary> /// <param name="pk">Primary key of entity to fetch</param> /// <returns></returns> public T SelectByID(object pk) { using (CompatibilityEntities context = new CompatibilityEntities()) { DbSet <T> table = context.Set <T>(); return(table.Find(pk)); } }
/// <summary> /// Function to create entity instance /// </summary> /// <returns>New instance of entity</returns> public T CreateEntity() { using (CompatibilityEntities context = new CompatibilityEntities()) { DbSet <T> table = context.Set <T>(); return(table.Create()); } }
/// <summary> /// Function to insert entity. /// </summary> /// <param name="entity">entity to be inserted</param> public string Insert(T entity) { try { using (CompatibilityEntities context = new CompatibilityEntities()) { DbSet <T> table = context.Set <T>(); table.Add(entity); context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(ex.Message); } }
public List <string> LoadCompYSVersionDesign(string parm) { try { using (CompatibilityEntities context = new CompatibilityEntities()) { return(context.Database.SqlQuery <string>("Select YieldStarSWVersion from YiledStarSoftware , CompatibleDesign lis , CompatibleDesign ys where lis.CompatibleID = ys.CompatibleID and lis.LISID = '" + parm + "' and lis.YiledStarID = LISServerSoftware.YiledStarID").ToList()); } } catch (Exception ex) { return(new List <string>() { ex.Message }); } }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> public string Update(T entity) { try { using (CompatibilityEntities context = new CompatibilityEntities()) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> public string Delete(object pk) { try { using (CompatibilityEntities context = new CompatibilityEntities()) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// Function to get entites /// </summary> /// <returns>DbSet result of entities</returns> public DbSet <T> GetEntities() { CompatibilityEntities context = new CompatibilityEntities(); return(context.Set <T>()); }
/// <summary> /// Function to insert entity. /// </summary> /// <param name="entity">entity to be inserted</param> /// <param name="context">context to maintain transaction</param> public void Insert(T entity, CompatibilityEntities context) { DbSet <T> table = context.Set <T>(); table.Add(entity); }