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