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