private QueryActionInstance _GetQueryInstanceByQuery(WebBuilderEFContext db, EventAction action, QueryAction query)
{
List <QueryActionInInstance> ins = this._GetQueryIns(db, query.ActionID);
List <QueryActionOutInstance> outs = this._GetQueryOuts(db, query.ActionID);
List <QueryActionPartInstance> parts = this._GetQueryParts(db, query.ActionID);
QueryActionInstance queryInstance = new QueryActionInstance(action, query, ins, outs, parts);
return(queryInstance);
}
public QueryActionInstance _GetQueryActionByID(WebBuilderEFContext db, int queryActionID)
{
var query = (
from queryAction in db.QueryActions
join action in db.EventActions on queryAction.ActionID equals action.ActionID
where queryAction.ActionID == queryActionID
select new { queryAction = queryAction, action = action }
)
.SingleOrDefault();
if (query == null)
{
throw new Exception(string.Format(
"Query not found(queryActionID = {0})", queryActionID
));
}
QueryActionInstance instance = this._GetQueryInstanceByQuery(db, query.action, query.queryAction);
return(instance);
}
