/// <summary> /// Get Data From Database /// <para>Use it when to retive data through a stored procedure</para> /// </summary> public IEnumerable <T> ExecuteQuery(string spQuery) { using (context = new IPMI_DBEntities()) { return(context.Database.SqlQuery <T>(spQuery).ToList()); } }
/// <summary> /// Get Single Data From Database /// <para>Use it when to retive single data through a stored procedure</para> /// </summary> public T ExecuteQuerySingle(string spQuery, object[] parameters) { using (context = new IPMI_DBEntities()) { return(context.Database.SqlQuery <T>(spQuery, parameters).FirstOrDefault()); } }
/// <summary> /// Get Single Data From Database /// <para>Use it when to retive single data through a stored procedure</para> /// </summary> public string ExecuteQuerySingle1(string spQuery, object[] parameters) { string result = ""; try { using (context = new IPMI_DBEntities()) { result = context.Database.SqlQuery <string>(spQuery, parameters).FirstOrDefault(); } } catch { } return(result); }
/// <summary> /// Insert/Update/Delete Data To Database /// <para>Use it when to Insert/Update/Delete data through a stored procedure</para> /// </summary> public int ExecuteCommand(string spQuery, object[] parameters) { int result = 0; try { using (context = new IPMI_DBEntities()) { result = context.Database.SqlQuery <int>(spQuery, parameters).FirstOrDefault(); } } catch { } return(result); }
public GenericRepository(IPMI_DBEntities context) { this.context = context; entities = context.Set <T>(); }