/// <summary>
/// Execute given query on Client connection
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <returns></returns>
public List <T> GetViewResult_Client <T>(string query)
{
using (var db = new ReportApplicationEntities())
{
return(db.Database.SqlQuery <T>(query).ToList());
}
}
/// <summary>
/// Execute given query on Exigent connection for single object
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <returns></returns>
public T GetSingleViewResult <T>(string query)
{
using (var db = new ReportApplicationEntities())
{
return(db.Database.SqlQuery <T>(query).FirstOrDefault());
}
}
/// <summary>
/// Execute given query on Exigent connection
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <returns></returns>
public static int ExecuteQuery(string query)
{
using (var db = new ReportApplicationEntities())
{
return(db.Database.ExecuteSqlCommand(query));
}
}
public static DataSet ExecuteQueryForGrid(string commandText, string DBConnection, CommandType commandType, params SqlParameter[] parameters)
{
ReportApplicationEntities db = new ReportApplicationEntities();
DBConnection = db.Database.Connection.ConnectionString.ToString();
using (var connection = new SqlConnection(DBConnection))
using (var command = new SqlCommand(commandText, connection))
{
DataSet ds = new DataSet();
command.CommandType = commandType;
command.Parameters.AddRange(parameters);
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(ds);
connection.Close();
return(ds);
}
}
public static SqlConnection GetExigentConnection()
{
ReportApplicationEntities ReportApplicationEntities = new ReportApplicationEntities();
return(new SqlConnection((ReportApplicationEntities.Database.Connection).ConnectionString));
}
