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