public IEnumerable <T> ExecuteQuery(string spQuery, object[] parameters) { using (entity = new EWaterContext()) { return(entity.Database.SqlQuery <T>(spQuery, parameters).ToList()); } }
public T ExecuteQuerySingle(string spQuery, object[] parameters) { using (entity = new EWaterContext()) { return(entity.Database.SqlQuery <T>(spQuery, parameters).FirstOrDefault()); } }
public int ExecuteCommand(string spQuery, object[] parameters) { int result = 0; try { using (entity = new EWaterContext()) { result = entity.Database.ExecuteSqlCommand(spQuery, parameters); } } catch (Exception ex) { ex.ToString(); } return(result); }
public GenericRepository(EWaterContext entity) { this.entity = entity; entities = entity.Set <T>(); }