private void _Test(QueryTypeInstance queryType, IDbConnection connection)
{
var _ins = new Dictionary <int, string>();
_ins.Add(1, "1");
var _parts = new Dictionary <int, bool>();
_parts.Add(1, true);
var preparedSql = queryType.ConstructSql(_ins, _parts);
string sql = preparedSql.Item1;
using (var command = connection.CreateCommand())
{
connection.Open();
command.CommandText = sql;
foreach (var item in preparedSql.Item2)
{
var parameter = command.CreateParameter();
parameter.ParameterName = item.Key;
parameter.Value = item.Value;
command.Parameters.Add(parameter);
}
using (var reader = command.ExecuteReader())
{
var dataTable = new DataTable();
dataTable.Load(reader);
}
}
}
public QueryTypeInstance _GetQueryTypeByID(WebBuilderEFContext db, int queryTypeID)
{
QueryType type = this._GetQueryType(db, queryTypeID);
List <QueryTypeInInstance> ins = this._GetQueryTypeIns(db, queryTypeID);
List <QueryTypeOutInstance> outs = this._GetQueryTypeOuts(db, queryTypeID);
List <QueryTypeTableInstance> tables = this._GetQueryTypeTables(db, queryTypeID);
List <QueryTypeColumnInstance> columns = this._GetQueryTypeColumns(db, queryTypeID);
List <QueryTypePart> parts = this._GetQueryTypeParts(db, queryTypeID);
QueryTypeInstance queryType = new QueryTypeInstance(type, ins, outs, parts, tables, columns);
return(queryType);
}
