/// <summary> /// Reads data into a <see cref="List{T}"/>. /// <para>Valid <typeparamref name="T"/> types: <see cref="DataSet"/>, <see cref="DataTable"/>, <see cref="Dictionary{string,object}"/>, any .NET built-in type, or any struct or class with a parameterless constructor not assignable from <see cref="System.Collections.IEnumerable"/> (Note: only properties will be mapped).</para> /// </summary> /// <typeparam name="T">The generic type to use.</typeparam> /// <param name="odr">The <see cref="DbDataReader"/> to use.</param> /// <param name="token">The <see cref="CancellationToken"/> to use. (Optional)</param> /// <param name="cmd">The <see cref="IDbJobCommand"/> to use for data projection and caching. (Optional)</param> /// <returns>The <see cref="List{T}"/>.</returns> /// <exception cref="System.InvalidCastException">Thrown when <typeparamref name="T"/> is missing a parameterless constructor.</exception> /// <exception cref="System.InvalidCastException">Thrown when <typeparamref name="T"/> is assignable from <see cref="System.Collections.IEnumerable"/>.</exception> public static List <T> ToList <T>(this DbDataReader odr, CancellationToken token = default, IDbJobCommand cmd = null) { List <T> projectedData = new List <T>(); if (odr.HasRows) { Type tType = typeof(T); if (!DbConnectorUtilities._directTypeMap.Contains(tType) && !(tType.IsValueType && (tType.IsEnum || (Nullable.GetUnderlyingType(tType)?.IsEnum ?? false))) && !tType.IsArray) { //Dynamic MSIL cached version is around 30% faster and uses up to 57% less memory. if (cmd != null && (cmd.Flags & DbJobCommandFlags.NoCache) == DbJobCommandFlags.None) { ColumnMapCacheModel cacheModel = new ColumnMapCacheModel(tType, cmd, odr.GetOrdinalColumnNamesHash()); if (!DbConnectorCache.TryGetColumnMap(cacheModel, out IDynamicColumnMapper mapper)) { mapper = DynamicColumnMapper.CreateMapper <T>(odr.GetOrdinalColumnNames(cmd.MapSettings), cmd.MapSettings); DbConnectorCache.SetColumnMap(cacheModel, mapper); } var genericMapper = mapper as DynamicColumnMapper <T>; while (odr.Read()) { if (token.IsCancellationRequested) { return(projectedData); } projectedData.Add(genericMapper.OnBuild(odr)); } } else { if (typeof(IEnumerable).IsAssignableFrom(tType)) { throw new InvalidCastException("The type " + tType + " is not supported"); } else if (tType.IsClass && tType.GetConstructor(Type.EmptyTypes) == null) { throw new InvalidCastException("The type " + tType + " is missing a parameterless constructor"); } var columnMaps = odr.GetColumnMaps(tType, cmd?.MapSettings); if (tType.IsClass) { while (odr.Read()) { if (token.IsCancellationRequested) { return(projectedData); } projectedData.Add(odr.GetMappedObject <T>(columnMaps)); } } else { while (odr.Read()) { if (token.IsCancellationRequested) { return(projectedData); } projectedData.Add((T)odr.GetMappedObject(tType, columnMaps)); } } } } else if (tType == typeof(Dictionary <string, object>)) { projectedData = (List <T>)Convert.ChangeType(odr.ToDictionaries(false, token, cmd), typeof(List <Dictionary <string, object> >)); } else if (tType == typeof(List <KeyValuePair <string, object> >)) { projectedData = (List <T>)Convert.ChangeType(odr.ToKeyValuePairs(false, token, cmd), typeof(List <List <KeyValuePair <string, object> > >)); } else if (tType == typeof(DataTable)) { projectedData.Add((T)Convert.ChangeType(odr.ToDataTable(false, token, cmd.MapSettings), tType)); } else if (tType == typeof(DataSet)) { projectedData.Add((T)Convert.ChangeType(odr.ToDataSet(false, token, cmd.MapSettings), tType)); } else if (tType == typeof(object)) { projectedData = odr.ToList(token, cmd) as dynamic; } else { Type nonNullableObjType = tType.IsValueType ? (Nullable.GetUnderlyingType(tType) ?? tType) : tType; while (odr.Read()) { if (token.IsCancellationRequested) { return(projectedData); } object value = odr.GetValue(0); if (value != DBNull.Value) { projectedData.Add((T)(DbConnectorUtilities.ThrowIfFailedToMatchColumnType(tType, nonNullableObjType, value, () => odr.GetName(0)))); } else { projectedData.Add(default);
/// <summary> /// Reads a single row data into a dynamic object. /// </summary> /// <param name="odr">The <see cref="DbDataReader"/> to use.</param> /// <param name="token">The <see cref="CancellationToken"/> to use. (Optional)</param> /// <param name="cmd">The <see cref="IDbJobCommand"/> to use for data projection and caching. (Optional)</param> /// <returns>The dynamic object.</returns> /// <exception cref="InvalidOperationException">The query result has more than one result.</exception> /// <exception cref="InvalidOperationException">The query result is empty.</exception> public static dynamic Single(this DbDataReader odr, CancellationToken token = default, IDbJobCommand cmd = null) { dynamic projectedData; if (odr.HasRows) { projectedData = odr.ToFirst(cmd); if (odr.Read()) { throw new InvalidOperationException("The query result has more than one result."); } } else { throw new InvalidOperationException("The query result is empty."); } return(projectedData); }
public ColumnMapCacheModel(Type tType, IDbJobCommand jobCommand, int ordinalColumnNamesHash) { Ttype = tType; //CommandText = jobCommand.CommandText; //CommandType = jobCommand.CommandType; CommandBehavior = jobCommand.CommandBehavior; ParameterCount = jobCommand.Parameters.Count; unchecked { int hash = 5; int localHash = 0; hash = (hash * 11) + Ttype.GetHashCode(); hash = (hash * 11) + ordinalColumnNamesHash; //hash = (hash * 11) + (byte)CommandType; //hash = (hash * 11) + (CommandText?.GetHashCode() ?? 0); hash = (hash * 11) + (CommandBehavior == null ? 0 : (int)CommandBehavior); if (ParameterCount != 0) { for (int i = 0; i < ParameterCount; i++) { var item = jobCommand.Parameters._collection[i]; localHash += (item.Value?.GetType().GetHashCode() ?? 0) + (int)item.Direction + (item.ParameterName?.GetHashCode() ?? 0); } hash = (hash * 11) + localHash; localHash = 0; } if (jobCommand.MapSettings.HasNamesToInclude) { foreach (var item in jobCommand.MapSettings.NamesToInclude) { localHash += item.GetHashCode(); } hash = (hash * 11) + localHash + 1; localHash = 0; } if (jobCommand.MapSettings.HasNamesToExclude) { foreach (var item in jobCommand.MapSettings.NamesToExclude) { localHash += item.GetHashCode(); } hash = (hash * 11) + localHash; localHash = 0; } if (jobCommand.MapSettings.HasJoins) { foreach (var item in jobCommand.MapSettings.Joins) { localHash += (item.Key.GetHashCode() + item.Value.GetHashCode()); } hash = (hash * 11) + localHash; localHash = 0; } if (jobCommand.MapSettings.HasAliases) { foreach (var item in jobCommand.MapSettings.Aliases) { foreach (var valueItem in item.Value) { localHash += (valueItem.Key.GetHashCode() + valueItem.Value.GetHashCode()); } localHash += (item.Key.GetHashCode() + localHash); } hash = (hash * 11) + localHash; } HashCode = hash; } }
/// <summary> /// Reads a single row data into an object of <typeparamref name="T"/> type. /// <para>Valid <typeparamref name="T"/> types: <see cref="DataSet"/>, <see cref="DataTable"/>, <see cref="Dictionary{string,object}"/>, any .NET built-in type, or any struct or class with a parameterless constructor not assignable from <see cref="System.Collections.IEnumerable"/> (Note: only properties will be mapped).</para> /// </summary> /// <typeparam name="T">The generic type to use.</typeparam> /// <param name="odr">The <see cref="DbDataReader"/> to use.</param> /// <param name="token">The <see cref="CancellationToken"/> to use. (Optional)</param> /// <param name="cmd">The <see cref="IDbJobCommand"/> to use for data projection and caching. (Optional)</param> /// <returns>The <typeparamref name="T"/>.</returns> /// <exception cref="InvalidOperationException">The query result has more than one result.</exception> /// <exception cref="System.InvalidCastException">Thrown when <typeparamref name="T"/> is missing a parameterless constructor.</exception> /// <exception cref="System.InvalidCastException">Thrown when <typeparamref name="T"/> is assignable from <see cref="System.Collections.IEnumerable"/>.</exception> public static T SingleOrDefault <T>(this DbDataReader odr, CancellationToken token = default, IDbJobCommand cmd = null) { if (odr.HasRows) { T projectedData = odr.ToFirst <T>(token, cmd); if (odr.Read()) { throw new InvalidOperationException("The query result has more than one result."); } return(projectedData); } else { return(default);