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>();
}
