private SqlQueryInfo CreateSelectFullByKeySqlText(DbManager db, Type type) { var sb = new StringBuilder(); var query = new FullSqlQueryInfo(); sb.Append("SELECT\n"); var mainMapper = (FullObjectMapper)db.MappingSchema.GetObjectMapper(type); BuildSelectSql(mainMapper, sb, db); sb.Remove(sb.Length - 2, 1); sb.Append("FROM\n\t"); FullAppendTableName(sb, db, type); AppendJoinTableName(mainMapper, sb, db, type); AddWherePK(db, query, sb, -1, mainMapper); query.QueryText = sb.ToString(); return(query); }
private SqlQueryInfo CreateSelectAllFullSqlText(DbManager db, Type type) { var sb = new StringBuilder(); var query = new FullSqlQueryInfo(); sb.Append("SELECT\n"); var mainMapper = (FullObjectMapper)db.MappingSchema.GetObjectMapper(type); ; BuildSelectSQL(mainMapper, sb, db); sb.Remove(sb.Length - 2, 1); sb.Append("FROM\n\t"); AppendTableName(sb, db, type); AppendJoinTableName(sb, db, type); query.QueryText = sb.ToString(); return query; }
protected SqlQueryInfo CreateSelectAllFullSqlText(DbManager db, Type type) { var sb = new StringBuilder(); var query = new FullSqlQueryInfo(); sb.Append("SELECT\n"); int index = 0; FullObjectMapper mainMapper = ((FullMappingSchema)db.MappingSchema).GetObjectMapper(type, ref index); BuildSelectSQL(mainMapper, sb, db); sb.Remove(sb.Length - 2, 1); sb.Append("FROM\n\t"); AppendTableName(sb, db, type); AppendJoinTableName(sb, db, type); query.QueryText = sb.ToString(); return(query); }
protected SqlQueryInfo CreateSelectFullByKeySqlText(DbManager db, Type type) { var sb = new StringBuilder(); var query = new FullSqlQueryInfo(); sb.Append("SELECT\n"); int index = 0; FullObjectMapper mainMapper = ((FullMappingSchema)db.MappingSchema).GetObjectMapper(type, ref index); BuildSelectSQL(mainMapper, sb, db); sb.Remove(sb.Length - 2, 1); sb.Append("FROM\n\t"); AppendTableName(sb, db, type); AppendJoinTableName(sb, db, type); AddWherePK(db, query, sb, -1, mainMapper); query.QueryText = sb.ToString(); return query; }