public static T[] GetFieldValues <T>(DBConnector localdbConnector, int contentId, string fieldName, int[] ids = null, bool isAsync = false)
{
var asyncString = isAsync ? "_async" : string.Empty;
var idsString = ids != null ? $"where content_item_id in ({IdsStr(ids)})" : string.Empty;
var fn = SqlQuerySyntaxHelper.FieldName(localdbConnector.DatabaseType, fieldName);
var sql = $"select {fn} from content_{contentId}{asyncString} {idsString} order by content_item_id asc";
return(localdbConnector.GetRealData(sql).Select().Select(row => ConvertHelpers.ChangeType <T>(row[fieldName])).ToArray());
}
public static T[] GetFieldValues <T>(DBConnector localdbConnector, int contentId, string fieldName, int[] ids = null, bool isAsync = false)
{
var asyncString = isAsync ? "_async" : string.Empty;
var idsString = ids != null ? $"where content_item_id in ({string.Join(",", ids)})" : string.Empty;
return(localdbConnector.GetRealData($"select [{fieldName}] from content_{contentId}{asyncString} {idsString}")
.Select()
.Select(row => ConvertHelpers.ChangeType <T>(row[fieldName]))
.ToArray());
}