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