linq2db by Igor Tkachev, Ilya Chudin, Svyatoslav Danyliv, Dmitry Lukashenko

<PackageReference Include="linq2db" Version="2.9.6" />

---

API Diff between 2.9.6 and 1.0.7.1

4391 Additions 0 Removals

LinqToDB

• public static class AnalyticFunctions
  • public interface IAggregateFunction<TR> : IAnalyticFunction<TR>
  • public interface IAggregateFunctionSelfContained<TR> : IAggregateFunction<TR>, IAnalyticFunction<TR>, IReadyToFunction<TR>
  • public interface IAnalyticFunction<TR>
  • public interface IAnalyticFunctionWithoutWindow<TR>
  • public interface IAndExpected<TR>
  • public interface IBetweenStartExpected<TR>
  • public interface IBoundaryExpected<TR>
  • public interface INeedOrderByAndMaybeOverWithPartition<TR>
  • public interface INeedSingleOrderByAndMaybeOverWithPartition<TR>
  • public interface INeedsOrderByOnly<TR>
  • public interface INeedsWithinGroupWithOrderAndMaybePartition<TR>
  • public interface INeedsWithinGroupWithOrderOnly<TR>
  • public interface INeedsWithinGroupWithSingleOrderAndMaybePartition<TR>
  • public interface IOrderedAcceptOverReadyToFunction<TR> : IReadyToFunctionOrOverWithPartition<TR>, IReadyToFunction<TR>
  • public interface IOrderedReadyToFunction<TR> : IReadyToFunction<TR>
  • public interface IOrderedReadyToWindowing<TR> : IReadyToFunction<TR>
  • public interface IOverMayHavePartition<TR> : IReadyToFunction<TR>
  • public interface IOverMayHavePartitionAndOrder<TR> : IReadyToFunction<TR>, INeedsOrderByOnly<TR>
  • public interface IOverWithPartitionNeeded<TR>
  • public interface IPartitionDefinedReadyForSortingWithWindow<TR> : IReadyForSortingWithWindow<TR>, IReadyToFunction<TR>
  • public interface IPartitionedMayHaveOrder<TR> : IReadyToFunction<TR>, INeedsOrderByOnly<TR>
  • public interface IReadyForFullAnalyticClause<TR> : IReadyToFunction<TR>, IReadyForSortingWithWindow<TR>
  • public interface IReadyForSortingWithWindow<TR>
  • public interface IReadyToFunction<TR>
  • public interface IReadyToFunctionOrOverWithPartition<TR> : IReadyToFunction<TR>
  • public interface ISecondBoundaryExpected<TR>
  • public static double Average<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static double Average<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier)
  • public static IAggregateFunctionSelfContained<T> Average<T>(this ISqlExtension ext, object expr)
  • public static IAggregateFunctionSelfContained<T> Average<T>(this ISqlExtension ext, object expr, AggregateModifier modifier)
  • public static decimal Corr<T>(this IEnumerable<T> source, Expression<Func<T, object>> expr1, Expression<Func<T, object>> expr2)
  • public static decimal Corr<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object>> expr1, Expression<Func<TEntity, object>> expr2)
  • public static IAggregateFunctionSelfContained<T> Corr<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<int> Count(this ISqlExtension ext)
  • public static IAggregateFunctionSelfContained<int> Count<T>(this ISqlExtension ext, T expr)
  • public static IAggregateFunctionSelfContained<int> Count(this ISqlExtension ext, object expr, AggregateModifier modifier)
  • public static int CountExt<TEntity>(this IEnumerable<TEntity> source, Func<TEntity, object> expr)
  • public static int CountExt<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static int CountExt<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier = 0)
  • public static decimal CovarPop<T>(this IEnumerable<T> source, Expression<Func<T, object>> expr1, Expression<Func<T, object>> expr2)
  • public static decimal CovarPop<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object>> expr1, Expression<Func<TEntity, object>> expr2)
  • public static IAggregateFunctionSelfContained<T> CovarPop<T>(this ISqlExtension ext, T expr1, T expr2)
  • public static decimal CovarSamp<T>(this IEnumerable<T> source, Expression<Func<T, object>> expr1, Expression<Func<T, object>> expr2)
  • public static decimal CovarSamp<TEntity>(this IQueryable<TEntity> source, Expression<Func<TEntity, object>> expr1, Expression<Func<TEntity, object>> expr2)
  • public static IAggregateFunctionSelfContained<T> CovarSamp<T>(this ISqlExtension ext, T expr1, T expr2)
  • public static INeedsWithinGroupWithOrderOnly<TR> CumeDist<TR>(this ISqlExtension ext, object[] expr)
  • public static IAnalyticFunctionWithoutWindow<TR> CumeDist<TR>(this ISqlExtension ext)
  • public static INeedsWithinGroupWithOrderOnly<long> DenseRank(this ISqlExtension ext, object expr1, object expr2)
  • public static IAnalyticFunctionWithoutWindow<long> DenseRank(this ISqlExtension ext)
  • public static IAggregateFunctionSelfContained<T> FirstValue<T>(this ISqlExtension ext, T expr, Nulls nulls)
  • public static INeedOrderByAndMaybeOverWithPartition<TR> KeepFirst<TR>(this IAggregateFunction<TR> ext)
  • public static INeedOrderByAndMaybeOverWithPartition<TR> KeepLast<TR>(this IAggregateFunction<TR> ext)
  • public static IAnalyticFunctionWithoutWindow<T> Lag<T>(this ISqlExtension ext, T expr, Nulls nulls)
  • public static IAnalyticFunctionWithoutWindow<T> Lag<T>(this ISqlExtension ext, T expr, Nulls nulls, int offset, int? default)
  • public static IAggregateFunctionSelfContained<T> LastValue<T>(this ISqlExtension ext, T expr, Nulls nulls)
  • public static IAnalyticFunctionWithoutWindow<T> Lead<T>(this ISqlExtension ext, T expr, Nulls nulls)
  • public static IAnalyticFunctionWithoutWindow<T> Lead<T>(this ISqlExtension ext, T expr, Nulls nulls, int offset, int? default)
  • public static INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this ISqlExtension ext, T expr)
  • public static INeedsWithinGroupWithOrderAndMaybePartition<string> ListAgg<T>(this ISqlExtension ext, T expr, string delimiter)
  • public static TV Max<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static TV Max<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier)
  • public static IAggregateFunctionSelfContained<T> Max<T>(this ISqlExtension ext, T expr)
  • public static IAggregateFunctionSelfContained<T> Max<T>(this ISqlExtension ext, T expr, AggregateModifier modifier)
  • public static long Median<TEntity, T>(this IEnumerable<TEntity> source, Func<TEntity, T> expr)
  • public static long Median<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
  • public static IReadyToFunctionOrOverWithPartition<T> Median<T>(this ISqlExtension ext, T expr)
  • public static TV Min<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static TV Min<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier)
  • public static IAggregateFunctionSelfContained<T> Min<T>(this ISqlExtension ext, T expr)
  • public static IAggregateFunctionSelfContained<T> Min<T>(this ISqlExtension ext, T expr, AggregateModifier modifier)
  • public static IAggregateFunctionSelfContained<T> NthValue<T>(this ISqlExtension ext, T expr, long n)
  • public static IAggregateFunctionSelfContained<T> NthValue<T>(this ISqlExtension ext, T expr, long n, From from, Nulls nulls)
  • public static IAnalyticFunctionWithoutWindow<T> NTile<T>(this ISqlExtension ext, T expr)
  • public static INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileCont<T>(this ISqlExtension ext, object expr)
  • public static INeedsWithinGroupWithSingleOrderAndMaybePartition<T> PercentileDisc<T>(this ISqlExtension ext, object expr)
  • public static INeedsWithinGroupWithOrderOnly<T> PercentRank<T>(this ISqlExtension ext, object[] expr)
  • public static IAnalyticFunctionWithoutWindow<T> PercentRank<T>(this ISqlExtension ext)
  • public static INeedsWithinGroupWithOrderOnly<long> Rank(this ISqlExtension ext, object[] expr)
  • public static IAnalyticFunctionWithoutWindow<long> Rank(this ISqlExtension ext)
  • public static IOverWithPartitionNeeded<TR> RatioToReport<TR>(this ISqlExtension ext, object expr)
  • public static IAggregateFunctionSelfContained<T> RegrAvgX<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrAvgY<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<long> RegrCount(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrIntercept<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrR2<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrSlope<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrSXX<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrSXY<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAggregateFunctionSelfContained<T> RegrSYY<T>(this ISqlExtension ext, object expr1, object expr2)
  • public static IAnalyticFunctionWithoutWindow<long> RowNumber(this ISqlExtension ext)
  • public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static double StdDev<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static double StdDev<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier = 0)
  • public static IAggregateFunctionSelfContained<T> StdDev<T>(this ISqlExtension ext, object expr)
  • public static IAggregateFunctionSelfContained<T> StdDev<T>(this ISqlExtension ext, object expr, AggregateModifier modifier)
  • public static decimal StdDevPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static decimal StdDevPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
  • public static IAggregateFunctionSelfContained<T> StdDevPop<T>(this ISqlExtension ext, object expr)
  • public static decimal StdDevSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static decimal StdDevSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
  • public static IAggregateFunctionSelfContained<T> StdDevSamp<T>(this ISqlExtension ext, object expr)
  • public static IAggregateFunctionSelfContained<T> Sum<T>(this ISqlExtension ext, T expr)
  • public static IAggregateFunctionSelfContained<T> Sum<T>(this ISqlExtension ext, T expr, AggregateModifier modifier)
  • public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static TV Variance<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr, AggregateModifier modifier)
  • public static TV Variance<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr, AggregateModifier modifier = 0)
  • public static IAggregateFunctionSelfContained<T> Variance<T>(this ISqlExtension ext, object expr)
  • public static IAggregateFunctionSelfContained<T> Variance<T>(this ISqlExtension ext, object expr, AggregateModifier modifier)
  • public static decimal VarPop<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static decimal VarPop<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
  • public static IAggregateFunctionSelfContained<T> VarPop<T>(this ISqlExtension ext, object expr)
  • public static decimal VarSamp<TEntity, TV>(this IEnumerable<TEntity> source, Func<TEntity, TV> expr)
  • public static decimal VarSamp<TEntity, TV>(this IQueryable<TEntity> source, Expression<Func<TEntity, TV>> expr)
  • public static IAggregateFunctionSelfContained<T> VarSamp<T>(this ISqlExtension ext, object expr)
• public static class AsyncExtensions
  • public static Task<bool> AllAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<bool> AnyAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<double> AverageAsync(this IQueryable<int> source, CancellationToken token = default)
  • public static Task<double?> AverageAsync(this IQueryable<int?> source, CancellationToken token = default)
  • public static Task<double> AverageAsync(this IQueryable<long> source, CancellationToken token = default)
  • public static Task<double?> AverageAsync(this IQueryable<long?> source, CancellationToken token = default)
  • public static Task<float> AverageAsync(this IQueryable<float> source, CancellationToken token = default)
  • public static Task<float?> AverageAsync(this IQueryable<float?> source, CancellationToken token = default)
  • public static Task<double> AverageAsync(this IQueryable<double> source, CancellationToken token = default)
  • public static Task<double?> AverageAsync(this IQueryable<double?> source, CancellationToken token = default)
  • public static Task<decimal> AverageAsync(this IQueryable<decimal> source, CancellationToken token = default)
  • public static Task<decimal?> AverageAsync(this IQueryable<decimal?> source, CancellationToken token = default)
  • public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, int>> selector, CancellationToken token = default)
  • public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, int?>> selector, CancellationToken token = default)
  • public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, long>> selector, CancellationToken token = default)
  • public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, long?>> selector, CancellationToken token = default)
  • public static Task<float> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, float>> selector, CancellationToken token = default)
  • public static Task<float?> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, float?>> selector, CancellationToken token = default)
  • public static Task<double> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, double>> selector, CancellationToken token = default)
  • public static Task<double?> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, double?>> selector, CancellationToken token = default)
  • public static Task<decimal> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, decimal>> selector, CancellationToken token = default)
  • public static Task<decimal?> AverageAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, decimal?>> selector, CancellationToken token = default)
  • public static Task<bool> ContainsAsync<TSource>(this IQueryable<TSource> source, TSource item, CancellationToken token = default)
  • public static Task<int> CountAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<int> CountAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TSource> FirstAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<TSource> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TSource> FirstOrDefaultAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task ForEachAsync<TSource>(this IQueryable<TSource> source, Action<TSource> action, CancellationToken token = default)
  • public static Task ForEachUntilAsync<TSource>(this IQueryable<TSource> source, Func<TSource, bool> func, CancellationToken token = default)
  • public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<long> LongCountAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<TSource> MaxAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TResult> MaxAsync<TSource, TResult>(this IQueryable<TSource> source, Expression<Func<TSource, TResult>> selector, CancellationToken token = default)
  • public static Task<TSource> MinAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TResult> MinAsync<TSource, TResult>(this IQueryable<TSource> source, Expression<Func<TSource, TResult>> selector, CancellationToken token = default)
  • public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TSource> SingleAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<TSource> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<TSource> SingleOrDefaultAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token = default)
  • public static Task<int> SumAsync(this IQueryable<int> source, CancellationToken token = default)
  • public static Task<int?> SumAsync(this IQueryable<int?> source, CancellationToken token = default)
  • public static Task<long> SumAsync(this IQueryable<long> source, CancellationToken token = default)
  • public static Task<long?> SumAsync(this IQueryable<long?> source, CancellationToken token = default)
  • public static Task<float> SumAsync(this IQueryable<float> source, CancellationToken token = default)
  • public static Task<float?> SumAsync(this IQueryable<float?> source, CancellationToken token = default)
  • public static Task<double> SumAsync(this IQueryable<double> source, CancellationToken token = default)
  • public static Task<double?> SumAsync(this IQueryable<double?> source, CancellationToken token = default)
  • public static Task<decimal> SumAsync(this IQueryable<decimal> source, CancellationToken token = default)
  • public static Task<decimal?> SumAsync(this IQueryable<decimal?> source, CancellationToken token = default)
  • public static Task<int> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, int>> selector, CancellationToken token = default)
  • public static Task<int?> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, int?>> selector, CancellationToken token = default)
  • public static Task<long> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, long>> selector, CancellationToken token = default)
  • public static Task<long?> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, long?>> selector, CancellationToken token = default)
  • public static Task<float> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, float>> selector, CancellationToken token = default)
  • public static Task<float?> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, float?>> selector, CancellationToken token = default)
  • public static Task<double> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, double>> selector, CancellationToken token = default)
  • public static Task<double?> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, double?>> selector, CancellationToken token = default)
  • public static Task<decimal> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, decimal>> selector, CancellationToken token = default)
  • public static Task<decimal?> SumAsync<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, decimal?>> selector, CancellationToken token = default)
  • public static Task<TSource[]> ToArrayAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
  • public static Task<Dictionary<TKey, TSource>> ToDictionaryAsync<TSource, TKey>(this IQueryable<TSource> source, Func<TSource, TKey> keySelector, CancellationToken token = default)
  • public static Task<Dictionary<TKey, TSource>> ToDictionaryAsync<TSource, TKey>(this IQueryable<TSource> source, Func<TSource, TKey> keySelector, IEqualityComparer<TKey> comparer, CancellationToken token = default)
  • public static Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TSource, TKey, TElement>(this IQueryable<TSource> source, Func<TSource, TKey> keySelector, Func<TSource, TElement> elementSelector, CancellationToken token = default)
  • public static Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TSource, TKey, TElement>(this IQueryable<TSource> source, Func<TSource, TKey> keySelector, Func<TSource, TElement> elementSelector, IEqualityComparer<TKey> comparer, CancellationToken token = default)
  • public static Task<List<TSource>> ToListAsync<TSource>(this IQueryable<TSource> source, CancellationToken token = default)
• public class CompiledQuery
  • protected CompiledQuery(LambdaExpression query)
  • public static Func<TDC, TResult> Compile<TDC, TResult>(Expression<Func<TDC, TResult>> query) where TDC : IDataContext
  • public static Func<TDC, TArg1, TResult> Compile<TDC, TArg1, TResult>(Expression<Func<TDC, TArg1, TResult>> query) where TDC : IDataContext
  • public static Func<TDC, TArg1, TArg2, TResult> Compile<TDC, TArg1, TArg2, TResult>(Expression<Func<TDC, TArg1, TArg2, TResult>> query) where TDC : IDataContext
  • public static Func<TDC, TArg1, TArg2, TArg3, TResult> Compile<TDC, TArg1, TArg2, TArg3, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TResult>> query) where TDC : IDataContext
  • public static Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult> Compile<TDC, TArg1, TArg2, TArg3, TArg4, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult>> query) where TDC : IDataContext
  • public static Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult> Compile<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>> query) where TDC : IDataContext
  • public TResult Invoke<TDC, TResult>(TDC dataContext)
  • public TResult Invoke<TDC, T1, TResult>(TDC dataContext, T1 arg1)
  • public TResult Invoke<TDC, T1, T2, TResult>(TDC dataContext, T1 arg1, T2 arg2)
  • public TResult Invoke<TDC, T1, T2, T3, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3)
  • public TResult Invoke<TDC, T1, T2, T3, T4, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3, T4 arg4)
  • public TResult Invoke<TDC, T1, T2, T3, T4, T5, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5)
• public class DataContext : IDataContext, IEntityServices, IDisposable
  • public bool CloseAfterUse { get; set; }
  • public int CommandTimeout { get; set; }
  • public string ConfigurationString { get; }
  • public string ConnectionString { get; }
  • public string ContextID { get; set; }
  • public IDataProvider DataProvider { get; }
  • public bool InlineParameters { get; set; }
  • public bool IsMarsEnabled { get; set; }
  • public bool KeepConnectionAlive { get; set; }
  • public string LastQuery { get; set; }
  • public MappingSchema MappingSchema { get; set; }
  • public List<string> NextQueryHints { get; }
  • public Action<EntityCreatedEventArgs> OnEntityCreated { get; set; }
  • public Action<TraceInfo> OnTraceConnection { get; set; }
  • public List<string> QueryHints { get; }
  • public event EventHandler OnClosing
  • public DataContext()
  • public DataContext(string configurationString)
  • public DataContext(IDataProvider dataProvider, string connectionString)
  • public DataContext(string providerName, string connectionString)
  • public virtual DataContextTransaction BeginTransaction(IsolationLevel level)
  • public virtual DataContextTransaction BeginTransaction(bool autoCommitOnDispose = true)
  • public virtual Task<DataContextTransaction> BeginTransactionAsync(IsolationLevel level, CancellationToken cancellationToken = default)
  • public virtual Task<DataContextTransaction> BeginTransactionAsync(bool autoCommitOnDispose = true, CancellationToken cancellationToken = default)
• public class DataContextTransaction : IDisposable
  • public DataContext DataContext { get; set; }
  • public DataContextTransaction(DataContext dataContext)
  • public void BeginTransaction()
  • public void BeginTransaction(IsolationLevel level)
  • public Task BeginTransactionAsync(CancellationToken cancellationToken = default)
  • public Task BeginTransactionAsync(IsolationLevel level, CancellationToken cancellationToken = default)
  • public void CommitTransaction()
  • public Task CommitTransactionAsync(CancellationToken cancellationToken = default)
  • public void Dispose()
  • public void RollbackTransaction()
  • public Task RollbackTransactionAsync(CancellationToken cancellationToken = default)
• public static class DataExtensions
  • public class SqlFormattableComparerAttribute : SqlQueryDependentAttribute
  • public static MethodInfo SelectQueryMethodInfo
  • public static Func<TDc, TResult> Compile<TDc, TResult>(this IDataContext dataContext, Expression<Func<TDc, TResult>> query) where TDc : IDataContext
  • public static Func<TDc, TArg1, TResult> Compile<TDc, TArg1, TResult>(this IDataContext dataContext, Expression<Func<TDc, TArg1, TResult>> query) where TDc : IDataContext
  • public static Func<TDc, TArg1, TArg2, TResult> Compile<TDc, TArg1, TArg2, TResult>(this IDataContext dataContext, Expression<Func<TDc, TArg1, TArg2, TResult>> query) where TDc : IDataContext
  • public static Func<TDc, TArg1, TArg2, TArg3, TResult> Compile<TDc, TArg1, TArg2, TArg3, TResult>(this IDataContext dataContext, Expression<Func<TDc, TArg1, TArg2, TArg3, TResult>> query) where TDc : IDataContext
  • public static ITable<T> CreateTable<T>(this IDataContext dataContext, string tableName = null, string databaseName = null, string schemaName = null, string statementHeader = null, string statementFooter = null, DefaultNullable defaultNullable = 0)
  • public static Task<ITable<T>> CreateTableAsync<T>(this IDataContext dataContext, string tableName = null, string databaseName = null, string schemaName = null, string statementHeader = null, string statementFooter = null, DefaultNullable defaultNullable = 0, CancellationToken token = default)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, string tableName = null, string databaseName = null, string schemaName = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, IEnumerable<T> items, BulkCopyOptions options = null, string tableName = null, string databaseName = null, string schemaName = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, string tableName, IEnumerable<T> items, BulkCopyOptions options = null, string databaseName = null, string schemaName = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, IQueryable<T> items, string tableName = null, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, IQueryable<T> items, Action<EntityMappingBuilder<T>> setTable, string tableName = null, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, string tableName, IQueryable<T> items, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public static TempTable<T> CreateTempTable<T>(this IDataContext db, string tableName, IQueryable<T> items, Action<EntityMappingBuilder<T>> setTable, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public static int Delete<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> DeleteAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static void DropTable<T>(this IDataContext dataContext, string tableName = null, string databaseName = null, string schemaName = null, bool throwExceptionIfNotExists = true)
  • public static void DropTable<T>(this ITable<T> table, string tableName = null, string databaseName = null, string schemaName = null, bool throwExceptionIfNotExists = true)
  • public static Task DropTableAsync<T>(this IDataContext dataContext, string tableName = null, string databaseName = null, string schemaName = null, bool throwExceptionIfNotExists = true, CancellationToken token = default)
  • public static Task DropTableAsync<T>(this ITable<T> table, string tableName = null, string databaseName = null, string schemaName = null, bool throwExceptionIfNotExists = true, CancellationToken token = default)
  • public static IQueryable<TEntity> FromSql<TEntity>(this IDataContext dataContext, FormattableString sql)
  • public static IQueryable<TEntity> FromSql<TEntity>(this IDataContext dataContext, RawSqlString sql, object[] parameters)
  • public static IQueryable<T> GetCte<T>(this IDataContext dataContext, Func<IQueryable<T>, IQueryable<T>> cteBody, string cteTableName = null)
  • public static IQueryable<T> GetCte<T>(this IDataContext dataContext, string cteTableName, Func<IQueryable<T>, IQueryable<T>> cteBody)
  • public static ITable<T> GetTable<T>(this IDataContext dataContext)
  • public static ITable<T> GetTable<T>(this IDataContext dataContext, object instance, MethodInfo methodInfo, object[] parameters)
  • public static int Insert<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> InsertAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static int InsertOrReplace<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> InsertOrReplaceAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static decimal InsertWithDecimalIdentity<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<decimal> InsertWithDecimalIdentityAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static object InsertWithIdentity<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<object> InsertWithIdentityAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static int InsertWithInt32Identity<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> InsertWithInt32IdentityAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static long InsertWithInt64Identity<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<long> InsertWithInt64IdentityAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
  • public static IQueryable<TEntity> SelectQuery<TEntity>(this IDataContext dataContext, Expression<Func<TEntity>> selector)
  • public static int Update<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> UpdateAsync<T>(this IDataContext dataContext, T obj, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken token = default)
• public enum DataType
  • Binary = 7
  • BinaryJson = 41
  • BitArray = 37
  • Blob = 9
  • Boolean = 11
  • Byte = 17
  • Char = 1
  • Cursor = 39
  • Date = 26
  • DateTime = 28
  • DateTime2 = 29
  • DateTimeOffset = 31
  • Decimal = 23
  • Dictionary = 38
  • Double = 22
  • Guid = 12
  • Image = 10
  • Int16 = 14
  • Int32 = 15
  • Int64 = 16
  • Json = 40
  • Long = 43
  • LongRaw = 44
  • Money = 24
  • NChar = 4
  • NText = 6
  • NVarChar = 5
  • SByte = 13
  • Single = 21
  • SmallDateTime = 30
  • SmallMoney = 25
  • Structured = 42
  • Text = 3
  • Time = 27
  • Timestamp = 32
  • Udt = 36
  • UInt16 = 18
  • UInt32 = 19
  • UInt64 = 20
  • Undefined = 0
  • VarBinary = 8
  • VarChar = 2
  • Variant = 34
  • VarNumeric = 35
  • Xml = 33
• public class EntityCreatedEventArgs
  • public IDataContext DataContext { get; set; }
  • public object Entity { get; set; }
  • public EntityCreatedEventArgs()
• public class ExpressionMethodAttribute : Attribute
  • public string Alias { get; set; }
  • public string Configuration { get; set; }
  • public LambdaExpression Expression { get; set; }
  • public bool IsColumn { get; set; }
  • public string MethodName { get; set; }
  • public ExpressionMethodAttribute(string methodName)
  • public ExpressionMethodAttribute(LambdaExpression expression)
  • public ExpressionMethodAttribute(string configuration, string methodName)
• public class ExprParameterAttribute : Attribute
  • public string Name { get; set; }
  • public ExprParameterAttribute(string name)
  • public ExprParameterAttribute()
• public static class ExtensionlBuilderExtensions
  • public static ISqlExpression Add(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right, Type type)
  • public static ISqlExpression Add<T>(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right)
  • public static ISqlExpression Add(this ISqExtensionBuilder builder, ISqlExpression left, int value)
  • public static SqlExtensionParam AddExpression(this ISqExtensionBuilder builder, string name, string expr)
  • public static SqlExtensionParam AddParameter(this ISqExtensionBuilder builder, string name, string value)
  • public static ISqlExpression Dec(this ISqExtensionBuilder builder, ISqlExpression expr)
  • public static ISqlExpression Div(this ISqExtensionBuilder builder, ISqlExpression expr1, ISqlExpression expr2, Type type)
  • public static ISqlExpression Div<T>(this ISqExtensionBuilder builder, ISqlExpression expr1, ISqlExpression expr2)
  • public static ISqlExpression Div(this ISqExtensionBuilder builder, ISqlExpression expr1, int value)
  • public static ISqlExpression Inc(this ISqExtensionBuilder builder, ISqlExpression expr)
  • public static ISqlExpression Mul(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right, Type type)
  • public static ISqlExpression Mul<T>(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right)
  • public static ISqlExpression Mul(this ISqExtensionBuilder builder, ISqlExpression expr1, int value)
  • public static ISqlExpression Sub(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right, Type type)
  • public static ISqlExpression Sub<T>(this ISqExtensionBuilder builder, ISqlExpression left, ISqlExpression right)
  • public static ISqlExpression Sub(this ISqExtensionBuilder builder, ISqlExpression left, int value)
• public interface IDataContext : IEntityServices, IDisposable
  • bool CloseAfterUse { get; set; }
  • string ContextID { get; }
  • Func<ISqlBuilder> CreateSqlProvider { get; }
  • Type DataReaderType { get; }
  • Func<ISqlOptimizer> GetSqlOptimizer { get; }
  • bool InlineParameters { get; set; }
  • MappingSchema MappingSchema { get; }
  • List<string> NextQueryHints { get; }
  • List<string> QueryHints { get; }
  • SqlProviderFlags SqlProviderFlags { get; }
  • event EventHandler OnClosing
  • IDataContext Clone(bool forNestedQuery)
  • void Close()
  • IQueryRunner GetQueryRunner(Query query, int queryNumber, Expression expression, object[] parameters)
  • Expression GetReaderExpression(MappingSchema mappingSchema, IDataReader reader, int idx, Expression readerExpression, Type toType)
  • bool? IsDBNullAllowed(IDataReader reader, int idx)
• public interface IEntityServices
  • Action<EntityCreatedEventArgs> OnEntityCreated { get; set; }
• public interface IExtensionsAdapter
  • Task<bool> AllAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<bool> AnyAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<bool> AnyAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<double> AverageAsync(IQueryable<int> source, CancellationToken token)
  • Task<double?> AverageAsync(IQueryable<int?> source, CancellationToken token)
  • Task<double> AverageAsync(IQueryable<long> source, CancellationToken token)
  • Task<double?> AverageAsync(IQueryable<long?> source, CancellationToken token)
  • Task<float> AverageAsync(IQueryable<float> source, CancellationToken token)
  • Task<float?> AverageAsync(IQueryable<float?> source, CancellationToken token)
  • Task<double> AverageAsync(IQueryable<double> source, CancellationToken token)
  • Task<double?> AverageAsync(IQueryable<double?> source, CancellationToken token)
  • Task<decimal> AverageAsync(IQueryable<decimal> source, CancellationToken token)
  • Task<decimal?> AverageAsync(IQueryable<decimal?> source, CancellationToken token)
  • Task<double> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, int>> selector, CancellationToken token)
  • Task<double?> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, int?>> selector, CancellationToken token)
  • Task<double> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, long>> selector, CancellationToken token)
  • Task<double?> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, long?>> selector, CancellationToken token)
  • Task<float> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, float>> selector, CancellationToken token)
  • Task<float?> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, float?>> selector, CancellationToken token)
  • Task<double> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, double>> selector, CancellationToken token)
  • Task<double?> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, double?>> selector, CancellationToken token)
  • Task<decimal> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, decimal>> selector, CancellationToken token)
  • Task<decimal?> AverageAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, decimal?>> selector, CancellationToken token)
  • Task<bool> ContainsAsync<TSource>(IQueryable<TSource> source, TSource item, CancellationToken token)
  • Task<int> CountAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<int> CountAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<TSource> FirstAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TSource> FirstAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<TSource> FirstOrDefaultAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TSource> FirstOrDefaultAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task ForEachAsync<TSource>(IQueryable<TSource> source, Action<TSource> action, CancellationToken token)
  • Task<long> LongCountAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<long> LongCountAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<TSource> MaxAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TResult> MaxAsync<TSource, TResult>(IQueryable<TSource> source, Expression<Func<TSource, TResult>> selector, CancellationToken token)
  • Task<TSource> MinAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TResult> MinAsync<TSource, TResult>(IQueryable<TSource> source, Expression<Func<TSource, TResult>> selector, CancellationToken token)
  • Task<TSource> SingleAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TSource> SingleAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<TSource> SingleOrDefaultAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<TSource> SingleOrDefaultAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate, CancellationToken token)
  • Task<int> SumAsync(IQueryable<int> source, CancellationToken token)
  • Task<int?> SumAsync(IQueryable<int?> source, CancellationToken token)
  • Task<long> SumAsync(IQueryable<long> source, CancellationToken token)
  • Task<long?> SumAsync(IQueryable<long?> source, CancellationToken token)
  • Task<float> SumAsync(IQueryable<float> source, CancellationToken token)
  • Task<float?> SumAsync(IQueryable<float?> source, CancellationToken token)
  • Task<double> SumAsync(IQueryable<double> source, CancellationToken token)
  • Task<double?> SumAsync(IQueryable<double?> source, CancellationToken token)
  • Task<decimal> SumAsync(IQueryable<decimal> source, CancellationToken token)
  • Task<decimal?> SumAsync(IQueryable<decimal?> source, CancellationToken token)
  • Task<int> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, int>> selector, CancellationToken token)
  • Task<int?> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, int?>> selector, CancellationToken token)
  • Task<long> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, long>> selector, CancellationToken token)
  • Task<long?> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, long?>> selector, CancellationToken token)
  • Task<float> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, float>> selector, CancellationToken token)
  • Task<float?> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, float?>> selector, CancellationToken token)
  • Task<double> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, double>> selector, CancellationToken token)
  • Task<double?> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, double?>> selector, CancellationToken token)
  • Task<decimal> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, decimal>> selector, CancellationToken token)
  • Task<decimal?> SumAsync<TSource>(IQueryable<TSource> source, Expression<Func<TSource, decimal?>> selector, CancellationToken token)
  • Task<TSource[]> ToArrayAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
  • Task<Dictionary<TKey, TSource>> ToDictionaryAsync<TSource, TKey>(IQueryable<TSource> source, Func<TSource, TKey> keySelector, CancellationToken token)
  • Task<Dictionary<TKey, TSource>> ToDictionaryAsync<TSource, TKey>(IQueryable<TSource> source, Func<TSource, TKey> keySelector, IEqualityComparer<TKey> comparer, CancellationToken token)
  • Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TSource, TKey, TElement>(IQueryable<TSource> source, Func<TSource, TKey> keySelector, Func<TSource, TElement> elementSelector, CancellationToken token)
  • Task<Dictionary<TKey, TElement>> ToDictionaryAsync<TSource, TKey, TElement>(IQueryable<TSource> source, Func<TSource, TKey> keySelector, Func<TSource, TElement> elementSelector, IEqualityComparer<TKey> comparer, CancellationToken token)
  • Task<List<TSource>> ToListAsync<TSource>(IQueryable<TSource> source, CancellationToken token)
• public interface IMergeable<TTarget, TSource> : IMergeableSource<TTarget, TSource>
• public interface IMergeableOn<TTarget, TSource>
• public interface IMergeableSource<TTarget, TSource>
• public interface IMergeableUsing<TTarget>
• public interface ITable<T> : IExpressionQuery<T>, IOrderedQueryable<T>, IEnumerable<T>, IEnumerable, IOrderedQueryable, IQueryable, IQueryable<T>, IQueryProviderAsync, IQueryProvider, IExpressionQuery
  • string DatabaseName { get; }
  • string SchemaName { get; }
  • string TableName { get; }
  • string GetTableName()
• public interface ITableMutable<T>
  • ITable<T> ChangeDatabaseName(string databaseName)
  • ITable<T> ChangeSchemaName(string schemaName)
  • ITable<T> ChangeTableName(string tableName)
• public class KeepConnectionAliveScope : IDisposable
  • public KeepConnectionAliveScope(DataContext dataContext)
  • public void Dispose()
• public static class LinqExtensions
  • public static IExtensionsAdapter ExtensionsAdapter { get; set; }
  • public static Func<IQueryable, IQueryable> ProcessSourceQueryable { get; set; }
  • public static IQueryable<TSource> AsCte<TSource>(this IQueryable<TSource> source)
  • public static IQueryable<TSource> AsCte<TSource>(this IQueryable<TSource> source, string name)
  • public static IQueryable<TElement> AsQueryable<TElement>(this IEnumerable<TElement> source, IDataContext dataContext)
  • public static IQueryable<TSource> AsSubQuery<TSource>(this IQueryable<TSource> source)
  • public static IUpdatable<T> AsUpdatable<T>(this IQueryable<T> source)
  • public static IQueryable<TResult> CrossJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static ITable<T> DatabaseName<T>(this ITable<T> table, string name)
  • public static int Delete<T>(this IQueryable<T> source)
  • public static int Delete<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate)
  • public static Task<int> DeleteAsync<T>(this IQueryable<T> source, CancellationToken token = default)
  • public static Task<int> DeleteAsync<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, CancellationToken token = default)
  • public static int Drop<T>(this ITable<T> target, bool throwExceptionIfNotExists = true)
  • public static Task<int> DropAsync<T>(this ITable<T> target, bool throwExceptionIfNotExists = true, CancellationToken token = default)
  • public static TSource ElementAt<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index)
  • public static Task<TSource> ElementAtAsync<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index, CancellationToken token = default)
  • public static TSource ElementAtOrDefault<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index)
  • public static Task<TSource> ElementAtOrDefaultAsync<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index, CancellationToken token = default)
  • public static IQueryable<TSource> ExceptAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)
  • public static IQueryable<TSource> FullJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TResult> FullJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static string GenerateTestString(this IQueryable query, bool mangleNames = false)
  • public static IQueryable<TSource> HasUniqueKey<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)
  • public static IQueryable<TSource> Having<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TSource> InnerJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TResult> InnerJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static int Insert<T>(this ITable<T> target, Expression<Func<T>> setter)
  • public static int Insert<T>(this IValueInsertable<T> source)
  • public static int Insert<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static int Insert<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)
  • public static Task<int> InsertAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default)
  • public static Task<int> InsertAsync<T>(this IValueInsertable<T> source, CancellationToken token = default)
  • public static Task<int> InsertAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<int> InsertAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default)
  • public static int InsertOrUpdate<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter)
  • public static int InsertOrUpdate<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, Expression<Func<T>> keySelector)
  • public static Task<int> InsertOrUpdateAsync<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, CancellationToken token = default)
  • public static Task<int> InsertOrUpdateAsync<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, Expression<Func<T>> keySelector, CancellationToken token = default)
  • public static decimal InsertWithDecimalIdentity<T>(this ITable<T> target, Expression<Func<T>> setter)
  • public static decimal? InsertWithDecimalIdentity<T>(this IValueInsertable<T> source)
  • public static decimal? InsertWithDecimalIdentity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static decimal? InsertWithDecimalIdentity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)
  • public static Task<decimal> InsertWithDecimalIdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default)
  • public static Task<decimal?> InsertWithDecimalIdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default)
  • public static Task<decimal?> InsertWithDecimalIdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<decimal?> InsertWithDecimalIdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default)
  • public static object InsertWithIdentity<T>(this ITable<T> target, Expression<Func<T>> setter)
  • public static object InsertWithIdentity<T>(this IValueInsertable<T> source)
  • public static object InsertWithIdentity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static object InsertWithIdentity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)
  • public static Task<object> InsertWithIdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default)
  • public static Task<object> InsertWithIdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default)
  • public static Task<object> InsertWithIdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<object> InsertWithIdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default)
  • public static int InsertWithInt32Identity<T>(this ITable<T> target, Expression<Func<T>> setter)
  • public static int? InsertWithInt32Identity<T>(this IValueInsertable<T> source)
  • public static int? InsertWithInt32Identity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static int? InsertWithInt32Identity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)
  • public static Task<int> InsertWithInt32IdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default)
  • public static Task<int?> InsertWithInt32IdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default)
  • public static Task<int?> InsertWithInt32IdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<int?> InsertWithInt32IdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default)
  • public static long InsertWithInt64Identity<T>(this ITable<T> target, Expression<Func<T>> setter)
  • public static long? InsertWithInt64Identity<T>(this IValueInsertable<T> source)
  • public static long? InsertWithInt64Identity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static long? InsertWithInt64Identity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)
  • public static Task<long> InsertWithInt64IdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default)
  • public static Task<long?> InsertWithInt64IdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default)
  • public static Task<long?> InsertWithInt64IdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<long?> InsertWithInt64IdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default)
  • public static IQueryable<TSource> IntersectAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)
  • public static IValueInsertable<T> Into<T>(this IDataContext dataContext, ITable<T> target)
  • public static ISelectInsertable<TSource, TTarget> Into<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target)
  • public static IQueryable<TSource> Join<TSource>(this IQueryable<TSource> source, SqlJoinType joinType, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TResult> Join<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, SqlJoinType joinType, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static IQueryable<TSource> LeftJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TResult> LeftJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static ITable<T> LoadWith<T>(this ITable<T> table, Expression<Func<T, object>> selector)
  • public static ITable<T> OwnerName<T>(this ITable<T> table, string name)
  • public static IQueryable<TSource> RightJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)
  • public static IQueryable<TResult> RightJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)
  • public static ITable<T> SchemaName<T>(this ITable<T> table, string name)
  • public static T Select<T>(this IDataContext dataContext, Expression<Func<T>> selector)
  • public static Task<T> SelectAsync<T>(this IDataContext dataContext, Expression<Func<T>> selector)
  • public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, Expression<Func<T, TV>> update)
  • public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, Expression<Func<T, TV>> update)
  • public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, Expression<Func<TV>> update)
  • public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, Expression<Func<TV>> update)
  • public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, TV value)
  • public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, TV value)
  • public static IQueryable<TSource> Skip<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count)
  • public static ITable<T> TableName<T>(this ITable<T> table, string name)
  • public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count)
  • public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count, TakeHints hints)
  • public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, int count, TakeHints hints)
  • public static IOrderedQueryable<TSource> ThenOrBy<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)
  • public static IOrderedQueryable<TSource> ThenOrByDescending<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)
  • public static int Truncate<T>(this ITable<T> target, bool resetIdentity = true)
  • public static Task<int> TruncateAsync<T>(this ITable<T> target, bool resetIdentity = true, CancellationToken token = default)
  • public static IQueryable<TSource> UnionAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)
  • public static int Update<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)
  • public static int Update<T>(this IQueryable<T> source, Expression<Func<T, T>> setter)
  • public static int Update<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, Expression<Func<T, T>> setter)
  • public static int Update<T>(this IUpdatable<T> source)
  • public static int Update<TSource, TTarget>(this IQueryable<TSource> source, Expression<Func<TSource, TTarget>> target, Expression<Func<TSource, TTarget>> setter)
  • public static Task<int> UpdateAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static Task<int> UpdateAsync<T>(this IQueryable<T> source, Expression<Func<T, T>> setter, CancellationToken token = default)
  • public static Task<int> UpdateAsync<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, Expression<Func<T, T>> setter, CancellationToken token = default)
  • public static Task<int> UpdateAsync<T>(this IUpdatable<T> source, CancellationToken token = default)
  • public static Task<int> UpdateAsync<TSource, TTarget>(this IQueryable<TSource> source, Expression<Func<TSource, TTarget>> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default)
  • public static IValueInsertable<T> Value<T, TV>(this ITable<T> source, Expression<Func<T, TV>> field, Expression<Func<TV>> value)
  • public static IValueInsertable<T> Value<T, TV>(this ITable<T> source, Expression<Func<T, TV>> field, TV value)
  • public static IValueInsertable<T> Value<T, TV>(this IValueInsertable<T> source, Expression<Func<T, TV>> field, Expression<Func<TV>> value)
  • public static IValueInsertable<T> Value<T, TV>(this IValueInsertable<T> source, Expression<Func<T, TV>> field, TV value)
  • public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, Expression<Func<TSource, TValue>> value)
  • public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, Expression<Func<TValue>> value)
  • public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, TValue value)
  • public static ITable<T> With<T>(this ITable<T> table, string args)
  • public static ITable<T> WithTableExpression<T>(this ITable<T> table, string expression)
• public static class LinqToDBConstants
  • public const string Copyright = "© 2011-2020 linq2db.com"
  • public const string ProductDescription = "Linq to DB"
  • public const string ProductName = "Linq to DB"
• public class LinqToDBException : Exception
  • public LinqToDBException()
  • public LinqToDBException(string message)
  • public LinqToDBException(string message, Exception innerException)
  • public LinqToDBException(Exception innerException)
  • protected LinqToDBException(SerializationInfo info, StreamingContext context)
• public class MergeDefinition<TTarget, TSource> : IMergeableUsing<TTarget>, IMergeableOn<TTarget, TSource>, IMergeable<TTarget, TSource>, IMergeableSource<TTarget, TSource>
  • public class Operation<TTarget, TSource>
  • public IEnumerable<TSource> EnumerableSource { get; }
  • public string Hint { get; }
  • public Type KeyType { get; }
  • public Expression<Func<TTarget, TSource, bool>> MatchPredicate { get; }
  • public Operation<TTarget, TSource>[] Operations { get; }
  • public IQueryable<TSource> QueryableSource { get; }
  • public Expression SourceKey { get; }
  • public ITable<TTarget> Target { get; }
  • public Expression TargetKey { get; }
  • public MergeDefinition(ITable<TTarget> target)
  • public MergeDefinition(ITable<TTarget> target, string hint)
  • public MergeDefinition(ITable<TTarget> target, IQueryable<TSource> source)
  • public MergeDefinition(ITable<TTarget> target, IQueryable<TSource> source, string hint)
  • public MergeDefinition<TTarget, TSource> AddOnKey<TKey>(Expression<Func<TTarget, TKey>> targetKey, Expression<Func<TSource, TKey>> sourceKey)
  • public MergeDefinition<TTarget, TSource> AddOnPredicate(Expression<Func<TTarget, TSource, bool>> matchPredicate)
  • public MergeDefinition<TTarget, TSource> AddOperation(Operation<TTarget, TSource> operation)
  • public MergeDefinition<TTarget, TNewSource> AddSource<TNewSource>(IQueryable<TNewSource> source)
  • public MergeDefinition<TTarget, TNewSource> AddSource<TNewSource>(IEnumerable<TNewSource> source)
• public static class MergeExtensions
  • public static IMergeable<TTarget, TSource> DeleteWhenMatched<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge)
  • public static IMergeable<TTarget, TSource> DeleteWhenMatchedAnd<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TSource, bool>> searchCondition)
  • public static IMergeable<TTarget, TSource> DeleteWhenNotMatchedBySource<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge)
  • public static IMergeable<TTarget, TSource> DeleteWhenNotMatchedBySourceAnd<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, bool>> searchCondition)
  • public static IMergeable<TTarget, TTarget> InsertWhenNotMatched<TTarget>(this IMergeableSource<TTarget, TTarget> merge)
  • public static IMergeable<TTarget, TSource> InsertWhenNotMatched<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TSource, TTarget>> setter)
  • public static IMergeable<TTarget, TTarget> InsertWhenNotMatchedAnd<TTarget>(this IMergeableSource<TTarget, TTarget> merge, Expression<Func<TTarget, bool>> searchCondition)
  • public static IMergeable<TTarget, TSource> InsertWhenNotMatchedAnd<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TSource, bool>> searchCondition, Expression<Func<TSource, TTarget>> setter)
  • public static IMergeableUsing<TTarget> Merge<TTarget>(this ITable<TTarget> target)
  • public static IMergeableUsing<TTarget> Merge<TTarget>(this ITable<TTarget> target, string hint)
  • public static int Merge<TTarget, TSource>(this IMergeable<TTarget, TSource> merge)
  • public static Task<int> MergeAsync<TTarget, TSource>(this IMergeable<TTarget, TSource> merge, CancellationToken token = default)
  • public static IMergeableOn<TTarget, TSource> MergeInto<TTarget, TSource>(this IQueryable<TSource> source, ITable<TTarget> target)
  • public static IMergeableOn<TTarget, TSource> MergeInto<TTarget, TSource>(this IQueryable<TSource> source, ITable<TTarget> target, string hint)
  • public static IMergeableSource<TTarget, TSource> On<TTarget, TSource, TKey>(this IMergeableOn<TTarget, TSource> merge, Expression<Func<TTarget, TKey>> targetKey, Expression<Func<TSource, TKey>> sourceKey)
  • public static IMergeableSource<TTarget, TSource> On<TTarget, TSource>(this IMergeableOn<TTarget, TSource> merge, Expression<Func<TTarget, TSource, bool>> matchCondition)
  • public static IMergeableSource<TTarget, TTarget> OnTargetKey<TTarget>(this IMergeableOn<TTarget, TTarget> merge)
  • public static IMergeable<TTarget, TTarget> UpdateWhenMatched<TTarget>(this IMergeableSource<TTarget, TTarget> merge)
  • public static IMergeable<TTarget, TSource> UpdateWhenMatched<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TSource, TTarget>> setter)
  • public static IMergeable<TTarget, TTarget> UpdateWhenMatchedAnd<TTarget>(this IMergeableSource<TTarget, TTarget> merge, Expression<Func<TTarget, TTarget, bool>> searchCondition)
  • public static IMergeable<TTarget, TSource> UpdateWhenMatchedAnd<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TSource, bool>> searchCondition, Expression<Func<TTarget, TSource, TTarget>> setter)
  • public static IMergeable<TTarget, TTarget> UpdateWhenMatchedAndThenDelete<TTarget>(this IMergeableSource<TTarget, TTarget> merge, Expression<Func<TTarget, TTarget, bool>> searchCondition, Expression<Func<TTarget, TTarget, bool>> deleteCondition)
  • public static IMergeable<TTarget, TSource> UpdateWhenMatchedAndThenDelete<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TSource, bool>> searchCondition, Expression<Func<TTarget, TSource, TTarget>> setter, Expression<Func<TTarget, TSource, bool>> deleteCondition)
  • public static IMergeable<TTarget, TTarget> UpdateWhenMatchedThenDelete<TTarget>(this IMergeableSource<TTarget, TTarget> merge, Expression<Func<TTarget, TTarget, bool>> deleteCondition)
  • public static IMergeable<TTarget, TSource> UpdateWhenMatchedThenDelete<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TSource, TTarget>> setter, Expression<Func<TTarget, TSource, bool>> deleteCondition)
  • public static IMergeable<TTarget, TSource> UpdateWhenNotMatchedBySource<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, TTarget>> setter)
  • public static IMergeable<TTarget, TSource> UpdateWhenNotMatchedBySourceAnd<TTarget, TSource>(this IMergeableSource<TTarget, TSource> merge, Expression<Func<TTarget, bool>> searchCondition, Expression<Func<TTarget, TTarget>> setter)
  • public static IMergeableOn<TTarget, TSource> Using<TTarget, TSource>(this IMergeableUsing<TTarget> merge, IQueryable<TSource> source)
  • public static IMergeableOn<TTarget, TSource> Using<TTarget, TSource>(this IMergeableUsing<TTarget> merge, IEnumerable<TSource> source)
  • public static IMergeableOn<TTarget, TTarget> UsingTarget<TTarget>(this IMergeableUsing<TTarget> merge)
• public enum MergeOperationType
  • Delete = 2
  • DeleteBySource = 5
  • Insert = 0
  • Update = 1
  • UpdateBySource = 4
  • UpdateWithDelete = 3
• public static class ProviderName
  • public const string Access = "Access"
  • public const string DB2 = "DB2"
  • public const string DB2LUW = "DB2.LUW"
  • public const string DB2zOS = "DB2.z/OS"
  • public const string Firebird = "Firebird"
  • public const string Informix = "Informix"
  • public const string MySql = "MySql"
  • public const string MySqlConnector = "MySqlConnector"
  • public const string MySqlOfficial = "MySql.Official"
  • public const string Oracle = "Oracle"
  • public const string OracleManaged = "Oracle.Managed"
  • public const string OracleNative = "Oracle.Native"
  • public const string PostgreSQL = "PostgreSQL"
  • public const string PostgreSQL92 = "PostgreSQL.9.2"
  • public const string PostgreSQL93 = "PostgreSQL.9.3"
  • public const string PostgreSQL95 = "PostgreSQL.9.5"
  • public const string SapHana = "SapHana"
  • public const string SqlCe = "SqlCe"
  • public const string SQLite = "SQLite"
  • public const string SQLiteClassic = "SQLite.Classic"
  • public const string SQLiteMS = "SQLite.MS"
  • public const string SqlServer = "SqlServer"
  • public const string SqlServer2000 = "SqlServer.2000"
  • public const string SqlServer2005 = "SqlServer.2005"
  • public const string SqlServer2008 = "SqlServer.2008"
  • public const string SqlServer2012 = "SqlServer.2012"
  • public const string SqlServer2014 = "SqlServer.2014"
  • public const string SqlServer2017 = "SqlServer.2017"
  • public const string Sybase = "Sybase"
  • public const string SybaseManaged = "Sybase.Managed"
• public static class Sql
  • public enum AggregateModifier
  • public static class ConvertTo<TTo>
  • public enum DateParts
  • public class EnumAttribute : Attribute
  • public class ExpressionAttribute : Attribute
  • public class ExtensionAttribute : ExpressionAttribute
  • public enum From
  • public class FunctionAttribute : ExpressionAttribute
  • public enum GroupBy
  • public interface IExtensionCallBuilder
  • public interface IQueryableContainer
  • public enum IsNullableType
  • public interface ISqExtensionBuilder
  • public interface ISqlExtension
  • public interface IStringAggregate<T> : IQueryableContainer
  • public interface IStringAggregateNotOrdered<T> : IStringAggregate<T>, IQueryableContainer
  • public interface IStringAggregateOrdered<T> : IStringAggregate<T>, IQueryableContainer
  • public enum Nulls
  • public enum NullsPosition
  • public class PropertyAttribute : ExpressionAttribute
  • public class SqlExtension
  • public class SqlExtensionParam
  • public class TableExpressionAttribute : TableFunctionAttribute
  • public class TableFunctionAttribute : Attribute
  • public enum TableQualification
  • public static long BigInt { get; }
  • public static bool Bit { get; }
  • public static DateTime CurrentTimestamp { get; }
  • public static DateTime CurrentTimestamp2 { get; }
  • public static DateTime CurrentTimestampUtc { get; }
  • public static DateTime Date { get; }
  • public static int DateFirst { get; }
  • public static DateTime DateTime { get; }
  • public static DateTime DateTime2 { get; }
  • public static DateTimeOffset DateTimeOffset { get; }
  • public static string DefaultChar { get; }
  • public static decimal DefaultDecimal { get; }
  • public static string DefaultNChar { get; }
  • public static string DefaultNVarChar { get; }
  • public static string DefaultVarChar { get; }
  • public static ISqlExtension Ext { get; }
  • public static double Float { get; }
  • public static int Int { get; }
  • public static decimal Money { get; }
  • public static float Real { get; }
  • public static DateTime SmallDateTime { get; }
  • public static short SmallInt { get; }
  • public static decimal SmallMoney { get; }
  • public static DateTime Time { get; }
  • public static byte TinyInt { get; }
  • public static decimal? Abs(decimal? value)
  • public static double? Abs(double? value)
  • public static short? Abs(short? value)
  • public static int? Abs(int? value)
  • public static long? Abs(long? value)
  • public static sbyte? Abs(sbyte? value)
  • public static float? Abs(float? value)
  • public static double? Acos(double? value)
  • public static object[] AllColumns()
  • public static double? Asin(double? value)
  • public static T AsNotNull<T>(T value)
  • public static T AsNotNullable<T>(T value)
  • public static T AsNullable<T>(T value)
  • public static T AsSql<T>(T obj)
  • public static double? Atan(double? value)
  • public static double? Atan2(double? x, double? y)
  • public static bool Between<T>(this T value, T low, T high) where T : IComparable
  • public static bool Between<T>(this T? value, T? low, T? high) where T : struct, IComparable
  • public static decimal? Ceiling(decimal? value)
  • public static double? Ceiling(double? value)
  • public static string Char(int length)
  • public static int? CharIndex(string value, string str)
  • public static int? CharIndex(string value, string str, int? startLocation)
  • public static int? CharIndex(char? value, string str)
  • public static int? CharIndex(char? value, string str, int? startLocation)
  • public static string Concat(object[] args)
  • public static string Concat(string[] args)
  • public static string ConcatStrings(string separator, string[] arguments)
  • public static TTo Convert<TTo, TFrom>(TTo to, TFrom from)
  • public static TTo Convert<TTo, TFrom>(TTo to, TFrom from, int format)
  • public static TTo Convert<TTo, TFrom>(TFrom obj)
  • public static TTo Convert2<TTo, TFrom>(TTo to, TFrom from)
  • public static T ConvertNullable<T>(T? value) where T : struct
  • public static double? Cos(double? value)
  • public static double? Cosh(double? value)
  • public static double? Cot(double? value)
  • public static DateTime? DateAdd(DateParts part, double? number, DateTime? date)
  • public static DateTimeOffset? DateAdd(DateParts part, double? number, DateTimeOffset? date)
  • public static int? DateDiff(DateParts part, DateTime? startDate, DateTime? endDate)
  • public static int? DatePart(DateParts part, DateTime? date)
  • public static int? DatePart(DateParts part, DateTimeOffset? date)
  • public static TimeSpan? DateToTime(DateTime? date)
  • public static decimal Decimal(int precision)
  • public static decimal Decimal(int precision, int scale)
  • public static decimal? Degrees(decimal? value)
  • public static double? Degrees(double? value)
  • public static short? Degrees(short? value)
  • public static int? Degrees(int? value)
  • public static long? Degrees(long? value)
  • public static sbyte? Degrees(sbyte? value)
  • public static float? Degrees(float? value)
  • public static double? Exp(double? value)
  • public static T Expr<T>(FormattableString sql)
  • public static T Expr<T>(RawSqlString sql, object[] parameters)
  • public static ISqlExpression FieldExpr<T, TV>(ITable<T> table, Expression<Func<T, TV>> fieldExpr)
  • public static ISqlExpression FieldExpr<T, TV>(ITable<T> table, Expression<Func<T, TV>> fieldExpr, bool qualified)
  • public static ISqlExpression FieldExpr(object fieldExpr)
  • public static ISqlExpression FieldExpr(object fieldExpr, bool qualified)
  • public static string FieldName<T>(ITable<T> table, Expression<Func<T, object>> fieldExpr)
  • public static string FieldName<T>(ITable<T> table, Expression<Func<T, object>> fieldExpr, bool qualified)
  • public static string FieldName(object fieldExpr)
  • public static string FieldName(object fieldExpr, bool qualified)
  • public static decimal? Floor(decimal? value)
  • public static double? Floor(double? value)
  • public static bool FreeText(object table, string text)
  • public static DateTime GetDate()
  • public static string Left(string str, int? length)
  • public static int? Length(string str)
  • public static int? Length(Binary value)
  • public static bool Like(string matchExpression, string pattern)
  • public static bool Like(string matchExpression, string pattern, char? escapeCharacter)
  • public static decimal? Log(decimal? value)
  • public static double? Log(double? value)
  • public static double? Log(double? newBase, double? value)
  • public static decimal? Log(decimal? newBase, decimal? value)
  • public static double? Log10(double? value)
  • public static string Lower(string str)
  • public static DateTime? MakeDateTime(int? year, int? month, int? day)
  • public static DateTime? MakeDateTime(int? year, int? month, int? day, int? hour, int? minute, int? second)
  • public static string NChar(int length)
  • public static Guid NewGuid()
  • public static T NoConvert<T>(T expr)
  • public static bool NotBetween<T>(this T value, T low, T high) where T : IComparable
  • public static bool NotBetween<T>(this T? value, T? low, T? high) where T : struct, IComparable
  • public static string NVarChar(int length)
  • public static string PadLeft(string str, int? totalWidth, char? paddingChar)
  • public static string PadRight(string str, int? totalWidth, char? paddingChar)
  • public static double? Power(double? x, double? y)
  • public static T Property<T>(object entity, string propertyName)
  • public static string Replace(string str, string oldValue, string newValue)
  • public static string Replace(string str, char? oldValue, char? newValue)
  • public static string Reverse(string str)
  • public static string Right(string str, int? length)
  • public static decimal? Round(decimal? value)
  • public static double? Round(double? value)
  • public static decimal? Round(decimal? value, int? precision)
  • public static double? Round(double? value, int? precision)
  • public static decimal? RoundToEven(decimal? value)
  • public static double? RoundToEven(double? value)
  • public static decimal? RoundToEven(decimal? value, int? precision)
  • public static double? RoundToEven(double? value, int? precision)
  • public static int? Sign(decimal? value)
  • public static int? Sign(double? value)
  • public static int? Sign(short? value)
  • public static int? Sign(int? value)
  • public static int? Sign(long? value)
  • public static int? Sign(sbyte? value)
  • public static int? Sign(float? value)
  • public static double? Sin(double? value)
  • public static double? Sinh(double? value)
  • public static string Space(int? length)
  • public static double? Sqrt(double? value)
  • public static IStringAggregateNotOrdered<string> StringAggregate(this IQueryable<string> source, string separator)
  • public static IStringAggregateNotOrdered<T> StringAggregate<T>(this IEnumerable<T> source, string separator, Func<T, string> selector)
  • public static IStringAggregateNotOrdered<T> StringAggregate<T>(this IQueryable<T> source, string separator, Expression<Func<T, string>> selector)
  • public static IStringAggregateNotOrdered<string> StringAggregate(this IEnumerable<string> source, string separator)
  • public static string Stuff(string str, int? startLocation, int? length, string value)
  • public static string Stuff(IEnumerable<string> characterExpression, int? start, int? length, string replaceWithExpression)
  • public static string Substring(string str, int? startIndex, int? length)
  • public static ISqlExpression TableExpr<T>(ITable<T> table)
  • public static ISqlExpression TableExpr<T>(ITable<T> table, TableQualification qualification)
  • public static ISqlExpression TableExpr(object tableExpr)
  • public static ISqlExpression TableExpr(object tableExpr, TableQualification qualification)
  • public static string TableName<T>(ITable<T> table)
  • public static string TableName<T>(ITable<T> table, TableQualification qualification)
  • public static string TableName(object tableExpr)
  • public static string TableName(object tableExpr, TableQualification qualification)
  • public static double? Tan(double? value)
  • public static double? Tanh(double? value)
  • public static DateTime? ToDate(int? year, int? month, int? day, int? hour, int? minute, int? second, int? millisecond)
  • public static DateTime? ToDate(int? year, int? month, int? day, int? hour, int? minute, int? second)
  • public static DateTime? ToDate(int? year, int? month, int? day)
  • public static T ToNotNull<T>(T? value) where T : struct
  • public static T ToNotNullable<T>(T? value) where T : struct
  • public static T? ToNullable<T>(T value) where T : struct
  • public static T ToSql<T>(T obj)
  • public static string Trim(string str)
  • public static string Trim(string str, char? ch)
  • public static string TrimLeft(string str)
  • public static string TrimLeft(string str, char? ch)
  • public static string TrimRight(string str)
  • public static string TrimRight(string str, char? ch)
  • public static decimal? Truncate(decimal? value)
  • public static double? Truncate(double? value)
  • public static string Upper(string str)
  • public static string VarChar(int length)
• public enum SqlJoinType
  • Full = 3
  • Inner = 0
  • Left = 1
  • Right = 2
• public static class StringAggregateExtensions
  • public static IStringAggregateOrdered<T> OrderBy<T, TKey>(this IStringAggregateNotOrdered<T> aggregate, Expression<Func<T, TKey>> expr)
  • public static IStringAggregate<string> OrderBy(this IStringAggregateNotOrdered<string> aggregate)
  • public static IStringAggregateOrdered<T> OrderByDescending<T, TKey>(this IStringAggregateNotOrdered<T> aggregate, Expression<Func<T, TKey>> expr)
  • public static IStringAggregate<string> OrderByDescending(this IStringAggregateNotOrdered<string> aggregate)
  • public static IStringAggregateOrdered<T> ThenBy<T, TKey>(this IStringAggregateOrdered<T> aggregate, Expression<Func<T, TKey>> expr)
  • public static IStringAggregateOrdered<T> ThenByDescending<T, TKey>(this IStringAggregateOrdered<T> aggregate, Expression<Func<T, TKey>> expr)
  • public static string ToValue<T>(this IStringAggregate<T> aggregate)
• public enum TakeHints
  • Percent = 1
  • WithTies = 2
• public class TempTable<T> : ITable<T>, IExpressionQuery<T>, IOrderedQueryable<T>, IEnumerable<T>, IEnumerable, IOrderedQueryable, IQueryable, IQueryable<T>, IQueryProviderAsync, IQueryProvider, IExpressionQuery, ITableMutable<T>, IDisposable
  • public long TotalCopied
  • public string DatabaseName { get; }
  • public IDataContext DataContext { get; }
  • public string SchemaName { get; }
  • public string TableName { get; }
  • public TempTable(IDataContext db, string tableName = null, string databaseName = null, string schemaName = null)
  • public TempTable(IDataContext db, IEnumerable<T> items, BulkCopyOptions options = null, string tableName = null, string databaseName = null, string schemaName = null)
  • public TempTable(IDataContext db, string tableName, IEnumerable<T> items, BulkCopyOptions options = null, string databaseName = null, string schemaName = null)
  • public TempTable(IDataContext db, IQueryable<T> items, string tableName = null, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public TempTable(IDataContext db, string tableName, IQueryable<T> items, string databaseName = null, string schemaName = null, Action<ITable<T>> action = null)
  • public long Copy(IEnumerable<T> items, BulkCopyOptions options = null)
  • public virtual void Dispose()
  • public string GetTableName()
  • public long Insert(IQueryable<T> items)

LinqToDB.Async

• public class AsyncDbConnection : IAsyncDbConnection, IDbConnection, IDisposable
  • public virtual IDbConnection Connection { get; }
  • public virtual string ConnectionString { get; set; }
  • public virtual int ConnectionTimeout { get; }
  • public virtual string Database { get; }
  • public virtual ConnectionState State { get; }
  • public virtual IDbTransaction BeginTransaction()
  • public virtual IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
  • public virtual Task<IAsyncDbTransaction> BeginTransactionAsync(CancellationToken cancellationToken = default)
  • public virtual Task<IAsyncDbTransaction> BeginTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken = default)
  • public virtual void ChangeDatabase(string databaseName)
  • public virtual void Close()
  • public virtual Task CloseAsync(CancellationToken cancellationToken = default)
  • public virtual IDbCommand CreateCommand()
  • public virtual void Dispose()
  • public virtual void Open()
  • public virtual Task OpenAsync(CancellationToken cancellationToken = default)
  • public virtual IAsyncDbConnection TryClone()
• public class AsyncDbTransaction : IAsyncDbTransaction, IDbTransaction, IDisposable
  • public virtual IDbConnection Connection { get; }
  • public virtual IsolationLevel IsolationLevel { get; }
  • public IDbTransaction Transaction { get; }
  • public virtual void Commit()
  • public virtual Task CommitAsync(CancellationToken cancellationToken = default)
  • public virtual void Dispose()
  • public virtual void Rollback()
  • public virtual Task RollbackAsync(CancellationToken cancellationToken = default)
• public static class AsyncExtensions
  • public static IAsyncEnumerable<TSource> AsAsyncEnumerable<TSource>(this IQueryable<TSource> source, CancellationToken cancellationToken = default)
  • public static Task<T> FirstOrDefaultAsync<T>(this IAsyncEnumerable<T> source, CancellationToken cancellationToken = default)
  • public static Task<T[]> ToArrayAsync<T>(this IAsyncEnumerable<T> source, CancellationToken cancellationToken = default)
  • public static Task<List<T>> ToListAsync<T>(this IAsyncEnumerable<T> source, CancellationToken cancellationToken = default)
• public static class AsyncFactory
  • public static IAsyncDbConnection Create(IDbConnection connection)
  • public static IAsyncDbTransaction Create(IDbTransaction transaction)
  • public static void RegisterConnectionFactory<TConnection>(Func<IDbConnection, IAsyncDbConnection> factory) where TConnection : IDbConnection
  • public static void RegisterTransactionFactory<TTransaction>(Func<IDbTransaction, IAsyncDbTransaction> factory) where TTransaction : IDbTransaction
• public interface IAsyncDbConnection : IDbConnection, IDisposable
  • IDbConnection Connection { get; }
  • Task<IAsyncDbTransaction> BeginTransactionAsync(CancellationToken cancellationToken = default)
  • Task<IAsyncDbTransaction> BeginTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken = default)
  • Task CloseAsync(CancellationToken cancellationToken = default)
  • Task OpenAsync(CancellationToken cancellationToken = default)
  • IAsyncDbConnection TryClone()
• public interface IAsyncDbTransaction : IDbTransaction, IDisposable
  • IDbTransaction Transaction { get; }
  • Task CommitAsync(CancellationToken cancellationToken = default)
  • Task RollbackAsync(CancellationToken cancellationToken = default)
• public interface IAsyncEnumerable<T>
  • IAsyncEnumerator<T> GetEnumerator()
• public interface IAsyncEnumerator<T> : IDisposable
  • T Current { get; }
  • Task<bool> MoveNext(CancellationToken cancellationToken)
• public interface IQueryProviderAsync : IQueryProvider
  • IAsyncEnumerable<TResult> ExecuteAsync<TResult>(Expression expression)
  • Task<TResult> ExecuteAsync<TResult>(Expression expression, CancellationToken token)

LinqToDB.Common

• public static class Array<T>
  • public static readonly T[] Empty
• public static class Configuration
  • public static class Data
  • public static class Linq
  • public static class LinqService
  • public static class RetryPolicy
  • public static class Sql
  • public static bool AvoidSpecificDataProviderAPI
  • public static bool ContinueOnCapturedContext
  • public static bool IsStructIsScalarType
  • public static bool UseEnumValueNameForStringColumns
• public static class Convert<TFrom, TTo>
  • public static Expression<Func<TFrom, TTo>> Expression { get; set; }
  • public static Func<TFrom, TTo> From { get; }
  • public static Func<TFrom, TTo> Lambda { get; set; }
• public static class Converter
  • public static object ChangeType(object value, Type conversionType, MappingSchema mappingSchema = null)
  • public static T ChangeTypeTo<T>(object value, MappingSchema mappingSchema = null)
  • public static Type GetDefaultMappingFromEnumType(MappingSchema mappingSchema, Type enumType)
  • public static void SetConverter<TFrom, TTo>(Expression<Func<TFrom, TTo>> expr)
• public static class ConvertTo<TTo>
  • public static TTo From<TFrom>(TFrom o)
• public struct DbDataType
  • public DataType DataType { get; }
  • public string DbType { get; }
  • public int? Length { get; }
  • public Type SystemType { get; }
  • public DbDataType(Type systemType)
  • public DbDataType(Type systemType, DataType dataType)
  • public DbDataType(Type systemType, DataType dataType, string dbType)
  • public DbDataType(Type systemType, DataType dataType, string dbType, int? length)
  • public DbDataType(Type systemType, string dbType)
  • public static bool op_Equality(DbDataType t1, DbDataType t2)
  • public static bool op_Inequality(DbDataType t1, DbDataType t2)
  • public bool Equals(DbDataType other)
  • public DbDataType WithDataType(DataType dataType)
  • public DbDataType WithDbType(string dbName)
  • public DbDataType WithLength(int? length)
  • public DbDataType WithSystemType(Type systemType)
• public static class DefaultValue
  • public static object GetValue(Type type, MappingSchema mappingSchema = null)
  • public static T GetValue<T>()
  • public static void SetValue<T>(T value)
• public static class DefaultValue<T>
  • public static T Value { get; set; }
• public class LinqToDBConvertException : LinqToDBException
  • public string ColumnName { get; }
  • public LinqToDBConvertException()
  • public LinqToDBConvertException(string message)
  • public LinqToDBConvertException(string message, Exception innerException)
  • public LinqToDBConvertException(Exception innerException)
  • protected LinqToDBConvertException(SerializationInfo info, StreamingContext context)
• public struct RawSqlString
  • public string Format { get; }
  • public RawSqlString(string s)
  • public static RawSqlString op_Implicit(string s)
  • public static RawSqlString op_Implicit(FormattableString fs)
• public static class Tools
  • public static string Args(this string format, object[] args)
  • public static string GetFileName(this Assembly assembly)
  • public static string GetPath(this Assembly assembly)
  • public static string GetPathFromUri(this string uriString)
  • public static bool IsNullOrEmpty(this ICollection array)
  • public static bool IsNullOrEmpty(this string str)
• public static class Utils
  • public static void MakeUniqueNames<T>(IEnumerable<T> items, IEnumerable<string> staticNames, Func<T, string> nameFunc, Action<T, string> nameSetter, string defaultName = "t", StringComparer comparer = null)
  • public static void MakeUniqueNames<T>(IEnumerable<T> items, IEnumerable<string> staticNames, Func<T, string> nameFunc, Action<T, string> nameSetter, Func<T, string> defaultName, StringComparer comparer = null)
  • public static void MakeUniqueNames<T>(IEnumerable<T> items, Func<string, bool> validatorFunc, Func<T, string> nameFunc, Action<T, string> nameSetter, Func<T, string> defaultName, StringComparer comparer = null)

LinqToDB.Common.Internal.Cache

• public static class CacheEntryExtensions
  • public static ICacheEntry AddExpirationToken(this ICacheEntry entry, IChangeToken expirationToken)
  • public static ICacheEntry RegisterPostEvictionCallback(this ICacheEntry entry, PostEvictionDelegate callback)
  • public static ICacheEntry RegisterPostEvictionCallback(this ICacheEntry entry, PostEvictionDelegate callback, object state)
  • public static ICacheEntry SetAbsoluteExpiration(this ICacheEntry entry, TimeSpan relative)
  • public static ICacheEntry SetAbsoluteExpiration(this ICacheEntry entry, DateTimeOffset absolute)
  • public static ICacheEntry SetOptions(this ICacheEntry entry, MemoryCacheEntryOptions options)
  • public static ICacheEntry SetPriority(this ICacheEntry entry, CacheItemPriority priority)
  • public static ICacheEntry SetSize(this ICacheEntry entry, long size)
  • public static ICacheEntry SetSlidingExpiration(this ICacheEntry entry, TimeSpan offset)
  • public static ICacheEntry SetValue(this ICacheEntry entry, object value)
• public static class CacheExtensions
  • public static object Get(this IMemoryCache cache, object key)
  • public static TItem Get<TItem>(this IMemoryCache cache, object key)
  • public static TItem GetOrCreate<TItem>(this IMemoryCache cache, object key, Func<ICacheEntry, TItem> factory)
  • public static Task<TItem> GetOrCreateAsync<TItem>(this IMemoryCache cache, object key, Func<ICacheEntry, Task<TItem>> factory)
  • public static TItem Set<TItem>(this IMemoryCache cache, object key, TItem value)
  • public static TItem Set<TItem>(this IMemoryCache cache, object key, TItem value, DateTimeOffset absoluteExpiration)
  • public static TItem Set<TItem>(this IMemoryCache cache, object key, TItem value, TimeSpan absoluteExpirationRelativeToNow)
  • public static TItem Set<TItem>(this IMemoryCache cache, object key, TItem value, IChangeToken expirationToken)
  • public static TItem Set<TItem>(this IMemoryCache cache, object key, TItem value, MemoryCacheEntryOptions options)
  • public static bool TryGetValue<TItem>(this IMemoryCache cache, object key, out TItem value)
• public enum CacheItemPriority
  • High = 2
  • Low = 0
  • NeverRemove = 3
  • Normal = 1
• public enum EvictionReason
  • Capacity = 5
  • Expired = 3
  • None = 0
  • Removed = 1
  • Replaced = 2
  • TokenExpired = 4
• public interface ICacheEntry : IDisposable
  • DateTimeOffset? AbsoluteExpiration { get; set; }
  • TimeSpan? AbsoluteExpirationRelativeToNow { get; set; }
  • IList<IChangeToken> ExpirationTokens { get; }
  • object Key { get; }
  • IList<PostEvictionCallbackRegistration> PostEvictionCallbacks { get; }
  • CacheItemPriority Priority { get; set; }
  • long? Size { get; set; }
  • TimeSpan? SlidingExpiration { get; set; }
  • object Value { get; set; }
• public interface IChangeToken
  • bool ActiveChangeCallbacks { get; }
  • bool HasChanged { get; }
  • IDisposable RegisterChangeCallback(Action<object> callback, object state)
• public interface IMemoryCache : IDisposable
  • ICacheEntry CreateEntry(object key)
  • void Remove(object key)
  • bool TryGetValue(object key, out object value)
• public interface ISystemClock
  • DateTimeOffset UtcNow { get; }
• public class MemoryCache : IMemoryCache, IDisposable
  • public int Count { get; }
  • public MemoryCache(MemoryCacheOptions optionsAccessor)
  • public void Compact(double percentage)
  • public ICacheEntry CreateEntry(object key)
  • public void Dispose()
  • protected virtual void Dispose(bool disposing)
  • public void Remove(object key)
  • public bool TryGetValue(object key, out object result)
• public static class MemoryCacheEntryExtensions
  • public static MemoryCacheEntryOptions AddExpirationToken(this MemoryCacheEntryOptions options, IChangeToken expirationToken)
  • public static MemoryCacheEntryOptions RegisterPostEvictionCallback(this MemoryCacheEntryOptions options, PostEvictionDelegate callback)
  • public static MemoryCacheEntryOptions RegisterPostEvictionCallback(this MemoryCacheEntryOptions options, PostEvictionDelegate callback, object state)
  • public static MemoryCacheEntryOptions SetAbsoluteExpiration(this MemoryCacheEntryOptions options, TimeSpan relative)
  • public static MemoryCacheEntryOptions SetAbsoluteExpiration(this MemoryCacheEntryOptions options, DateTimeOffset absolute)
  • public static MemoryCacheEntryOptions SetPriority(this MemoryCacheEntryOptions options, CacheItemPriority priority)
  • public static MemoryCacheEntryOptions SetSize(this MemoryCacheEntryOptions options, long size)
  • public static MemoryCacheEntryOptions SetSlidingExpiration(this MemoryCacheEntryOptions options, TimeSpan offset)
• public class MemoryCacheEntryOptions
  • public DateTimeOffset? AbsoluteExpiration { get; set; }
  • public TimeSpan? AbsoluteExpirationRelativeToNow { get; set; }
  • public IList<IChangeToken> ExpirationTokens { get; }
  • public IList<PostEvictionCallbackRegistration> PostEvictionCallbacks { get; }
  • public CacheItemPriority Priority { get; set; }
  • public long? Size { get; set; }
  • public TimeSpan? SlidingExpiration { get; set; }
  • public MemoryCacheEntryOptions()
• public class MemoryCacheOptions
  • public ISystemClock Clock { get; set; }
  • public double CompactionPercentage { get; set; }
  • public TimeSpan ExpirationScanFrequency { get; set; }
  • public long? SizeLimit { get; set; }
  • public MemoryCacheOptions()
• public class PostEvictionCallbackRegistration
  • public PostEvictionDelegate EvictionCallback { get; set; }
  • public object State { get; set; }
  • public PostEvictionCallbackRegistration()
• public sealed delegate PostEvictionDelegate : MulticastDelegate
  • public PostEvictionDelegate(object object, IntPtr method)
  • public virtual IAsyncResult BeginInvoke(object key, object value, EvictionReason reason, object state, AsyncCallback callback, object object)
  • public virtual void EndInvoke(IAsyncResult result)
  • public virtual void Invoke(object key, object value, EvictionReason reason, object state)
• public class SystemClock : ISystemClock
  • public DateTimeOffset UtcNow { get; }
  • public SystemClock()

LinqToDB.Configuration

• public interface IConnectionStringSettings
  • string ConnectionString { get; }
  • bool IsGlobal { get; }
  • string Name { get; }
  • string ProviderName { get; }
• public interface IDataProviderSettings
  • IEnumerable<NamedValue> Attributes { get; }
  • bool Default { get; }
  • string Name { get; }
  • string TypeName { get; }
• public interface ILinqToDBSettings
  • IEnumerable<IConnectionStringSettings> ConnectionStrings { get; }
  • IEnumerable<IDataProviderSettings> DataProviders { get; }
  • string DefaultConfiguration { get; }
  • string DefaultDataProvider { get; }
• public class NamedValue
  • public string Name { get; set; }
  • public string Value { get; set; }
  • public NamedValue()

LinqToDB.Data

• public class BulkCopyOptions
  • public int? BulkCopyTimeout { get; set; }
  • public BulkCopyType BulkCopyType { get; set; }
  • public bool? CheckConstraints { get; set; }
  • public string DatabaseName { get; set; }
  • public bool? FireTriggers { get; set; }
  • public bool? IgnoreSkipOnInsert { get; set; }
  • public bool? KeepIdentity { get; set; }
  • public bool? KeepNulls { get; set; }
  • public int? MaxBatchSize { get; set; }
  • public int NotifyAfter { get; set; }
  • public bool RetrieveSequence { get; set; }
  • public Action<BulkCopyRowsCopied> RowsCopiedCallback { get; set; }
  • public string SchemaName { get; set; }
  • public bool? TableLock { get; set; }
  • public string TableName { get; set; }
  • public bool? UseInternalTransaction { get; set; }
  • public BulkCopyOptions()
  • public BulkCopyOptions(BulkCopyOptions options)
• public class BulkCopyRowsCopied
  • public bool Abort { get; set; }
  • public long RowsCopied { get; set; }
  • public DateTime StartTime { get; }
  • public BulkCopyRowsCopied()
• public enum BulkCopyType
  • Default = 0
  • MultipleRows = 2
  • ProviderSpecific = 3
  • RowByRow = 1
• public class CommandInfo
  • public CommandBehavior CommandBehavior
  • public string CommandText
  • public CommandType CommandType
  • public DataConnection DataConnection
  • public DataParameter[] Parameters
  • public CommandInfo(DataConnection dataConnection, string commandText)
  • public CommandInfo(DataConnection dataConnection, string commandText, DataParameter[] parameters)
  • public CommandInfo(DataConnection dataConnection, string commandText, DataParameter parameter)
  • public CommandInfo(DataConnection dataConnection, string commandText, object parameters)
  • public static void ClearObjectReaderCache()
  • public int Execute()
  • public T Execute<T>()
  • public Task<int> ExecuteAsync()
  • public Task<int> ExecuteAsync(CancellationToken cancellationToken)
  • public Task<T> ExecuteAsync<T>()
  • public Task<T> ExecuteAsync<T>(CancellationToken cancellationToken)
  • public int ExecuteProc()
  • public T ExecuteProc<T>()
  • public Task<int> ExecuteProcAsync()
  • public Task<int> ExecuteProcAsync(CancellationToken cancellationToken)
  • public Task<T> ExecuteProcAsync<T>()
  • public Task<T> ExecuteProcAsync<T>(CancellationToken cancellationToken)
  • public DataReader ExecuteReader()
  • public Task<DataReaderAsync> ExecuteReaderAsync()
  • public Task<DataReaderAsync> ExecuteReaderAsync(CancellationToken cancellationToken)
  • public DataReader ExecuteReaderProc()
  • public IEnumerable<T> Query<T>(Func<IDataReader, T> objectReader)
  • public IEnumerable<T> Query<T>()
  • public IEnumerable<T> Query<T>(T template)
  • public Task QueryForEachAsync<T>(Func<IDataReader, T> objectReader, Action<T> action)
  • public Task QueryForEachAsync<T>(Func<IDataReader, T> objectReader, Action<T> action, CancellationToken cancellationToken)
  • public Task QueryForEachAsync<T>(Action<T> action)
  • public Task QueryForEachAsync<T>(Action<T> action, CancellationToken cancellationToken)
  • public T QueryMultiple<T>()
  • public Task<T> QueryMultipleAsync<T>(CancellationToken cancellationToken = default)
  • public IEnumerable<T> QueryProc<T>(Func<IDataReader, T> objectReader)
  • public IEnumerable<T> QueryProc<T>()
  • public IEnumerable<T> QueryProc<T>(T template)
  • public T QueryProcMultiple<T>()
  • public Task<T> QueryProcMultipleAsync<T>(CancellationToken cancellationToken = default)
  • public Task<T[]> QueryToArrayAsync<T>(Func<IDataReader, T> objectReader)
  • public Task<T[]> QueryToArrayAsync<T>(Func<IDataReader, T> objectReader, CancellationToken cancellationToken)
  • public Task<T[]> QueryToArrayAsync<T>()
  • public Task<T[]> QueryToArrayAsync<T>(CancellationToken cancellationToken)
  • public Task<List<T>> QueryToListAsync<T>(Func<IDataReader, T> objectReader)
  • public Task<List<T>> QueryToListAsync<T>(Func<IDataReader, T> objectReader, CancellationToken cancellationToken)
  • public Task<List<T>> QueryToListAsync<T>()
  • public Task<List<T>> QueryToListAsync<T>(CancellationToken cancellationToken)
• public class DataConnection : ICloneable, IDataContext, IEntityServices, IDisposable
  • public static Action<string, string> WriteTraceLine
  • public string LastQuery
  • public static string DefaultConfiguration { get; set; }
  • public static string DefaultDataProvider { get; set; }
  • public static ILinqToDBSettings DefaultSettings { get; set; }
  • public static Action<TraceInfo> OnTrace { get; set; }
  • public static TraceSwitch TraceSwitch { get; set; }
  • public IDbCommand Command { get; set; }
  • public int CommandTimeout { get; set; }
  • public string ConfigurationString { get; }
  • public IDbConnection Connection { get; }
  • public string ConnectionString { get; }
  • public IDataProvider DataProvider { get; }
  • protected bool Disposed { get; }
  • public int ID { get; }
  • public bool InlineParameters { get; set; }
  • public bool IsMarsEnabled { get; set; }
  • public MappingSchema MappingSchema { get; }
  • public List<string> NextQueryHints { get; }
  • public Action<EntityCreatedEventArgs> OnEntityCreated { get; set; }
  • public Action<TraceInfo> OnTraceConnection { get; set; }
  • public List<string> QueryHints { get; }
  • public IRetryPolicy RetryPolicy { get; set; }
  • public bool? ThrowOnDisposed { get; set; }
  • public IDbTransaction Transaction { get; }
  • public event Action<DataConnection, IDbConnection> OnBeforeConnectionOpen
  • public event Func<DataConnection, IDbConnection, CancellationToken, Task> OnBeforeConnectionOpenAsync
  • public event EventHandler OnClosed
  • public event EventHandler OnClosing
  • public event Action<DataConnection, IDbConnection> OnConnectionOpened
  • public event Func<DataConnection, IDbConnection, CancellationToken, Task> OnConnectionOpenedAsync
  • public DataConnection()
  • public DataConnection(MappingSchema mappingSchema)
  • public DataConnection(string configurationString, MappingSchema mappingSchema)
  • public DataConnection(string configurationString)
  • public DataConnection(string providerName, string connectionString, MappingSchema mappingSchema)
  • public DataConnection(string providerName, string connectionString)
  • public DataConnection(IDataProvider dataProvider, string connectionString, MappingSchema mappingSchema)
  • public DataConnection(IDataProvider dataProvider, string connectionString)
  • public DataConnection(IDataProvider dataProvider, Func<IDbConnection> connectionFactory, MappingSchema mappingSchema)
  • public DataConnection(IDataProvider dataProvider, Func<IDbConnection> connectionFactory)
  • public DataConnection(IDataProvider dataProvider, IDbConnection connection, MappingSchema mappingSchema)
  • public DataConnection(IDataProvider dataProvider, IDbConnection connection)
  • public DataConnection(IDataProvider dataProvider, IDbConnection connection, bool disposeConnection)
  • public DataConnection(IDataProvider dataProvider, IDbTransaction transaction, MappingSchema mappingSchema)
  • public DataConnection(IDataProvider dataProvider, IDbTransaction transaction)
  • public static void AddConfiguration(string configuration, string connectionString, IDataProvider dataProvider = null)
  • public static void AddDataProvider(string providerName, IDataProvider dataProvider)
  • public static void AddDataProvider(IDataProvider dataProvider)
  • public static void AddOrSetConfiguration(string configuration, string connectionString, string dataProvider)
  • public static void AddProviderDetector(Func<IConnectionStringSettings, string, IDataProvider> providerDetector)
  • public static void ClearObjectReaderCache()
  • public static string GetConnectionString(string configurationString)
  • public static IDataProvider GetDataProvider(string configurationString)
  • public static IDataProvider GetDataProvider(string providerName, string configurationString, string connectionString)
  • public static IDataProvider GetDataProvider(string providerName, string connectionString)
  • public static IReadOnlyDictionary<string, IDataProvider> GetRegisteredProviders()
  • public static void SetConnectionString(string configuration, string connectionString)
  • public static void SetConnectionStrings(IEnumerable<IConnectionStringSettings> connectionStrings)
  • public static void TurnTraceSwitchOn(TraceLevel traceLevel = 3)
  • public DataConnection AddMappingSchema(MappingSchema mappingSchema)
  • public virtual DataConnectionTransaction BeginTransaction()
  • public virtual DataConnectionTransaction BeginTransaction(IsolationLevel isolationLevel)
  • public virtual Task<DataConnectionTransaction> BeginTransactionAsync(CancellationToken cancellationToken = default)
  • public virtual Task<DataConnectionTransaction> BeginTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken = default)
  • protected void CheckAndThrowOnDisposed()
  • public object Clone()
  • public virtual void Close()
  • public virtual Task CloseAsync(CancellationToken cancellationToken = default)
  • public virtual void CommitTransaction()
  • public virtual Task CommitTransactionAsync(CancellationToken cancellationToken = default)
  • public IDbCommand CreateCommand()
  • public void Dispose()
  • public Task DisposeAsync(CancellationToken cancellationToken = default)
  • public void DisposeCommand()
  • public Task EnsureConnectionAsync(CancellationToken cancellationToken = default)
  • protected virtual int ExecuteNonQuery(IDbCommand command)
  • protected virtual Task<int> ExecuteNonQueryAsync(IDbCommand command, CancellationToken cancellationToken)
  • protected virtual IDataReader ExecuteReader(IDbCommand command, CommandBehavior commandBehavior)
  • protected virtual Task<DbDataReader> ExecuteReaderAsync(IDbCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken)
  • protected virtual object ExecuteScalar(IDbCommand command)
  • protected virtual Task<object> ExecuteScalarAsync(IDbCommand command, CancellationToken cancellationToken)
  • public ITable<T> GetTable<T>()
  • public ITable<T> GetTable<T>(object instance, MethodInfo methodInfo, object[] parameters)
  • protected virtual SqlStatement ProcessQuery(SqlStatement statement)
  • public virtual void RollbackTransaction()
  • public virtual Task RollbackTransactionAsync(CancellationToken cancellationToken = default)
• public static class DataConnectionExtensions
  • public static BulkCopyRowsCopied BulkCopy<T>(this DataConnection dataConnection, BulkCopyOptions options, IEnumerable<T> source)
  • public static BulkCopyRowsCopied BulkCopy<T>(this DataConnection dataConnection, int maxBatchSize, IEnumerable<T> source)
  • public static BulkCopyRowsCopied BulkCopy<T>(this DataConnection dataConnection, IEnumerable<T> source)
  • public static BulkCopyRowsCopied BulkCopy<T>(this ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • public static BulkCopyRowsCopied BulkCopy<T>(this ITable<T> table, int maxBatchSize, IEnumerable<T> source)
  • public static BulkCopyRowsCopied BulkCopy<T>(this ITable<T> table, IEnumerable<T> source)
  • public static int Execute(this DataConnection connection, string sql)
  • public static int Execute(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static int Execute(this DataConnection connection, string sql, object parameters)
  • public static T Execute<T>(this DataConnection connection, string sql)
  • public static T Execute<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static T Execute<T>(this DataConnection connection, string sql, DataParameter parameter)
  • public static T Execute<T>(this DataConnection connection, string sql, object parameters)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql, CancellationToken cancellationToken)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql, object parameters)
  • public static Task<int> ExecuteAsync(this DataConnection connection, string sql, CancellationToken cancellationToken, object parameters)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, DataParameter parameter)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, DataParameter parameter, CancellationToken cancellationToken)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, object parameters)
  • public static Task<T> ExecuteAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, object parameters)
  • public static int ExecuteProc(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static T ExecuteProc<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<int> ExecuteProcAsync(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<int> ExecuteProcAsync(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T> ExecuteProcAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T> ExecuteProcAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static DataReader ExecuteReader(this DataConnection connection, string sql)
  • public static DataReader ExecuteReader(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static DataReader ExecuteReader(this DataConnection connection, string sql, DataParameter parameter)
  • public static DataReader ExecuteReader(this DataConnection connection, string sql, object parameters)
  • public static DataReader ExecuteReader(this DataConnection connection, string sql, CommandType commandType, CommandBehavior commandBehavior, DataParameter[] parameters)
  • public static int Merge<T>(this DataConnection dataConnection, IQueryable<T> source, Expression<Func<T, bool>> predicate, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this DataConnection dataConnection, Expression<Func<T, bool>> predicate, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this DataConnection dataConnection, bool delete, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this DataConnection dataConnection, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this ITable<T> table, IQueryable<T> source, Expression<Func<T, bool>> predicate, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this ITable<T> table, Expression<Func<T, bool>> predicate, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this ITable<T> table, bool delete, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static int Merge<T>(this ITable<T> table, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null)
  • public static Task<int> MergeAsync<T>(this DataConnection dataConnection, IQueryable<T> source, Expression<Func<T, bool>> predicate, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this DataConnection dataConnection, Expression<Func<T, bool>> predicate, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this DataConnection dataConnection, bool delete, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this DataConnection dataConnection, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this ITable<T> table, IQueryable<T> source, Expression<Func<T, bool>> predicate, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this ITable<T> table, Expression<Func<T, bool>> predicate, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this ITable<T> table, bool delete, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static Task<int> MergeAsync<T>(this ITable<T> table, IEnumerable<T> source, string tableName = null, string databaseName = null, string schemaName = null, CancellationToken cancellationToken = default)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, DataParameter[] parameters)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, object parameters)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, string sql)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, string sql, DataParameter parameter)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, string sql, object parameters)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, T template, string sql, DataParameter[] parameters)
  • public static IEnumerable<T> Query<T>(this DataConnection connection, T template, string sql, object parameters)
  • public static T QueryMultiple<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T> QueryMultipleAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T> QueryMultipleAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static IEnumerable<T> QueryProc<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, DataParameter[] parameters)
  • public static IEnumerable<T> QueryProc<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static T QueryProcMultiple<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T> QueryProcMultipleAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T> QueryProcMultipleAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, CancellationToken cancellationToken)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, object parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, CancellationToken cancellationToken, object parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, DataParameter parameter)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, DataParameter parameter, CancellationToken cancellationToken)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, object parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, object parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, T template, string sql, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, T template, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, T template, string sql, object parameters)
  • public static Task<T[]> QueryToArrayAsync<T>(this DataConnection connection, T template, string sql, CancellationToken cancellationToken, object parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, CancellationToken cancellationToken)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, object parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, Func<IDataReader, T> objectReader, string sql, object parameters, CancellationToken cancellationToken)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, DataParameter parameter)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, DataParameter parameter, CancellationToken cancellationToken)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, object parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, string sql, CancellationToken cancellationToken, object parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, T template, string sql, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, T template, string sql, CancellationToken cancellationToken, DataParameter[] parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, T template, string sql, object parameters)
  • public static Task<List<T>> QueryToListAsync<T>(this DataConnection connection, T template, string sql, CancellationToken cancellationToken, object parameters)
  • public static CommandInfo SetCommand(this DataConnection dataConnection, string commandText)
  • public static CommandInfo SetCommand(this DataConnection dataConnection, string commandText, DataParameter[] parameters)
  • public static CommandInfo SetCommand(this DataConnection dataConnection, string commandText, DataParameter parameter)
  • public static CommandInfo SetCommand(this DataConnection dataConnection, string commandText, object parameters)
• public class DataConnectionTransaction : IDisposable
  • public DataConnection DataConnection { get; }
  • public DataConnectionTransaction(DataConnection dataConnection)
  • public void Commit()
  • public Task CommitAsync(CancellationToken cancellationToken = default)
  • public void Dispose()
  • public void Rollback()
  • public Task RollbackAsync(CancellationToken cancellationToken = default)
• public class DataParameter
  • public DataType DataType { get; set; }
  • public string DbType { get; set; }
  • public ParameterDirection? Direction { get; set; }
  • public bool IsArray { get; set; }
  • public string Name { get; set; }
  • public int? Size { get; set; }
  • public object Value { get; set; }
  • public DataParameter()
  • public DataParameter(string name, object value)
  • public DataParameter(string name, object value, DataType dataType)
  • public DataParameter(string name, object value, DataType dataType, string dbType)
  • public DataParameter(string name, object value, string dbType)
  • public static DataParameter Binary(string name, byte[] value)
  • public static DataParameter Binary(string name, Binary value)
  • public static DataParameter BinaryJson(string name, string value)
  • public static DataParameter BitArray(string name, BitArray value)
  • public static DataParameter Blob(string name, byte[] value)
  • public static DataParameter Boolean(string name, bool value)
  • public static DataParameter Byte(string name, byte value)
  • public static DataParameter Char(string name, char value)
  • public static DataParameter Char(string name, string value)
  • public static DataParameter Create(string name, char value)
  • public static DataParameter Create(string name, string value)
  • public static DataParameter Create(string name, byte[] value)
  • public static DataParameter Create(string name, Binary value)
  • public static DataParameter Create(string name, bool value)
  • public static DataParameter Create(string name, sbyte value)
  • public static DataParameter Create(string name, short value)
  • public static DataParameter Create(string name, int value)
  • public static DataParameter Create(string name, long value)
  • public static DataParameter Create(string name, byte value)
  • public static DataParameter Create(string name, ushort value)
  • public static DataParameter Create(string name, uint value)
  • public static DataParameter Create(string name, ulong value)
  • public static DataParameter Create(string name, float value)
  • public static DataParameter Create(string name, double value)
  • public static DataParameter Create(string name, decimal value)
  • public static DataParameter Create(string name, Guid value)
  • public static DataParameter Create(string name, TimeSpan value)
  • public static DataParameter Create(string name, DateTime value)
  • public static DataParameter Create(string name, DateTimeOffset value)
  • public static DataParameter Create(string name, XDocument value)
  • public static DataParameter Create(string name, XmlDocument value)
  • public static DataParameter Create(string name, BitArray value)
  • public static DataParameter Create(string name, Dictionary<string, string> value)
  • public static DataParameter Date(string name, DateTime value)
  • public static DataParameter DateTime(string name, DateTime value)
  • public static DataParameter DateTime2(string name, DateTime value)
  • public static DataParameter DateTimeOffset(string name, DateTimeOffset value)
  • public static DataParameter Decimal(string name, decimal value)
  • public static DataParameter Dictionary(string name, IDictionary value)
  • public static DataParameter Double(string name, double value)
  • public static DataParameter Guid(string name, Guid value)
  • public static DataParameter Image(string name, byte[] value)
  • public static DataParameter Int16(string name, short value)
  • public static DataParameter Int32(string name, int value)
  • public static DataParameter Int64(string name, long value)
  • public static DataParameter Json(string name, string value)
  • public static DataParameter Money(string name, decimal value)
  • public static DataParameter NChar(string name, char value)
  • public static DataParameter NChar(string name, string value)
  • public static DataParameter NText(string name, string value)
  • public static DataParameter NVarChar(string name, char value)
  • public static DataParameter NVarChar(string name, string value)
  • public static DataParameter SByte(string name, sbyte value)
  • public static DataParameter Single(string name, float value)
  • public static DataParameter SmallDateTime(string name, DateTime value)
  • public static DataParameter SmallMoney(string name, decimal value)
  • public static DataParameter Text(string name, string value)
  • public static DataParameter Time(string name, TimeSpan value)
  • public static DataParameter Timestamp(string name, byte[] value)
  • public static DataParameter Udt(string name, object value)
  • public static DataParameter UInt16(string name, ushort value)
  • public static DataParameter UInt32(string name, uint value)
  • public static DataParameter UInt64(string name, ulong value)
  • public static DataParameter VarBinary(string name, byte[] value)
  • public static DataParameter VarBinary(string name, Binary value)
  • public static DataParameter VarChar(string name, char value)
  • public static DataParameter VarChar(string name, string value)
  • public static DataParameter Variant(string name, object value)
  • public static DataParameter VarNumeric(string name, decimal value)
  • public static DataParameter Xml(string name, string value)
  • public static DataParameter Xml(string name, XDocument value)
  • public static DataParameter Xml(string name, XmlDocument value)
• public class DataReader : IDisposable
  • public CommandInfo CommandInfo { get; set; }
  • public IDataReader Reader { get; set; }
  • public DataReader()
  • public void Dispose()
  • public T Execute<T>()
  • public IEnumerable<T> Query<T>(Func<IDataReader, T> objectReader)
  • public IEnumerable<T> Query<T>()
  • public IEnumerable<T> Query<T>(T template)
• public class DataReaderAsync : IDisposable
  • public CommandInfo CommandInfo { get; set; }
  • public DbDataReader Reader { get; set; }
  • public DataReaderAsync()
  • public void Dispose()
  • public Task<T> ExecuteForEachAsync<T>()
  • public Task<T> ExecuteForEachAsync<T>(CancellationToken cancellationToken)
  • public Task QueryForEachAsync<T>(Func<IDataReader, T> objectReader, Action<T> action)
  • public Task QueryForEachAsync<T>(Func<IDataReader, T> objectReader, Action<T> action, CancellationToken cancellationToken)
  • public Task QueryForEachAsync<T>(Action<T> action)
  • public Task QueryForEachAsync<T>(Action<T> action, CancellationToken cancellationToken)
  • public Task QueryForEachAsync<T>(T template, Action<T> action)
  • public Task QueryForEachAsync<T>(T template, Action<T> action, CancellationToken cancellationToken)
  • public Task<T[]> QueryToArrayAsync<T>(Func<IDataReader, T> objectReader)
  • public Task<T[]> QueryToArrayAsync<T>(Func<IDataReader, T> objectReader, CancellationToken cancellationToken)
  • public Task<T[]> QueryToArrayAsync<T>()
  • public Task<T[]> QueryToArrayAsync<T>(CancellationToken cancellationToken)
  • public Task<T[]> QueryToArrayAsync<T>(T template)
  • public Task<T[]> QueryToArrayAsync<T>(T template, CancellationToken cancellationToken)
  • public Task<List<T>> QueryToListAsync<T>(Func<IDataReader, T> objectReader)
  • public Task<List<T>> QueryToListAsync<T>(Func<IDataReader, T> objectReader, CancellationToken cancellationToken)
  • public Task<List<T>> QueryToListAsync<T>()
  • public Task<List<T>> QueryToListAsync<T>(CancellationToken cancellationToken)
  • public Task<List<T>> QueryToListAsync<T>(T template)
  • public Task<List<T>> QueryToListAsync<T>(T template, CancellationToken cancellationToken)
• public class TraceInfo
  • public bool BeforeExecute { get; }
  • public IDbCommand Command { get; set; }
  • public string CommandText { get; set; }
  • public DataConnection DataConnection { get; set; }
  • public Exception Exception { get; set; }
  • public TimeSpan? ExecutionTime { get; set; }
  • public bool IsAsync { get; set; }
  • public Expression MapperExpression { get; set; }
  • public int? RecordsAffected { get; set; }
  • public string SqlText { get; }
  • public DateTime? StartTime { get; set; }
  • public TraceInfoStep TraceInfoStep { get; }
  • public TraceLevel TraceLevel { get; set; }
  • public TraceInfo(TraceInfoStep traceInfoStep)
• public enum TraceInfoStep
  • AfterExecute = 1
  • BeforeExecute = 0
  • Completed = 4
  • Error = 2
  • MapperCreated = 3

LinqToDB.Data.DbCommandProcessor

• public static class DbCommandProcessorExtensions
  • public static IDbCommandProcessor Instance { get; set; }
  • public static int ExecuteNonQueryExt(this IDbCommand cmd)
  • public static Task<int> ExecuteNonQueryExtAsync(this DbCommand cmd, CancellationToken token)
  • public static DbDataReader ExecuteReaderExt(this IDbCommand cmd, CommandBehavior commandBehavior)
  • public static Task<DbDataReader> ExecuteReaderExtAsync(this DbCommand cmd, CommandBehavior commandBehavior, CancellationToken token)
  • public static object ExecuteScalarExt(this IDbCommand cmd)
  • public static Task<object> ExecuteScalarExtAsync(this DbCommand cmd, CancellationToken token)
• public interface IDbCommandProcessor
  • int ExecuteNonQuery(DbCommand command)
  • Task<int> ExecuteNonQueryAsync(DbCommand command, CancellationToken cancellationToken)
  • DbDataReader ExecuteReader(DbCommand command, CommandBehavior commandBehavior)
  • Task<DbDataReader> ExecuteReaderAsync(DbCommand command, CommandBehavior commandBehavior, CancellationToken cancellationToken)
  • object ExecuteScalar(DbCommand command)
  • Task<object> ExecuteScalarAsync(DbCommand command, CancellationToken cancellationToken)

LinqToDB.Data.RetryPolicy

• public interface IRetryPolicy
  • TResult Execute<TResult>(Func<TResult> operation)
  • void Execute(Action operation)
  • Task<TResult> ExecuteAsync<TResult>(Func<CancellationToken, Task<TResult>> operation, CancellationToken cancellationToken = default)
  • Task ExecuteAsync(Func<CancellationToken, Task> operation, CancellationToken cancellationToken = default)
• public class RetryLimitExceededException : LinqToDBException
  • public RetryLimitExceededException()
  • public RetryLimitExceededException(Exception innerException)
  • protected RetryLimitExceededException(SerializationInfo info, StreamingContext context)
• public abstract class RetryPolicyBase : IRetryPolicy
  • protected static bool Suspended { get; protected set; }
  • protected virtual List<Exception> ExceptionsEncountered { get; }
  • protected virtual int MaxRetryCount { get; }
  • protected virtual TimeSpan MaxRetryDelay { get; }
  • protected virtual Random Random { get; }
  • protected RetryPolicyBase(int maxRetryCount, TimeSpan maxRetryDelay)
  • public virtual TResult Execute<TResult>(Func<TResult> operation)
  • public virtual void Execute(Action operation)
  • public virtual Task<TResult> ExecuteAsync<TResult>(Func<CancellationToken, Task<TResult>> operation, CancellationToken cancellationToken = default)
  • public Task ExecuteAsync(Func<CancellationToken, Task> operation, CancellationToken cancellationToken = default)
  • protected virtual TimeSpan? GetNextDelay(Exception lastException)
  • protected virtual void OnFirstExecution()
  • protected virtual void OnRetry()
  • protected abstract bool ShouldRetryOn(Exception exception)

LinqToDB.DataProvider

• public class BasicBulkCopy
  • public BasicBulkCopy()
  • public virtual BulkCopyRowsCopied BulkCopy<T>(BulkCopyType bulkCopyType, ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • protected Func<IDbConnection, int, IDisposable> CreateBulkCopyCreator(Type connectionType, Type bulkCopyType, Type bulkCopyOptionType)
  • protected Action<object, Action<object>> CreateBulkCopySubscriber(object bulkCopy, string eventName)
  • protected Func<int, string, object> CreateColumnMappingCreator(Type columnMappingType)
  • protected virtual BulkCopyRowsCopied MultipleRowsCopy<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • protected BulkCopyRowsCopied MultipleRowsCopy1<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • protected BulkCopyRowsCopied MultipleRowsCopy1(MultipleRowsHelper helper, IEnumerable source)
  • protected virtual BulkCopyRowsCopied MultipleRowsCopy2<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source, string from)
  • protected BulkCopyRowsCopied MultipleRowsCopy2(MultipleRowsHelper helper, IEnumerable source, string from)
  • protected BulkCopyRowsCopied MultipleRowsCopy3(MultipleRowsHelper helper, BulkCopyOptions options, IEnumerable source, string from)
  • protected virtual BulkCopyRowsCopied ProviderSpecificCopy<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • protected virtual BulkCopyRowsCopied RowByRowCopy<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • protected void TraceAction(DataConnection dataConnection, Func<string> commandText, Func<int> action)
• public class BasicMerge
  • protected class ColumnInfo
  • protected string ByTargetText
  • protected List<ColumnInfo> Columns
  • protected List<DataParameter> Parameters
  • protected StringBuilder StringBuilder
  • protected virtual bool IsIdentitySupported { get; }
  • public BasicMerge()
  • protected virtual bool BuildCommand<T>(DataConnection dataConnection, Expression<Func<T, bool>> deletePredicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName)
  • protected virtual bool BuildUsing<T>(DataConnection dataConnection, IEnumerable<T> source)
  • protected bool BuildUsing2<T>(DataConnection dataConnection, IEnumerable<T> source, string top, string fromDummyTable)
  • protected virtual int Execute(DataConnection dataConnection)
  • protected virtual Task<int> ExecuteAsync(DataConnection dataConnection, CancellationToken token)
  • public virtual int Merge<T>(DataConnection dataConnection, Expression<Func<T, bool>> predicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName)
  • public virtual Task<int> MergeAsync<T>(DataConnection dataConnection, Expression<Func<T, bool>> predicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName, CancellationToken token)
• public class BasicMergeBuilder<TTarget, TSource>
  • protected readonly string SourceAlias
  • protected readonly string TargetAlias
  • protected virtual bool BySourceOperationsSupported { get; }
  • protected StringBuilder Command { get; }
  • protected IDataContext DataContext { get; }
  • protected virtual bool DeleteOperationSupported { get; }
  • protected virtual bool EmptySourceSupported { get; }
  • protected virtual string FakeSourceTable { get; }
  • protected virtual string FakeSourceTableDatabase { get; }
  • protected virtual string FakeSourceTableSchema { get; }
  • protected virtual bool IsIdentityInsertSupported { get; }
  • protected virtual int MaxOperationsCount { get; }
  • protected MergeDefinition<TTarget, TSource> Merge { get; }
  • protected virtual bool MergeHintsSupported { get; }
  • public bool NoopCommand { get; }
  • protected virtual bool OperationPredicateSupported { get; }
  • public DataParameter[] Parameters { get; }
  • protected string ProviderName { get; }
  • protected virtual bool ProviderUsesAlternativeUpdate { get; }
  • protected virtual bool SameTypeOperationsAllowed { get; }
  • protected BasicSqlBuilder SqlBuilder { get; }
  • protected virtual bool SupportsColumnAliasesInTableAlias { get; }
  • protected virtual bool SupportsParametersInSource { get; }
  • protected virtual bool SupportsSourceDirectValues { get; }
  • protected virtual bool SupportsSourceSubQuery { get; }
  • protected EntityDescriptor TargetDescriptor { get; }
  • protected string TargetTableName { get; }
  • protected virtual bool UpdateWithDeleteOperationSupported { get; }
  • public BasicMergeBuilder(DataConnection dataConnection, IMergeable<TTarget, TSource> merge)
  • protected virtual void AddFakeSourceTableName()
  • protected void AddParameter(DataParameter parameter)
  • protected virtual void AddSourceValue(ValueToSqlConverter valueConverter, ColumnDescriptor column, SqlDataType columnType, object value, bool isFirstRow, bool isLastRow)
  • protected void AddSourceValueAsParameter(DataType dataType, string dbType, int? size, object value)
  • protected void BuildColumnType(ColumnDescriptor column, SqlDataType columnType)
  • public virtual string BuildCommand()
  • protected void BuildCustomInsert(Expression<Func<TSource, TTarget>> create)
  • protected void BuildCustomUpdate(Expression<Func<TTarget, TSource, TTarget>> update)
  • protected void BuildDefaultInsert()
  • protected void BuildDefaultUpdate()
  • protected virtual void BuildDelete(Expression<Func<TTarget, TSource, bool>> predicate)
  • protected virtual void BuildInsert(Expression<Func<TSource, bool>> predicate, Expression<Func<TSource, TTarget>> create)
  • protected virtual void BuildMatch()
  • protected virtual void BuildMergeInto()
  • protected virtual void BuildOperation(Operation<TTarget, TSource> operation)
  • protected virtual void BuildPreambule()
  • protected void BuildPredicateByKeys(Type keyType, Expression targetKey, Expression sourceKey)
  • protected void BuildPredicateByTargetAndSource(Expression<Func<TTarget, TSource, bool>> predicate)
  • protected void BuildSingleTablePredicate<TTable>(Expression<Func<TTable, bool>> predicate, string tableAlias, bool isSource)
  • protected virtual void BuildTerminator()
  • protected virtual void BuildUpdate(Expression<Func<TTarget, TSource, bool>> predicate, Expression<Func<TTarget, TSource, TTarget>> update)
  • protected virtual void BuildUpdateWithDelete(Expression<Func<TTarget, TSource, bool>> updatePredicate, Expression<Func<TTarget, TSource, TTarget>> updateExpression, Expression<Func<TTarget, TSource, bool>> deletePredicate)
  • protected string GetNextParameterName()
  • protected Expression<Func<TTarget, TSource, bool>> MakeDefaultMatchPredicate()
  • protected virtual void OnInsertWithIdentity()
  • public virtual void Validate()
• public class BulkCopyReader : DbDataReader, IDataReader, IDataRecord, IDisposable
  • public class Parameter : IDbDataParameter, IDataParameter
  • public int Count
  • public BulkCopyReader(IDataProvider dataProvider, MappingSchema mappingSchema, List<ColumnDescriptor> columns, IEnumerable collection)
• public abstract class DataProviderBase : IDataProvider
  • protected static readonly int DefaultMaxRetryCount
  • public readonly ConcurrentDictionary<ReaderInfo, Expression> ReaderExpressions
  • public static Func<IDataProvider, IDbConnection, IDbConnection> OnConnectionCreated { get; set; }
  • public abstract string ConnectionNamespace { get; }
  • public abstract Type DataReaderType { get; }
  • public virtual MappingSchema MappingSchema { get; }
  • protected virtual int MaxRetryCount { get; }
  • public string Name { get; }
  • public SqlProviderFlags SqlProviderFlags { get; }
  • protected DataProviderBase(string name, MappingSchema mappingSchema)
  • public virtual BulkCopyRowsCopied BulkCopy<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • public virtual Type ConvertParameterType(Type type, DbDataType dataType)
  • public IDbConnection CreateConnection(string connectionString)
  • protected abstract IDbConnection CreateConnectionInternal(string connectionString)
  • public abstract ISqlBuilder CreateSqlBuilder(MappingSchema mappingSchema)
  • public virtual void DisposeCommand(DataConnection dataConnection)
  • public virtual IDisposable ExecuteScope()
  • protected bool FindExpression(ReaderInfo info, out Expression expr)
  • public virtual CommandBehavior GetCommandBehavior(CommandBehavior commandBehavior)
  • public virtual object GetConnectionInfo(DataConnection dataConnection, string parameterName)
  • protected virtual BasicMergeBuilder<TTarget, TSource> GetMergeBuilder<TTarget, TSource>(DataConnection connection, IMergeable<TTarget, TSource> merge)
  • public virtual Expression GetReaderExpression(MappingSchema mappingSchema, IDataReader reader, int idx, Expression readerExpression, Type toType)
  • public abstract ISchemaProvider GetSchemaProvider()
  • public abstract ISqlOptimizer GetSqlOptimizer()
  • public virtual void InitCommand(DataConnection dataConnection, CommandType commandType, string commandText, DataParameter[] parameters, bool withParameters)
  • public abstract bool IsCompatibleConnection(IDbConnection connection)
  • public virtual bool? IsDBNullAllowed(IDataReader reader, int idx)
  • public virtual int Merge<T>(DataConnection dataConnection, Expression<Func<T, bool>> deletePredicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName)
  • public int Merge<TTarget, TSource>(DataConnection dataConnection, IMergeable<TTarget, TSource> merge)
  • public virtual Task<int> MergeAsync<T>(DataConnection dataConnection, Expression<Func<T, bool>> deletePredicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName, CancellationToken token)
  • public Task<int> MergeAsync<TTarget, TSource>(DataConnection dataConnection, IMergeable<TTarget, TSource> merge, CancellationToken token)
  • protected virtual string NormalizeTypeName(string typeName)
  • protected void SetCharField(string dataTypeName, Expression<Func<IDataReader, int, string>> expr)
  • protected void SetCharFieldToType<T>(string dataTypeName, Expression<Func<IDataReader, int, string>> expr)
  • protected void SetField<TP, T>(Expression<Func<TP, int, T>> expr)
  • protected void SetField<TP, T>(string dataTypeName, Expression<Func<TP, int, T>> expr)
  • public virtual void SetParameter(IDbDataParameter parameter, string name, DbDataType dataType, object value)
  • protected virtual void SetParameterType(IDbDataParameter parameter, DbDataType dataType)
  • protected void SetProviderField<TP, T>(Expression<Func<TP, int, T>> expr)
  • protected void SetProviderField<TP, T, TS>(Expression<Func<TP, int, T>> expr)
  • protected void SetToType<TP, T, TF>(Expression<Func<TP, int, T>> expr)
• public class DataTools
  • public static Func<IDataReader, int, string> GetChar
  • public DataTools()
  • public static void ConvertCharToSql(StringBuilder stringBuilder, string startString, Action<StringBuilder, int> appendConversion, char value)
  • public static void ConvertStringToSql(StringBuilder stringBuilder, string plusOperator, string startPrefix, Action<StringBuilder, int> appendConversion, string value, char[] extraEscapes)
  • public static string EscapeUnterminatedBracket(string str)
• public abstract class DynamicDataProviderBase : DataProviderBase
  • protected static readonly object SyncRoot
  • protected abstract string ConnectionTypeName { get; }
  • protected abstract string DataReaderTypeName { get; }
  • protected DynamicDataProviderBase(string name, MappingSchema mappingSchema)
  • public static Expression<Func<string, IDbConnection>> CreateConnectionExpression(Type connectionType)
  • protected void EnsureConnection()
  • protected Action<IDbDataParameter, TResult> GetSetParameter<TResult>(Type connectionType, string parameterTypeName, string propertyName, Type dbType)
  • protected Action<IDbDataParameter> GetSetParameter(Type connectionType, string parameterTypeName, string propertyName, Type dbType, string valueName)
  • protected Action<IDbDataParameter> GetSetParameter(Type connectionType, string parameterTypeName, string propertyName, string dbTypeName, string valueName)
  • protected Func<IDbDataParameter, bool> IsGetParameter(Type connectionType, string parameterTypeName, string propertyName, string dbTypeName, string valueName)
  • protected abstract void OnConnectionTypeCreated(Type connectionType)
  • protected bool SetField(Type fieldType, string dataTypeName, string methodName, bool throwException = true)
  • protected void SetProviderField(Type fieldType, string methodName)
  • protected bool SetProviderField(Type toType, Type fieldType, string methodName, bool throwException = true)
  • protected void SetToTypeField(Type toType, string methodName)
• public interface IDataProvider
  • string ConnectionNamespace { get; }
  • Type DataReaderType { get; }
  • MappingSchema MappingSchema { get; }
  • string Name { get; }
  • SqlProviderFlags SqlProviderFlags { get; }
  • BulkCopyRowsCopied BulkCopy<T>(ITable<T> table, BulkCopyOptions options, IEnumerable<T> source)
  • Type ConvertParameterType(Type type, DbDataType dataType)
  • IDbConnection CreateConnection(string connectionString)
  • ISqlBuilder CreateSqlBuilder(MappingSchema mappingSchema)
  • void DisposeCommand(DataConnection dataConnection)
  • IDisposable ExecuteScope()
  • CommandBehavior GetCommandBehavior(CommandBehavior commandBehavior)
  • object GetConnectionInfo(DataConnection dataConnection, string parameterName)
  • Expression GetReaderExpression(MappingSchema mappingSchema, IDataReader reader, int idx, Expression readerExpression, Type toType)
  • ISchemaProvider GetSchemaProvider()
  • ISqlOptimizer GetSqlOptimizer()
  • void InitCommand(DataConnection dataConnection, CommandType commandType, string commandText, DataParameter[] parameters, bool withParameters)
  • bool IsCompatibleConnection(IDbConnection connection)
  • bool? IsDBNullAllowed(IDataReader reader, int idx)
  • int Merge<T>(DataConnection dataConnection, Expression<Func<T, bool>> predicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName)
  • int Merge<TTarget, TSource>(DataConnection dataConnection, IMergeable<TTarget, TSource> merge)
  • Task<int> MergeAsync<T>(DataConnection dataConnection, Expression<Func<T, bool>> predicate, bool delete, IEnumerable<T> source, string tableName, string databaseName, string schemaName, CancellationToken token)
  • Task<int> MergeAsync<TTarget, TSource>(DataConnection dataConnection, IMergeable<TTarget, TSource> merge, CancellationToken token)
  • void SetParameter(IDbDataParameter parameter, string name, DbDataType dataType, object value)
• public interface IDataProviderFactory
  • IDataProvider GetDataProvider(IEnumerable<NamedValue> attributes)
• public abstract class MultipleRowsHelper
  • public int BatchSize
  • public readonly ColumnDescriptor[] Columns
  • public readonly SqlDataType[] ColumnTypes
  • public int CurrentCount
  • public readonly DataConnection DataConnection
  • public readonly EntityDescriptor Descriptor
  • public int HeaderSize
  • public readonly BulkCopyOptions Options
  • public int ParameterIndex
  • public readonly string ParameterName
  • public readonly List<DataParameter> Parameters
  • public readonly BulkCopyRowsCopied RowsCopied
  • public readonly ISqlBuilder SqlBuilder
  • public readonly StringBuilder StringBuilder
  • public string TableName
  • public readonly ValueToSqlConverter ValueConverter
  • protected MultipleRowsHelper(DataConnection dataConnection, BulkCopyOptions options, Type entityType)
  • public virtual void BuildColumns(object item, Func<ColumnDescriptor, bool> skipConvert = null)
  • public bool Execute()
  • public void SetHeader()
• public class MultipleRowsHelper<T> : MultipleRowsHelper
  • public MultipleRowsHelper(ITable<T> table, BulkCopyOptions options)
• public class ReaderInfo : IEquatable<ReaderInfo>
  • public string DataTypeName { get; set; }
  • public Type FieldType { get; set; }
  • public Type ProviderFieldType { get; set; }
  • public Type ToType { get; set; }
  • public ReaderInfo()
  • public bool Equals(ReaderInfo other)

LinqToDB.DataProvider.DB2

• public class ConnectionTypeTypeCreator<T> : TypeCreatorNoDefault<T>
  • public ConnectionTypeTypeCreator()
  • public object CreateInstance(DataConnection value)
• public class DB2DataProvider : DynamicDataProviderBase
  • public DB2Version Version { get; }
  • public DB2DataProvider(string name, DB2Version version)
• public enum DB2IdentifierQuoteMode
  • Auto = 2
  • None = 0
  • Quote = 1
• public class DB2LUWMappingSchema : MappingSchema
  • public DB2LUWMappingSchema()
• public class DB2MappingSchema : MappingSchema
  • public DB2MappingSchema()
  • protected DB2MappingSchema(string configuration)
• public static class DB2Tools
  • public static string AssemblyName
  • public static bool IsCore
  • public static bool AutoDetectProvider { get; set; }
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static void AfterInitialized(Action action)
  • public static DataConnection CreateDataConnection(string connectionString, DB2Version version = 0)
  • public static DataConnection CreateDataConnection(IDbConnection connection, DB2Version version = 0)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction, DB2Version version = 0)
  • public static IDataProvider GetDataProvider(DB2Version version = 0)
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static BulkCopyRowsCopied ProviderSpecificBulkCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int? bulkCopyTimeout = default, bool keepIdentity = false, int notifyAfter = 0, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveDB2(string path)
  • public static void ResolveDB2(Assembly assembly)
• public class DB2Types
  • public static readonly TypeCreator<byte[]> DB2Binary
  • public static readonly ConnectionTypeTypeCreator<byte[]> DB2Blob
  • public static readonly ConnectionTypeTypeCreator<string> DB2Clob
  • public static readonly TypeCreator<DateTime> DB2Date
  • public static readonly TypeCreator<DateTime, long> DB2DateTime
  • public static readonly TypeCreator<decimal> DB2Decimal
  • public static readonly TypeCreator<decimal, double, long> DB2DecimalFloat
  • public static readonly TypeCreator<double> DB2Double
  • public static readonly TypeCreator<short> DB2Int16
  • public static readonly TypeCreator<int> DB2Int32
  • public static readonly TypeCreator<long> DB2Int64
  • public static readonly TypeCreator<float> DB2Real
  • public static readonly TypeCreator<double> DB2Real370
  • public static readonly TypeCreator DB2RowId
  • public static readonly TypeCreator<string> DB2String
  • public static readonly TypeCreator<TimeSpan> DB2Time
  • public static readonly TypeCreator<DateTime> DB2TimeStamp
  • public static Type DB2Xml
  • public static Type ConnectionType { get; }
  • public DB2Types()
• public enum DB2Version
  • LUW = 0
  • zOS = 1
• public class DB2zOSMappingSchema : MappingSchema
  • public DB2zOSMappingSchema()
• public class TypeCreator : TypeCreatorBase
  • public TypeCreator()
  • public object CreateInstance()
• public class TypeCreator<T> : TypeCreator
  • public TypeCreator()
  • public object CreateInstance(T value)
• public class TypeCreator<T1, T> : TypeCreator<T1>
  • public TypeCreator()
  • public object CreateInstance(T value)
• public class TypeCreator<T1, T2, T> : TypeCreator<T1, T2>
  • public TypeCreator()
  • public object CreateInstance(T value)
• public abstract class TypeCreatorBase
  • public Type Type
  • public bool IsSupported { get; }
  • protected TypeCreatorBase()
  • public static Type op_Implicit(TypeCreatorBase typeCreator)
  • protected Func<T, object> GetCreator<T>()
  • protected Func<T, object> GetCreator<T>(Type paramType)
• public class TypeCreatorNoDefault<T> : TypeCreatorBase
  • public TypeCreatorNoDefault()
  • public object CreateInstance(T value)

LinqToDB.DataProvider.Firebird

• public static class FirebirdConfiguration
  • public static bool IsLiteralEncodingSupported
  • public static bool QuoteIdentifiers { get; set; }
• public class FirebirdDataProvider : DynamicDataProviderBase
  • public FirebirdDataProvider()
  • public FirebirdDataProvider(ISqlOptimizer sqlOptimizer)
  • protected FirebirdDataProvider(string name, MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer)
• public enum FirebirdIdentifierQuoteMode
  • Auto = 2
  • None = 0
  • Quote = 1
• public class FirebirdMappingSchema : MappingSchema
  • public FirebirdMappingSchema()
  • protected FirebirdMappingSchema(string configuration)
• public class FirebirdSqlBuilder : BasicSqlBuilder
  • public static FirebirdIdentifierQuoteMode IdentifierQuoteMode
  • public FirebirdSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
• public class FirebirdSqlOptimizer : BasicSqlOptimizer
  • public FirebirdSqlOptimizer(SqlProviderFlags sqlProviderFlags)
• public static class FirebirdTools
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static void ClearAllPools()
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveFirebird(string path)
  • public static void ResolveFirebird(Assembly assembly)

LinqToDB.DataProvider.Informix

• public static class InformixConfiguration
  • public static bool ExplicitFractionalSecondsSeparator
• public class InformixDataProvider : DynamicDataProviderBase
  • public InformixDataProvider()
  • protected InformixDataProvider(string name, MappingSchema mappingSchema)
• public class InformixMappingSchema : MappingSchema
  • public InformixMappingSchema()
  • protected InformixMappingSchema(string configuration)
• public static class InformixTools
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveInformix(string path)
  • public static void ResolveInformix(Assembly assembly)

LinqToDB.DataProvider.MySql

• public interface IMySqlExtensions
• public class MySqlDataProvider : DynamicDataProviderBase
  • public MySqlDataProvider()
  • public MySqlDataProvider(string name)
  • protected MySqlDataProvider(string name, MappingSchema mappingSchema)
• public static class MySqlExtensions
  • public enum MatchModifier
  • public static bool Match(this IMySqlExtensions ext, string search, object[] columns)
  • public static bool Match(this IMySqlExtensions ext, MatchModifier modifier, string search, object[] columns)
  • public static double MatchRelevance(this IMySqlExtensions ext, string search, object[] columns)
  • public static double MatchRelevance(this IMySqlExtensions ext, MatchModifier modifier, string search, object[] columns)
  • public static IMySqlExtensions MySql(this ISqlExtension ext)
• public class MySqlMappingSchema : MappingSchema
  • public class MySqlConnectorMappingSchema : MappingSchema
  • public class MySqlOfficialMappingSchema : MappingSchema
  • public MySqlMappingSchema()
  • protected MySqlMappingSchema(string configuration)
• public static class MySqlTools
  • public static string AssemblyName
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static string DetectedProviderName { get; }
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveMySql(string path)
  • public static void ResolveMySql(Assembly assembly)

LinqToDB.DataProvider.Oracle

• public enum AlternativeBulkCopy
  • InsertAll = 0
  • InsertDual = 2
  • InsertInto = 1
• public class OracleDataProvider : DynamicDataProviderBase
  • public string AssemblyName { get; }
  • public bool IsXmlTypeSupported { get; }
  • public OracleDataProvider()
  • public OracleDataProvider(string name)
• public class OracleMappingSchema : MappingSchema
  • public class ManagedMappingSchema : MappingSchema
  • public class NativeMappingSchema : MappingSchema
  • public OracleMappingSchema()
  • protected OracleMappingSchema(string configuration)
• public class OracleSqlOptimizer : BasicSqlOptimizer
  • public OracleSqlOptimizer(SqlProviderFlags sqlProviderFlags)
• public static class OracleTools
  • public static string AssemblyName
  • public static Func<IDataReader, int, decimal> DataReaderGetDecimal
  • public static AlternativeBulkCopy UseAlternativeBulkCopy
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static string DetectedProviderName { get; }
  • public static bool DontEscapeLowercaseIdentifiers { get; set; }
  • public static bool IsXmlTypeSupported { get; }
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static string GetXmlData<T>(MappingSchema mappingSchema, IEnumerable<T> data)
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(this DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, IEnumerable<T> data)
  • public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, string xmlData)
  • public static ITable<T> OracleXmlTable<T>(this IDataContext dataContext, Func<string> xmlData)
  • public static BulkCopyRowsCopied ProviderSpecificBulkCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int? maxBatchSize = default, int? bulkCopyTimeout = default, int notifyAfter = 0, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveOracle(string path)
  • public static void ResolveOracle(Assembly assembly)

LinqToDB.DataProvider.PostgreSQL

• public class PostgreSQLDataProvider : DynamicDataProviderBase
  • public PostgreSQLVersion Version { get; }
  • public PostgreSQLDataProvider(PostgreSQLVersion version = 0)
  • public PostgreSQLDataProvider(string providerName, PostgreSQLVersion version)
  • protected PostgreSQLDataProvider(string name, MappingSchema mappingSchema, PostgreSQLVersion version = 0)
• public enum PostgreSQLIdentifierQuoteMode
  • Auto = 3
  • Needed = 2
  • None = 0
  • Quote = 1
• public class PostgreSQLMappingSchema : MappingSchema
  • public PostgreSQLMappingSchema()
  • protected PostgreSQLMappingSchema(string configuration)
• public class PostgreSQLSchemaProvider : SchemaProviderBase
  • public PostgreSQLSchemaProvider(PostgreSQLDataProvider provider)
• public class PostgreSQLSqlBuilder : BasicSqlBuilder
  • public static PostgreSQLIdentifierQuoteMode IdentifierQuoteMode
  • public PostgreSQLSqlBuilder(PostgreSQLDataProvider provider, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
  • public PostgreSQLSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
• public static class PostgreSQLTools
  • public static bool AutoDetectProvider { get; set; }
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static DataConnection CreateDataConnection(string connectionString, PostgreSQLVersion version = 0)
  • public static DataConnection CreateDataConnection(IDbConnection connection, PostgreSQLVersion version = 0)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction, PostgreSQLVersion version = 0)
  • public static Type GetBitStringType()
  • public static IDataProvider GetDataProvider(PostgreSQLVersion version = 0)
  • public static Type GetNpgsqlBoxType()
  • public static Type GetNpgsqlCircleType()
  • public static Type GetNpgsqlDateTimeType()
  • public static Type GetNpgsqlDateType()
  • public static Type GetNpgsqlInetType()
  • public static Type GetNpgsqlIntervalType()
  • public static Type GetNpgsqlLineType()
  • public static Type GetNpgsqlLSegType()
  • public static Type GetNpgsqlMacAddressType()
  • public static Type GetNpgsqlPathType()
  • public static Type GetNpgsqlPointType()
  • public static Type GetNpgsqlPolygonType()
  • public static Type GetNpgsqlTimeType()
  • public static Type GetNpgsqlTimeTZType()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolvePostgreSQL(string path)
  • public static void ResolvePostgreSQL(Assembly assembly)
• public enum PostgreSQLVersion
  • v92 = 0
  • v93 = 1
  • v95 = 2

LinqToDB.DataProvider.SQLite

• public interface ISQLiteExtensions
• public class SQLiteDataProvider : DynamicDataProviderBase
  • public SQLiteDataProvider()
  • public SQLiteDataProvider(string name)
  • protected SQLiteDataProvider(string name, MappingSchema mappingSchema)
  • public void CreateDatabase(string databaseName, bool deleteIfExists = false)
  • public void DropDatabase(string databaseName)
• public static class SQLiteExtensions
  • public static void FTS3AutoMerge<TEntity>(this DataConnection dc, ITable<TEntity> table, int segments)
  • public static void FTS3IntegrityCheck<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static byte[] FTS3MatchInfo<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static byte[] FTS3MatchInfo<TEntity>(this ISQLiteExtensions ext, TEntity entity, string format)
  • public static void FTS3Merge<TEntity>(this DataConnection dc, ITable<TEntity> table, int blocks, int segments)
  • public static string FTS3Offsets<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static void FTS3Optimize<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static void FTS3Rebuild<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, string startMatch)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, string startMatch, string endMatch)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, string startMatch, string endMatch, string ellipses)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, string startMatch, string endMatch, string ellipses, int columnIndex)
  • public static string FTS3Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, string startMatch, string endMatch, string ellipses, int columnIndex, int tokensNumber)
  • public static void FTS5AutoMerge<TEntity>(this DataConnection dc, ITable<TEntity> table, int value)
  • public static double FTS5bm25<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static double FTS5bm25<TEntity>(this ISQLiteExtensions ext, TEntity entity, double[] weights)
  • public static void FTS5CrisisMerge<TEntity>(this DataConnection dc, ITable<TEntity> table, int value)
  • public static void FTS5Delete<TEntity>(this DataConnection dc, ITable<TEntity> table, int rowid, TEntity record)
  • public static void FTS5DeleteAll<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static string FTS5Highlight<TEntity>(this ISQLiteExtensions ext, TEntity entity, int columnIndex, string startMatch, string endMatch)
  • public static void FTS5IntegrityCheck<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static void FTS5Merge<TEntity>(this DataConnection dc, ITable<TEntity> table, int value)
  • public static void FTS5Optimize<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static void FTS5Pgsz<TEntity>(this DataConnection dc, ITable<TEntity> table, int value)
  • public static void FTS5Rank<TEntity>(this DataConnection dc, ITable<TEntity> table, string function)
  • public static void FTS5Rebuild<TEntity>(this DataConnection dc, ITable<TEntity> table)
  • public static string FTS5Snippet<TEntity>(this ISQLiteExtensions ext, TEntity entity, int columnIndex, string startMatch, string endMatch, string ellipses, int tokensNumber)
  • public static void FTS5UserMerge<TEntity>(this DataConnection dc, ITable<TEntity> table, int value)
  • public static bool Match(this ISQLiteExtensions ext, object entityOrColumn, string match)
  • public static IQueryable<TEntity> MatchTable<TEntity>(this ISQLiteExtensions ext, ITable<TEntity> table, string match)
  • public static double? Rank<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static int RowId<TEntity>(this ISQLiteExtensions ext, TEntity entity)
  • public static ISQLiteExtensions SQLite(this ISqlExtension ext)
• public class SQLiteMappingSchema : MappingSchema
  • public class ClassicMappingSchema : MappingSchema
  • public class MicrosoftMappingSchema : MappingSchema
  • public SQLiteMappingSchema()
  • protected SQLiteMappingSchema(string configuration)
• public class SQLiteSqlBuilder : BasicSqlBuilder
  • public SQLiteSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
• public static class SQLiteTools
  • public static bool AlwaysCheckDbNull
  • public static string AssemblyName
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static string DetectedProviderName { get; }
  • public static void CreateDatabase(string databaseName, bool deleteIfExists = false)
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static void DropDatabase(string databaseName)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveSQLite(string path)
  • public static void ResolveSQLite(Assembly assembly)

LinqToDB.DataProvider.SapHana

• public class CalculationViewInputParametersExpressionAttribute : TableExpressionAttribute
  • public CalculationViewInputParametersExpressionAttribute()
• public class GetHanaSchemaOptions : GetSchemaOptions
  • public Func<ProcedureSchema, DataParameter[]> GetStoredProcedureParameters
  • public bool ThrowExceptionIfCalculationViewsNotAuthorized
  • public GetHanaSchemaOptions()
• public class SapHanaDataProvider : DynamicDataProviderBase
  • public SapHanaDataProvider()
  • protected SapHanaDataProvider(string name, MappingSchema mappingSchema)
• public class SapHanaMappingSchema : MappingSchema
  • public SapHanaMappingSchema()
  • protected SapHanaMappingSchema(string configuration)
• public static class SapHanaTools
  • public static string AssemblyName
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static void ResolveSapHana(string path)
  • public static void ResolveSapHana(Assembly assembly)
• public class ViewWithParametersTableSchema : TableSchema
  • public List<ParameterSchema> Parameters { get; set; }
  • public ViewWithParametersTableSchema()

LinqToDB.DataProvider.SqlCe

• public static class SqlCeConfiguration
  • public static bool InlineFunctionParameters
• public class SqlCeDataProvider : DynamicDataProviderBase
  • public SqlCeDataProvider()
  • protected SqlCeDataProvider(string name, MappingSchema mappingSchema)
  • public void CreateDatabase(string databaseName, bool deleteIfExists = false)
  • public void DropDatabase(string databaseName)
• public class SqlCeMappingSchema : MappingSchema
  • public SqlCeMappingSchema()
  • protected SqlCeMappingSchema(string configuration)
• public static class SqlCeTools
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static void CreateDatabase(string databaseName, bool deleteIfExists = false)
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static void DropDatabase(string databaseName)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveSqlCe(string path)
  • public static void ResolveSqlCe(Assembly assembly)

LinqToDB.DataProvider.SqlServer

• public class FreeTextTableExpressionAttribute : TableExpressionAttribute
  • public FreeTextTableExpressionAttribute()
• public interface ISqlServerExtensions
• public class SqlServer2000MappingSchema : MappingSchema
  • public SqlServer2000MappingSchema()
• public class SqlServer2005MappingSchema : MappingSchema
  • public SqlServer2005MappingSchema()
• public class SqlServer2008MappingSchema : MappingSchema
  • public SqlServer2008MappingSchema()
• public class SqlServer2012MappingSchema : MappingSchema
  • public SqlServer2012MappingSchema()
• public class SqlServer2017MappingSchema : MappingSchema
  • public SqlServer2017MappingSchema()
• public static class SqlServerConfiguration
  • public static bool GenerateScopeIdentity
• public class SqlServerDataProvider : DataProviderBase
  • public SqlServerVersion Version { get; }
  • public SqlServerDataProvider(string name, SqlServerVersion version)
  • public void AddUdtType(Type type, string udtName)
  • public void AddUdtType<T>(string udtName, T defaultValue, DataType dataType = 0)
• public static class SqlServerExtensions
  • public class FreeTextKey<TKey>
  • public static bool Contains<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search)
  • public static bool Contains<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search, object[] columns)
  • public static bool ContainsProperty(this ISqlServerExtensions ext, object column, string property, string search)
  • public static bool ContainsPropertyWithLanguage(this ISqlServerExtensions ext, object column, string property, string search, string language)
  • public static bool ContainsPropertyWithLanguage(this ISqlServerExtensions ext, object column, string property, string search, int language)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, string language)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, string language, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int language, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string search, int language)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, string language, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, string language)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int language, int top)
  • public static IQueryable<FreeTextKey<TKey>> ContainsTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string search, int language)
  • public static bool ContainsWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search, string language)
  • public static bool ContainsWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search, int language)
  • public static bool ContainsWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search, string language, object[] columns)
  • public static bool ContainsWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string search, int language, object[] columns)
  • public static bool FreeText<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term)
  • public static bool FreeText<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term, object[] columns)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTable<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, string language)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, string language, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int language, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, string term, int language)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, string language)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, string language, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int language, int top)
  • public static IQueryable<FreeTextKey<TKey>> FreeTextTableWithLanguage<TTable, TKey>(this ISqlServerExtensions ext, ITable<TTable> table, Expression<Func<TTable, object>> columns, string term, int language)
  • public static bool FreeTextWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term, string language)
  • public static bool FreeTextWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term, int language)
  • public static bool FreeTextWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term, string language, object[] columns)
  • public static bool FreeTextWithLanguage<TEntity>(this ISqlServerExtensions ext, TEntity entity, string term, int language, object[] columns)
  • public static ISqlServerExtensions SqlServer(this ISqlExtension ext)
• public class SqlServerMappingSchema : MappingSchema
  • public SqlServerMappingSchema()
• public class SqlServerRetryPolicy : RetryPolicyBase
  • public SqlServerRetryPolicy()
  • public SqlServerRetryPolicy(int maxRetryCount)
  • public SqlServerRetryPolicy(int maxRetryCount, TimeSpan maxRetryDelay, ICollection<int> errorNumbersToAdd)
• public static class SqlServerTools
  • public static class Sql
  • public static Func<IDataReader, int, decimal> DataReaderGetDecimal
  • public static Func<IDataReader, int, decimal> DataReaderGetMoney
  • public static bool AutoDetectProvider { get; set; }
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static void AddUdtType(Type type, string udtName)
  • public static void AddUdtType<T>(string udtName, T nullValue, DataType dataType = 0)
  • public static DataConnection CreateDataConnection(string connectionString, SqlServerVersion version = 2)
  • public static DataConnection CreateDataConnection(IDbConnection connection, SqlServerVersion version = 2)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction, SqlServerVersion version = 2)
  • public static IDataProvider GetDataProvider(SqlServerVersion version = 2)
  • public static BulkCopyRowsCopied ProviderSpecificBulkCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int? maxBatchSize = default, int? bulkCopyTimeout = default, bool keepIdentity = false, bool checkConstraints = false, int notifyAfter = 0, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveSqlTypes(string path)
  • public static void ResolveSqlTypes(Assembly assembly)
  • public static void SetIdentityInsert<T>(this DataConnection dataConnection, ITable<T> table, bool isOn)
  • public static void SetSqlTypes(Type sqlHierarchyIdType, Type sqlGeographyType, Type sqlGeometryType)
• public class SqlServerTransientExceptionDetector
  • public SqlServerTransientExceptionDetector()
  • public static bool ShouldRetryOn(Exception ex)
• public enum SqlServerVersion
  • v2000 = 0
  • v2005 = 1
  • v2008 = 2
  • v2012 = 3
  • v2017 = 4

LinqToDB.DataProvider.Sybase

• public class SybaseDataProvider : DynamicDataProviderBase
  • public string AssemblyName { get; }
  • public SybaseDataProvider()
  • public SybaseDataProvider(string name)
• public class SybaseMappingSchema : MappingSchema
  • public class ManagedMappingSchema : MappingSchema
  • public class NativeMappingSchema : MappingSchema
  • public SybaseMappingSchema()
  • protected SybaseMappingSchema(string configuration)
• public static class SybaseTools
  • public static string AssemblyName
  • public static string NativeAssemblyName
  • public static BulkCopyType DefaultBulkCopyType { get; set; }
  • public static string DetectedProviderName { get; }
  • public static DataConnection CreateDataConnection(string connectionString)
  • public static DataConnection CreateDataConnection(IDbConnection connection)
  • public static DataConnection CreateDataConnection(IDbTransaction transaction)
  • public static IDataProvider GetDataProvider()
  • public static BulkCopyRowsCopied MultipleRowsCopy<T>(DataConnection dataConnection, IEnumerable<T> source, int maxBatchSize = 1000, Action<BulkCopyRowsCopied> rowsCopiedCallback = null)
  • public static void ResolveSybase(string path)
  • public static void ResolveSybase(Assembly assembly)

LinqToDB.Expressions

• public class DefaultValueExpression : Expression
  • public DefaultValueExpression(MappingSchema mappingSchema, Type type)
• public class ExpressionGenerator
  • public Expression ResultExpression { get; }
  • public ExpressionGenerator(TypeMapper mapper)
  • public ExpressionGenerator()
  • public static Expression Build(Action<ExpressionGenerator> buildFunc, TypeMapper typeMapper = null)
  • public Expression AddExpression(Expression expression)
  • public Expression Assign(Expression left, Expression right)
  • public ParameterExpression AssignToVariable(Expression expression, string name = null)
  • public Expression Build()
  • public ParameterExpression DeclareVariable(Type type, string name = null)
  • public Expression IfThen(Expression test, Expression ifTrue)
  • public Expression IfThenElse(Expression test, Expression ifTrue, Expression ifFalse)
  • public Expression MapExpression<TR>(Expression<Func<TR>> func)
  • public Expression MapExpression<T, TR>(Expression<Func<T, TR>> func, Expression p)
  • public Expression MapExpression<T1, T2, TR>(Expression<Func<T1, T2, TR>> func, Expression p1, Expression p2)
  • public Expression MapExpression<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> func, Expression p1, Expression p2, Expression p3)
  • public Expression MapExpression<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> func, Expression p1, Expression p2, Expression p3, Expression p4)
  • public Expression MapExpression<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> func, Expression p1, Expression p2, Expression p3, Expression p4, Expression p5)
  • public MemberExpression MemberAccess<T>(Expression<Func<T, object>> memberExpression, Expression obj)
  • public Expression Throw(Expression expression)
  • public Expression TryCatch(Expression body, CatchBlock[] catchBlocks)
• public static class Extensions
  • public static Expression Find(this Expression expr, Expression exprToFind)
  • public static Expression Find(this Expression expr, Func<Expression, bool> func)
  • public static Expression GetBody(this LambdaExpression lambda, Expression exprToReplaceParameter)
  • public static Expression GetBody(this LambdaExpression lambda, Expression exprToReplaceParameter1, Expression exprToReplaceParameter2)
  • public static Expression GetBody(this LambdaExpression lambda, Expression exprToReplaceParameter1, Expression exprToReplaceParameter2, Expression exprToReplaceParameter3)
  • public static int GetCount(this Expression expr, Func<Expression, bool> func)
  • public static string GetDebugView(this Expression expression)
  • public static Expression Transform(this Expression expr, Func<Expression, Expression> func)
  • public static Expression Transform(this Expression expr, Func<Expression, TransformInfo> func)
  • public static void Visit(this Expression expr, Action<Expression> func)
  • public static void Visit(this Expression expr, Func<Expression, bool> func)
• public interface IGenericInfoProvider
  • void SetInfo(MappingSchema mappingSchema)
• public static class MemberHelper
  • public static ConstructorInfo ConstructorOf<T>(Expression<Func<T, object>> func)
  • public static ConstructorInfo ConstructorOf(Expression<Func<object>> func)
  • public static FieldInfo FieldOf<T>(Expression<Func<T, object>> func)
  • public static MemberInfo GetMemberInfo(LambdaExpression func)
  • public static MemberInfo GetMemberInfo(Expression expr)
  • public static MemberInfo MemberOf<T>(Expression<Func<T, object>> func)
  • public static MethodInfo MethodOf<T>(Expression<Func<T, object>> func)
  • public static MethodInfo MethodOf(Expression<Func<object>> func)
  • public static MethodInfo MethodOf(Expression<Action> func)
  • public static PropertyInfo PropertyOf<T>(Expression<Func<T, object>> func)
• public class SqlQueryDependentAttribute : Attribute
  • public SqlQueryDependentAttribute()
  • public virtual bool ExpressionsEqual(Expression expr1, Expression expr2, Func<Expression, Expression, bool> comparer)
  • public virtual bool ObjectsEqual(object obj1, object obj2)
  • public virtual Expression PrepareForCache(Expression expression)
• public struct TransformInfo
  • public Expression Expression
  • public bool Stop
  • public TransformInfo(Expression expression, bool stop)
  • public TransformInfo(Expression expression)
• public sealed class TypeMapper
  • public class MemberBuilder<T, TV>
  • public class TypeBuilder<T>
  • public Type[] Types { get; }
  • public TypeMapper(Type[] types)
  • public object Evaluate<T>(object instance, Expression<Func<T, object>> func)
  • public object Evaluate<T>(T instance, Expression<Func<T, object>> func) where T : TypeWrapper
  • public Type FindReplacement(Type type)
  • public Expression MapExpression<TR>(Expression<Func<TR>> func)
  • public Expression MapExpression<T, TR>(Expression<Func<T, TR>> func, Expression p)
  • public Expression MapExpression<T1, T2, TR>(Expression<Func<T1, T2, TR>> func, Expression p1, Expression p2)
  • public Expression MapExpression<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> func, Expression p1, Expression p2, Expression p3)
  • public Expression MapExpression<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> func, Expression p1, Expression p2, Expression p3, Expression p4)
  • public Expression MapExpression<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> func, Expression p1, Expression p2, Expression p3, Expression p4, Expression p5)
  • public LambdaExpression MapLambda<T, TR>(Expression<Func<T, TR>> func)
  • public LambdaExpression MapLambda<T1, T2, TR>(Expression<Func<T1, T2, TR>> func)
  • public LambdaExpression MapLambda<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> func)
  • public LambdaExpression MapLambda<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> func)
  • public LambdaExpression MapLambda<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> func)
  • public LambdaExpression MapSetter<T>(Expression<Func<T, object>> propExpression, Expression<Func<object>> valueExpression)
  • public LambdaExpression MapSetterValue<T, TV>(Expression<Func<T, TV>> propExpression, TV value)
  • public MemberExpression MemberAccess<T>(Expression<Func<T, object>> memberExpression, Expression obj)
  • public void SetValue<T>(object instance, Expression<Func<T, object>> propExpression, object value)
  • public void SetValue<T, TV>(object instance, Expression<Func<T, TV>> propExpression, TV value)
  • public Expression Throw<TR>(Expression<Func<TR>> newExpr)
  • public Expression Throw<T1, TR>(Expression<Func<T1, TR>> newExpr, Expression p)
  • public Expression Throw<T1, T2, TR>(Expression<Func<T1, T2, TR>> newExpr, Expression p1, Expression p2)
  • public Expression Throw<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> newExpr, Expression p1, Expression p2, Expression p3)
  • public TypeBuilder<T> Type<T>()
  • public TR Wrap<T, TR>(T instance, Expression<Func<T, TR>> func) where T : TypeWrapper
  • public TR Wrap<TR>(object instance) where TR : TypeWrapper
• public class TypeWrapper
  • public object instance_ { get; }
  • public TypeMapper mapper_ { get; }
  • public TypeWrapper()
  • public TypeWrapper(object instance, TypeMapper mapper)
• public static class TypeWrapperExtensions
  • public static object Evaluate<T>(this T instance, Expression<Func<T, object>> func) where T : TypeWrapper
  • public static void SetPropValue<T, TV>(this T instance, Expression<Func<T, TV>> propExpression, TV value) where T : TypeWrapper
  • public static TR Wrap<T, TR>(this T instance, Expression<Func<T, TR>> func) where T : TypeWrapper
• public class WrapperAttribute : Attribute
  • public WrapperAttribute()

LinqToDB.Extensions

• public static class ReflectionExtensions
  • public static Type AsNullable(this Type type)
  • public static Assembly AssemblyEx(this Type type)
  • public static Type BaseTypeEx(this Type type)
  • public static bool CanConvertTo(this Type fromType, Type toType)
  • public static bool EqualsTo(this MemberInfo member1, MemberInfo member2, Type declaringType = null)
  • public static T[] GetAttributes<T>(this Type type) where T : Attribute
  • public static ConstructorInfo GetConstructorEx(this Type type, Type[] parameterTypes)
  • public static ConstructorInfo[] GetConstructorsEx(this Type type)
  • public static object[] GetCustomAttributesEx(this Type type, Type attributeType, bool inherit)
  • public static object[] GetCustomAttributesEx(this Type type, bool inherit)
  • public static object[] GetCustomAttributesEx(this MemberInfo memberInfo, Type attributeType, bool inherit)
  • public static object[] GetCustomAttributesEx(this MemberInfo memberInfo, bool inherit)
  • public static object[] GetCustomAttributesEx(this ParameterInfo parameterInfo, bool inherit)
  • public static ConstructorInfo GetDefaultConstructorEx(this Type type)
  • public static object GetDefaultValue(this Type type)
  • public static IEnumerable<Type> GetDefiningTypes(this Type child, MemberInfo member)
  • public static EventInfo GetEventEx(this Type type, string eventName)
  • public static FieldInfo GetFieldEx(this Type type, string propertyName)
  • public static FieldInfo[] GetFieldsEx(this Type type)
  • public static T GetFirstAttribute<T>(this Type type) where T : Attribute
  • public static Type[] GetGenericArguments(this Type type, Type baseType)
  • public static Type[] GetGenericArgumentsEx(this Type type)
  • public static Type GetGenericType(this Type genericType, Type type)
  • public static MethodInfo GetGetMethodEx(this PropertyInfo propertyInfo, bool nonPublic)
  • public static MethodInfo GetGetMethodEx(this PropertyInfo propertyInfo)
  • public static MemberInfo[] GetInstanceMemberEx(this Type type, string name)
  • public static InterfaceMapping GetInterfaceMapEx(this Type type, Type interfaceType)
  • public static Type[] GetInterfacesEx(this Type type)
  • public static Type GetItemType(this Type type)
  • public static Type GetListItemType(this IEnumerable list)
  • public static Type GetListItemType(this Type listType)
  • public static MemberInfo GetMemberEx(this Type type, MemberInfo memberInfo)
  • public static Type GetMemberType(this MemberInfo memberInfo)
  • public static MethodInfo GetMethodEx(this Type type, string name, Type[] types)
  • public static MethodInfo GetMethodEx(this Type type, string name)
  • public static MethodInfo[] GetMethodsEx(this Type type)
  • public static PropertyInfo[] GetNonPublicPropertiesEx(this Type type)
  • public static PropertyInfo[] GetPropertiesEx(this Type type)
  • public static PropertyInfo[] GetPropertiesEx(this Type type, BindingFlags flags)
  • public static PropertyInfo GetPropertyEx(this Type type, string propertyName)
  • public static PropertyInfo GetPropertyInfo(this MethodInfo method)
  • public static MemberInfo[] GetPublicInstanceMembersEx(this Type type)
  • public static MethodInfo GetPublicInstanceMethodEx(this Type type, string name, Type[] types)
  • public static MemberInfo[] GetPublicInstanceValueMembers(this Type type)
  • public static MemberInfo[] GetPublicMemberEx(this Type type, string name)
  • public static MethodInfo GetSetMethodEx(this PropertyInfo propertyInfo, bool nonPublic)
  • public static MethodInfo GetSetMethodEx(this PropertyInfo propertyInfo)
  • public static MemberInfo[] GetStaticMembersEx(this Type type, string name)
  • public static TypeCode GetTypeCodeEx(this Type type)
  • public static bool IsAbstractEx(this Type type)
  • public static bool IsAnonymous(this Type type)
  • public static bool IsAssignableFromEx(this Type type, Type c)
  • public static bool IsClassEx(this Type type)
  • public static bool IsDynamicColumnPropertyEx(this MemberInfo memberInfo)
  • public static bool IsEnumEx(this Type type)
  • public static bool IsFieldEx(this MemberInfo memberInfo)
  • public static bool IsFloatType(this Type type)
  • public static bool IsGenericEnumerableType(this Type type)
  • public static bool IsGenericTypeDefinitionEx(this Type type)
  • public static bool IsGenericTypeEx(this Type type)
  • public static bool IsIntegerType(this Type type)
  • public static bool IsInterfaceEx(this Type type)
  • public static bool IsMethodEx(this MemberInfo memberInfo)
  • public static bool IsNullable(this Type type)
  • public static bool IsNullableHasValueMember(this MemberInfo member)
  • public static bool IsNullableValueMember(this MemberInfo member)
  • public static bool IsPrimitiveEx(this Type type)
  • public static bool IsPropertyEx(this MemberInfo memberInfo)
  • public static bool IsPublicEx(this Type type)
  • public static bool IsSameOrParentOf(this Type parent, Type child)
  • public static bool IsScalar(this Type type, bool checkArrayElementType = true)
  • public static bool IsSqlPropertyMethodEx(this MemberInfo memberInfo)
  • public static bool IsSubclassOfEx(this Type type, Type c)
  • public static bool IsValueTypeEx(this Type type)
  • public static Type ReflectedTypeEx(this MemberInfo memberInfo)
  • public static Type ToNullableUnderlying(this Type type)
  • public static Type ToUnderlying(this Type type)

LinqToDB.Linq

• public static class Expressions
  • public class LazyExpressionInfo : IExpressionInfo
  • public static T AccessInt<T>(T value)
  • public static T AccessRound<T>(T value, int? precision)
  • public static string AltStuff(string str, int? startLocation, int? length, string value)
  • public static LambdaExpression ConvertBinary(MappingSchema mappingSchema, BinaryExpression binaryExpression)
  • public static LambdaExpression ConvertMember(MappingSchema mappingSchema, Type objectType, MemberInfo mi)
  • public static int? ConvertToCaseCompareTo(string str, string value)
  • public static DateTime? DateAdd(DateParts part, int? number, int? days)
  • public static decimal DecimalPI()
  • public static double DoublePI()
  • public static string Hex(Guid? guid)
  • public static LambdaExpression L<TR>(Expression<Func<TR>> func)
  • public static LambdaExpression L<T1, TR>(Expression<Func<T1, TR>> func)
  • public static LambdaExpression L<T1, T2, TR>(Expression<Func<T1, T2, TR>> func)
  • public static LambdaExpression L<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> func)
  • public static LambdaExpression L<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> func)
  • public static LambdaExpression L<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> func)
  • public static LambdaExpression L<T1, T2, T3, T4, T5, T6, TR>(Expression<Func<T1, T2, T3, T4, T5, T6, TR>> func)
  • public static MemberInfo M<T>(Expression<Func<T, object>> func)
  • public static MemberInfo M<T>(Expression<Func<T>> func)
  • public static DateTime? MakeDateTime2(int? year, int? month, int? day)
  • public static void MapBinary(string providerName, ExpressionType nodeType, Type leftType, Type rightType, LambdaExpression expression)
  • public static void MapBinary(ExpressionType nodeType, Type leftType, Type rightType, LambdaExpression expression)
  • public static void MapBinary<TLeft, TRight, TR>(string providerName, Expression<Func<TLeft, TRight, TR>> binaryExpression, Expression<Func<TLeft, TRight, TR>> expression)
  • public static void MapBinary<TLeft, TRight, TR>(Expression<Func<TLeft, TRight, TR>> binaryExpression, Expression<Func<TLeft, TRight, TR>> expression)
  • public static void MapMember(MemberInfo memberInfo, LambdaExpression expression)
  • public static void MapMember(MemberInfo memberInfo, IExpressionInfo expressionInfo)
  • public static void MapMember(string providerName, MemberInfo memberInfo, LambdaExpression expression)
  • public static void MapMember(string providerName, MemberInfo memberInfo, IExpressionInfo expressionInfo)
  • public static void MapMember(Expression<Func<object>> memberInfo, LambdaExpression expression)
  • public static void MapMember(string providerName, Expression<Func<object>> memberInfo, LambdaExpression expression)
  • public static void MapMember<T>(Expression<Func<T, object>> memberInfo, LambdaExpression expression)
  • public static void MapMember<T>(string providerName, Expression<Func<T, object>> memberInfo, LambdaExpression expression)
  • public static void MapMember<TR>(string providerName, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)
  • public static void MapMember<TR>(Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)
  • public static void MapMember<T1, TR>(string providerName, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)
  • public static void MapMember<T1, TR>(Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)
  • public static void MapMember<T1, T2, TR>(string providerName, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)
  • public static void MapMember<T1, T2, TR>(Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)
  • public static void MapMember<T1, T2, T3, TR>(string providerName, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)
  • public static void MapMember<T1, T2, T3, TR>(Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, TR>(string providerName, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, TR>(Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, T5, TR>(string providerName, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, T5, TR>(Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)
  • public static void MapMember(string providerName, Type objectType, MemberInfo memberInfo, LambdaExpression expression)
  • public static void MapMember(string providerName, Type objectType, MemberInfo memberInfo, IExpressionInfo expressionInfo)
  • public static void MapMember<TR>(string providerName, Type objectType, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)
  • public static void MapMember<TR>(Type objectType, Expression<Func<TR>> memberInfo, Expression<Func<TR>> expression)
  • public static void MapMember<T1, TR>(string providerName, Type objectType, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)
  • public static void MapMember<T1, TR>(Type objectType, Expression<Func<T1, TR>> memberInfo, Expression<Func<T1, TR>> expression)
  • public static void MapMember<T1, T2, TR>(string providerName, Type objectType, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)
  • public static void MapMember<T1, T2, TR>(Type objectType, Expression<Func<T1, T2, TR>> memberInfo, Expression<Func<T1, T2, TR>> expression)
  • public static void MapMember<T1, T2, T3, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)
  • public static void MapMember<T1, T2, T3, TR>(Type objectType, Expression<Func<T1, T2, T3, TR>> memberInfo, Expression<Func<T1, T2, T3, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, TR>(Type objectType, Expression<Func<T1, T2, T3, T4, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, T5, TR>(string providerName, Type objectType, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)
  • public static void MapMember<T1, T2, T3, T4, T5, TR>(Type objectType, Expression<Func<T1, T2, T3, T4, T5, TR>> memberInfo, Expression<Func<T1, T2, T3, T4, T5, TR>> expression)
  • public static DateTime? Mdy(int? month, int? day, int? year)
  • public static LazyExpressionInfo N(Func<LambdaExpression> func)
  • public static string Replicate(string str, int? count)
  • public static string Replicate(char? ch, int? count)
  • public static decimal? Round(decimal? value, int precision, int mode)
  • public static double? Round(double? value, int precision, int mode)
  • public static void SetGenericInfoProvider(Type type)
  • public static string TrimLeft(string str, char[] trimChars)
  • public static string TrimRight(string str, char[] trimChars)
  • public static string VarChar(object obj, int? size)
• public interface IDataReaderAsync : IDisposable
  • IDataReader DataReader { get; }
  • Task<bool> ReadAsync(CancellationToken cancellationToken)
• public interface IExpressionInfo
  • LambdaExpression GetExpression(MappingSchema mappingSchema)
• public interface IExpressionPreprocessor
  • Expression ProcessExpression(Expression expression)
• public interface IExpressionQuery
  • IDataContext DataContext { get; }
  • Expression Expression { get; }
  • string SqlText { get; }
• public interface IExpressionQuery<T> : IOrderedQueryable<T>, IEnumerable<T>, IEnumerable, IOrderedQueryable, IQueryable, IQueryable<T>, IQueryProviderAsync, IQueryProvider, IExpressionQuery
  • Expression Expression { get; set; }
• public static class Internals
  • public static IQueryable<T> CreateExpressionQueryInstance<T>(IDataContext dataContext, Expression expression)
• public interface IQueryContext
  • object Context { get; set; }
  • List<string> QueryHints { get; set; }
  • SqlStatement Statement { get; }
  • SqlParameter[] GetParameters()
• public interface IQueryRunner : IDisposable
  • IDataContext DataContext { get; set; }
  • Expression Expression { get; set; }
  • Expression MapperExpression { get; set; }
  • object[] Parameters { get; set; }
  • int QueryNumber { get; set; }
  • int RowsCount { get; set; }
  • int ExecuteNonQuery()
  • Task<int> ExecuteNonQueryAsync(CancellationToken cancellationToken)
  • IDataReader ExecuteReader()
  • Task<IDataReaderAsync> ExecuteReaderAsync(CancellationToken cancellationToken)
  • object ExecuteScalar()
  • Task<object> ExecuteScalarAsync(CancellationToken cancellationToken)
  • string GetSqlText()
• public interface ISelectInsertable<TSource, TTarget>
• public interface IUpdatable<T>
• public interface IValueInsertable<T>
• public class LinqException : Exception
  • public LinqException()
  • public LinqException(string message, object[] args)
  • public LinqException(string message, Exception innerException)
  • public LinqException(Exception innerException)
  • protected LinqException(SerializationInfo info, StreamingContext context)
• public static class MethodHelper
  • public static MethodInfo GetMethodInfo(this Delegate del)
  • public static MethodInfo GetMethodInfo<T1, T2>(Func<T1, T2> f, T1 unused1)
  • public static MethodInfo GetMethodInfo<T1, T2, T3>(Func<T1, T2, T3> f, T1 unused1, T2 unused2)
  • public static MethodInfo GetMethodInfo<T1, T2, T3, T4>(Func<T1, T2, T3, T4> f, T1 unused1, T2 unused2, T3 unused3)
  • public static MethodInfo GetMethodInfo<T1, T2, T3, T4, T5>(Func<T1, T2, T3, T4, T5> f, T1 unused1, T2 unused2, T3 unused3, T4 unused4)
  • public static MethodInfo GetMethodInfo<T1, T2, T3, T4, T5, T6>(Func<T1, T2, T3, T4, T5, T6> f, T1 unused1, T2 unused2, T3 unused3, T4 unused4, T5 unused5)
  • public static MethodInfo GetMethodInfo<T1, T2, T3, T4, T5, T6, T7>(Func<T1, T2, T3, T4, T5, T6, T7> f, T1 unused1, T2 unused2, T3 unused3, T4 unused4, T5 unused5, T6 unused6)
• public class NoLinqCache : IDisposable
  • public static IDisposable Scope()
• public abstract class Query
  • public Func<IDataContext, Expression, object[], object> GetElement
  • public Func<IDataContext, Expression, object[], CancellationToken, Task<object>> GetElementAsync
  • protected Query(IDataContext dataContext, Expression expression)
  • public static void ClearCaches()
  • protected bool Compare(IDataContext dataContext, Expression expr)

LinqToDB.Linq.Builder

• public enum ConvertFlags
  • All = 2
  • Field = 0
  • Key = 1
• public interface IToSqlConverter
  • ISqlExpression ToSql(Expression expression)
• public enum RequestFor
  • Association = 1
  • Expression = 5
  • Field = 4
  • GroupJoin = 3
  • Object = 2
  • Root = 7
  • SubQuery = 6
  • Table = 0
• public class SequenceConvertInfo
  • public Expression Expression
  • public List<SequenceConvertPath> ExpressionsToReplace
  • public ParameterExpression Parameter
  • public SequenceConvertInfo()
• public class SequenceConvertPath
  • public Expression Expr
  • public int Level
  • public Expression Path
  • public SequenceConvertPath()
• public class SqlInfo
  • public int Index
  • public readonly List<MemberInfo> MemberChain
  • public SelectQuery Query
  • public ISqlExpression Sql
  • public SqlInfo()
  • public SqlInfo(MemberInfo mi)
  • public SqlInfo(IEnumerable<MemberInfo> mi)
  • public SqlInfo Clone()
  • public SqlInfo Clone(MemberInfo mi)
  • public bool CompareLastMember(SqlInfo info)
  • public bool CompareMembers(SqlInfo info)

LinqToDB.Mapping

• public class AssociationAttribute : Attribute
  • public string AliasName { get; set; }
  • public string BackReferenceName { get; set; }
  • public bool CanBeNull { get; set; }
  • public string Configuration { get; set; }
  • public string ExpressionPredicate { get; set; }
  • public bool IsBackReference { get; set; }
  • public string KeyName { get; set; }
  • public string OtherKey { get; set; }
  • public Expression Predicate { get; set; }
  • public Expression QueryExpression { get; set; }
  • public string QueryExpressionMethod { get; set; }
  • public Relationship Relationship { get; set; }
  • public string Storage { get; set; }
  • public string ThisKey { get; set; }
  • public AssociationAttribute()
  • public string[] GetOtherKeys()
  • public string[] GetThisKeys()
• public class AssociationDescriptor
  • public string AliasName { get; set; }
  • public bool CanBeNull { get; set; }
  • public string ExpressionPredicate { get; set; }
  • public Expression ExpressionQuery { get; set; }
  • public string ExpressionQueryMethod { get; set; }
  • public MemberInfo MemberInfo { get; set; }
  • public string[] OtherKey { get; set; }
  • public Expression Predicate { get; set; }
  • public string Storage { get; set; }
  • public string[] ThisKey { get; set; }
  • public AssociationDescriptor(Type type, MemberInfo memberInfo, string[] thisKey, string[] otherKey, string expressionPredicate, Expression predicate, string expressionQueryMethod, Expression expressionQuery, string storage, bool canBeNull, string aliasName)
  • public static string[] ParseKeys(string keys)
  • public LambdaExpression GetPredicate(Type parentType, Type objectType)
  • public LambdaExpression GetQueryMethod(Type parentType, Type objectType)
• public class ColumnAliasAttribute : Attribute
  • public string Configuration { get; set; }
  • public string MemberName { get; set; }
  • public ColumnAliasAttribute()
  • public ColumnAliasAttribute(string memberName)
• public class ColumnAttribute : Attribute
  • public bool CanBeNull { get; set; }
  • public string Configuration { get; set; }
  • public string CreateFormat { get; set; }
  • public DataType DataType { get; set; }
  • public string DbType { get; set; }
  • public bool IsColumn { get; set; }
  • public bool IsDiscriminator { get; set; }
  • public bool IsIdentity { get; set; }
  • public bool IsPrimaryKey { get; set; }
  • public int Length { get; set; }
  • public string MemberName { get; set; }
  • public string Name { get; set; }
  • public int Order { get; set; }
  • public int Precision { get; set; }
  • public int PrimaryKeyOrder { get; set; }
  • public int Scale { get; set; }
  • public bool SkipOnInsert { get; set; }
  • public bool SkipOnUpdate { get; set; }
  • public string Storage { get; set; }
  • public ColumnAttribute()
  • public ColumnAttribute(string columnName)
  • public ColumnAttribute(string columnName, string memberName)
  • public bool HasCanBeNull()
  • public bool HasIsIdentity()
  • public bool HasIsPrimaryKey()
  • public bool HasLength()
  • public bool HasOrder()
  • public bool HasPrecision()
  • public bool HasScale()
  • public bool HasSkipOnInsert()
  • public bool HasSkipOnUpdate()
• public class ColumnDescriptor : IColumnChangeDescriptor
  • public bool CanBeNull { get; }
  • public string ColumnName { get; }
  • public string CreateFormat { get; }
  • public DataType DataType { get; }
  • public string DbType { get; }
  • public bool HasValuesToSkipOnInsert { get; }
  • public bool HasValuesToSkipOnUpdate { get; }
  • public bool IsDiscriminator { get; }
  • public bool IsIdentity { get; }
  • public bool IsPrimaryKey { get; }
  • public int? Length { get; }
  • public MemberAccessor MemberAccessor { get; }
  • public MemberInfo MemberInfo { get; }
  • public string MemberName { get; }
  • public Type MemberType { get; }
  • public int? Order { get; }
  • public int? Precision { get; }
  • public int PrimaryKeyOrder { get; }
  • public int? Scale { get; }
  • public SequenceNameAttribute SequenceName { get; }
  • public SkipModification SkipModificationFlags { get; }
  • public bool SkipOnInsert { get; }
  • public bool SkipOnUpdate { get; }
  • public string Storage { get; }
  • public MemberInfo StorageInfo { get; }
  • public Type StorageType { get; }
  • public ColumnDescriptor(MappingSchema mappingSchema, ColumnAttribute columnAttribute, MemberAccessor memberAccessor)
  • public virtual object GetValue(MappingSchema mappingSchema, object obj)
  • public virtual bool ShouldSkip(object obj, EntityDescriptor descriptor, SkipModification flags)
• public class DataTypeAttribute : Attribute
  • public string Configuration { get; set; }
  • public DataType? DataType { get; set; }
  • public string DbType { get; set; }
  • public DataTypeAttribute(DataType dataType)
  • public DataTypeAttribute(string dbType)
  • public DataTypeAttribute(DataType dataType, string dbType)
• public class DynamicColumnAccessorAttribute : Attribute, IConfigurationProvider
  • public string Configuration { get; set; }
  • public LambdaExpression GetterExpression { get; set; }
  • public string GetterExpressionMethod { get; set; }
  • public string GetterMethod { get; set; }
  • public LambdaExpression SetterExpression { get; set; }
  • public string SetterExpressionMethod { get; set; }
  • public string SetterMethod { get; set; }
  • public DynamicColumnAccessorAttribute()
• public class DynamicColumnInfo : PropertyInfo, IEquatable<DynamicColumnInfo>
  • public DynamicColumnInfo(Type declaringType, Type columnType, string memberName)
  • public static bool op_Equality(DynamicColumnInfo a, DynamicColumnInfo b)
  • public static bool op_Inequality(DynamicColumnInfo a, DynamicColumnInfo b)
  • public bool Equals(DynamicColumnInfo other)
• public class DynamicColumnsStoreAttribute : Attribute, IConfigurationProvider
  • public string Configuration { get; set; }
  • public DynamicColumnsStoreAttribute()
• public class EntityDescriptor : IEntityChangeDescriptor
  • public Dictionary<string, string> Aliases { get; }
  • public List<AssociationDescriptor> Associations { get; }
  • public List<MemberAccessor> CalculatedMembers { get; }
  • public List<ColumnDescriptor> Columns { get; }
  • public string DatabaseName { get; }
  • public ColumnDescriptor DynamicColumnsStore { get; }
  • public bool HasCalculatedMembers { get; }
  • public List<InheritanceMapping> InheritanceMapping { get; }
  • public bool IsColumnAttributeRequired { get; }
  • public ColumnDescriptor this[string memberName] { get; }
  • public Type ObjectType { get; }
  • public string SchemaName { get; }
  • public SkipModification SkipModificationFlags { get; }
  • public string TableName { get; }
  • public TypeAccessor TypeAccessor { get; set; }
  • public EntityDescriptor(MappingSchema mappingSchema, Type type)
• public class EntityMappingBuilder<T>
  • public string Configuration { get; }
  • public EntityMappingBuilder(FluentMappingBuilder builder, string configuration)
  • public PropertyMappingBuilder<T> Association<S, ID1, ID2>(Expression<Func<T, S>> prop, Expression<Func<T, ID1>> thisKey, Expression<Func<S, ID2>> otherKey, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<S, ID1, ID2>(Expression<Func<T, IEnumerable<S>>> prop, Expression<Func<T, ID1>> thisKey, Expression<Func<S, ID2>> otherKey, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, IEnumerable<TOther>>> prop, Expression<Func<T, TOther, bool>> predicate, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, TOther>> prop, Expression<Func<T, TOther, bool>> predicate, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, IEnumerable<TOther>>> prop, Expression<Func<T, IDataContext, IQueryable<TOther>>> queryExpression, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, TOther>> prop, Expression<Func<T, IDataContext, IQueryable<TOther>>> queryExpression, bool canBeNull = true)
  • public EntityMappingBuilder<T> DynamicColumnsStore(Expression<Func<T, object>> func)
  • public EntityMappingBuilder<T> DynamicPropertyAccessors(Expression<Func<T, string, object, object>> getter, Expression<Action<T, string, object>> setter)
  • public EntityMappingBuilder<TE> Entity<TE>(string configuration = null)
  • public TA[] GetAttributes<TA>() where TA : Attribute
  • public TA[] GetAttributes<TA>(Type type) where TA : Attribute
  • public TA[] GetAttributes<TA>(MemberInfo memberInfo) where TA : Attribute
  • public TA[] GetAttributes<TA>(Func<TA, string> configGetter) where TA : Attribute
  • public TA[] GetAttributes<TA>(Type type, Func<TA, string> configGetter) where TA : Attribute
  • public TA[] GetAttributes<TA>(MemberInfo memberInfo, Func<TA, string> configGetter) where TA : Attribute
  • public EntityMappingBuilder<T> HasAttribute(Attribute attribute)
  • public EntityMappingBuilder<T> HasAttribute(MemberInfo memberInfo, Attribute attribute)
  • public EntityMappingBuilder<T> HasAttribute(LambdaExpression func, Attribute attribute)
  • public EntityMappingBuilder<T> HasAttribute(Expression<Func<T, object>> func, Attribute attribute)
  • public EntityMappingBuilder<T> HasColumn(Expression<Func<T, object>> func, int order = -1)
  • public EntityMappingBuilder<T> HasDatabaseName(string databaseName)
  • public EntityMappingBuilder<T> HasIdentity(Expression<Func<T, object>> func)
  • public EntityMappingBuilder<T> HasPrimaryKey(Expression<Func<T, object>> func, int order = -1)
  • public EntityMappingBuilder<T> HasSchemaName(string schemaName)
  • public EntityMappingBuilder<T> HasSkipValuesOnInsert(Expression<Func<T, object>> func, object[] values)
  • public EntityMappingBuilder<T> HasSkipValuesOnUpdate(Expression<Func<T, object>> func, object[] values)
  • public EntityMappingBuilder<T> HasTableName(string tableName)
  • public EntityMappingBuilder<T> Ignore(Expression<Func<T, object>> func, int order = -1)
  • public EntityMappingBuilder<T> Inheritance<TS>(Expression<Func<T, TS>> key, TS value, Type type, bool isDefault = false)
  • public EntityMappingBuilder<T> IsColumnNotRequired()
  • public EntityMappingBuilder<T> IsColumnRequired()
  • public PropertyMappingBuilder<T> Member(Expression<Func<T, object>> func)
  • public PropertyMappingBuilder<T> Property(Expression<Func<T, object>> func)
• public class FluentMappingBuilder
  • public MappingSchema MappingSchema { get; }
  • public FluentMappingBuilder(MappingSchema mappingSchema)
  • public EntityMappingBuilder<T> Entity<T>(string configuration = null)
  • public T[] GetAttributes<T>(Type type) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo) where T : Attribute
  • public FluentMappingBuilder HasAttribute(Type type, Attribute attribute)
  • public FluentMappingBuilder HasAttribute<T>(Attribute attribute)
  • public FluentMappingBuilder HasAttribute(MemberInfo memberInfo, Attribute attribute)
  • public FluentMappingBuilder HasAttribute(LambdaExpression func, Attribute attribute)
  • public FluentMappingBuilder HasAttribute<T>(Expression<Func<T, object>> func, Attribute attribute)
• public interface IColumnChangeDescriptor
  • string ColumnName { get; set; }
  • string MemberName { get; }
• public class IdentityAttribute : Attribute
  • public string Configuration { get; set; }
  • public IdentityAttribute()
  • public IdentityAttribute(string configuration)
• public interface IEntityChangeDescriptor
  • IEnumerable<IColumnChangeDescriptor> Columns { get; }
  • string DatabaseName { get; set; }
  • string SchemaName { get; set; }
  • string TableName { get; set; }
  • TypeAccessor TypeAccessor { get; set; }
• public class InheritanceMapping
  • public object Code
  • public ColumnDescriptor Discriminator
  • public bool IsDefault
  • public Type Type
  • public string DiscriminatorName { get; }
  • public InheritanceMapping()
• public class InheritanceMappingAttribute : Attribute
  • public object Code { get; set; }
  • public string Configuration { get; set; }
  • public bool IsDefault { get; set; }
  • public Type Type { get; set; }
  • public InheritanceMappingAttribute()
• public class MappingSchema
  • public static MappingSchema Default
  • public StringComparer ColumnNameComparer { get; set; }
  • public string ConfigurationID { get; }
  • public string[] ConfigurationList { get; }
  • public Action<MappingSchema, IEntityChangeDescriptor> EntityDescriptorCreatedCallback { get; set; }
  • public IMetadataReader MetadataReader { get; set; }
  • public ValueToSqlConverter ValueToSqlConverter { get; }
  • public MappingSchema()
  • public MappingSchema(MappingSchema[] schemas)
  • public MappingSchema(string configuration)
  • public MappingSchema(string configuration, MappingSchema[] schemas)
  • public static void ClearCache()
  • public void AddMetadataReader(IMetadataReader reader)
  • public void AddScalarType(Type type, object defaultValue, DataType dataType = 0)
  • public void AddScalarType(Type type, object defaultValue, bool canBeNull, DataType dataType = 0)
  • public void AddScalarType(Type type, DataType dataType = 0)
  • public void AddScalarType(Type type, SqlDataType dataType)
  • public object ChangeType(object value, Type conversionType)
  • public T ChangeTypeTo<T>(object value)
  • public object EnumToValue(Enum value)
  • public T GetAttribute<T>(Type type, bool inherit = true) where T : Attribute
  • public T GetAttribute<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • public T GetAttribute<T>(Type type, Func<T, string> configGetter, bool inherit = true) where T : Attribute
  • public T GetAttribute<T>(Type type, MemberInfo memberInfo, Func<T, string> configGetter, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, Func<T, string> configGetter, bool inherit = true, bool exactForConfiguration = false) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, Func<T, string> configGetter, bool inherit = true, bool exactForConfiguration = false) where T : Attribute
  • public bool GetCanBeNull(Type type)
  • public Func<TFrom, TTo> GetConverter<TFrom, TTo>()
  • public Expression<Func<TFrom, TTo>> GetConvertExpression<TFrom, TTo>(bool checkNull = true, bool createDefault = true)
  • public LambdaExpression GetConvertExpression(Type from, Type to, bool checkNull = true, bool createDefault = true)
  • public LambdaExpression GetConvertExpression(DbDataType from, DbDataType to, bool checkNull = true, bool createDefault = true)
  • public SqlDataType GetDataType(Type type)
  • public Type GetDefaultFromEnumType(Type enumType)
  • public object GetDefaultValue(Type type)
  • public Type[] GetDefinedTypes()
  • public MemberInfo[] GetDynamicColumns(Type type)
  • public Type[] GetEntites()
  • public EntityDescriptor GetEntityDescriptor(Type type)
  • public FluentMappingBuilder GetFluentMappingBuilder()
  • public virtual MapValue[] GetMapValues(Type type)
  • public SqlDataType GetUnderlyingDataType(Type type, ref bool canBeNull)
  • public void InitGenericConvertProvider<T>()
  • public bool InitGenericConvertProvider(Type[] types)
  • public bool IsScalarType(Type type)
  • public void SetCanBeNull(Type type, bool value)
  • public void SetConverter<TFrom, TTo>(Func<TFrom, TTo> func)
  • public void SetConverter<TFrom, TTo>(Func<TFrom, TTo> func, DbDataType from, DbDataType to)
  • public void SetConvertExpression(Type fromType, Type toType, LambdaExpression expr, bool addNullCheck = true)
  • public void SetConvertExpression(DbDataType fromType, DbDataType toType, LambdaExpression expr, bool addNullCheck = true)
  • public void SetConvertExpression<TFrom, TTo>(Expression<Func<TFrom, TTo>> expr, bool addNullCheck = true)
  • public void SetConvertExpression<TFrom, TTo>(Expression<Func<TFrom, TTo>> checkNullExpr, Expression<Func<TFrom, TTo>> expr)
  • public void SetCultureInfo(CultureInfo info)
  • public void SetDataType(Type type, DataType dataType)
  • public void SetDataType(Type type, SqlDataType dataType)
  • public void SetDefaultFromEnumType(Type enumType, Type defaultFromType)
  • public void SetDefaultValue(Type type, object value)
  • public void SetGenericConvertProvider(Type type)
  • public void SetScalarType(Type type, bool isScalarType = true)
  • public void SetValueToSqlConverter(Type type, Action<StringBuilder, SqlDataType, object> converter)
  • public virtual LambdaExpression TryGetConvertExpression(Type from, Type to)
• public class MapValue
  • public MapValueAttribute[] MapValues { get; }
  • public object OrigValue { get; }
  • public MapValue(object origValue, MapValueAttribute[] mapValues)
• public class MapValueAttribute : Attribute
  • public string Configuration { get; set; }
  • public bool IsDefault { get; set; }
  • public object Value { get; set; }
  • public MapValueAttribute()
  • public MapValueAttribute(object value)
  • public MapValueAttribute(string configuration, object value)
  • public MapValueAttribute(object value, bool isDefault)
  • public MapValueAttribute(string configuration, object value, bool isDefault)
• public class NotColumnAttribute : ColumnAttribute
  • public NotColumnAttribute()
• public class NotNullAttribute : NullableAttribute
  • public NotNullAttribute()
  • public NotNullAttribute(string configuration)
• public class NullableAttribute : Attribute
  • public bool CanBeNull { get; set; }
  • public string Configuration { get; set; }
  • public NullableAttribute()
  • public NullableAttribute(bool isNullable)
  • public NullableAttribute(string configuration, bool isNullable)
• public class PrimaryKeyAttribute : Attribute
  • public string Configuration { get; set; }
  • public int Order { get; set; }
  • public PrimaryKeyAttribute()
  • public PrimaryKeyAttribute(int order)
  • public PrimaryKeyAttribute(string configuration, int order)
• public class PropertyMappingBuilder<T>
  • public PropertyMappingBuilder(EntityMappingBuilder<T> entity, Expression<Func<T, object>> memberGetter)
  • public PropertyMappingBuilder<T> Association<S, ID1, ID2>(Expression<Func<T, S>> prop, Expression<Func<T, ID1>> thisKey, Expression<Func<S, ID2>> otherKey, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<S, ID1, ID2>(Expression<Func<T, IEnumerable<S>>> prop, Expression<Func<T, ID1>> thisKey, Expression<Func<S, ID2>> otherKey, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, IEnumerable<TOther>>> prop, Expression<Func<T, TOther, bool>> predicate, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, TOther>> prop, Expression<Func<T, TOther, bool>> predicate, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, IEnumerable<TOther>>> prop, Expression<Func<T, IDataContext, IQueryable<TOther>>> queryExpression, bool canBeNull = true)
  • public PropertyMappingBuilder<T> Association<TOther>(Expression<Func<T, TOther>> prop, Expression<Func<T, IDataContext, IQueryable<TOther>>> queryExpression, bool canBeNull = true)
  • public EntityMappingBuilder<TE> Entity<TE>(string configuration = null)
  • public PropertyMappingBuilder<T> HasAttribute(Attribute attribute)
  • public PropertyMappingBuilder<T> HasColumnName(string columnName)
  • public PropertyMappingBuilder<T> HasCreateFormat(string format)
  • public PropertyMappingBuilder<T> HasDataType(DataType dataType)
  • public PropertyMappingBuilder<T> HasDbType(string dbType)
  • public PropertyMappingBuilder<T> HasLength(int length)
  • public PropertyMappingBuilder<T> HasOrder(int order)
  • public PropertyMappingBuilder<T> HasPrecision(int precision)
  • public PropertyMappingBuilder<T> HasScale(int scale)
  • public PropertyMappingBuilder<T> HasSkipOnInsert(bool skipOnInsert = true)
  • public PropertyMappingBuilder<T> HasSkipOnUpdate(bool skipOnUpdate = true)
  • public PropertyMappingBuilder<T> HasStorage(string storage)
  • public PropertyMappingBuilder<T> IsAlias(Expression<Func<T, object>> aliasMember)
  • public PropertyMappingBuilder<T> IsAlias(string aliasMember)
  • public PropertyMappingBuilder<T> IsColumn()
  • public PropertyMappingBuilder<T> IsDiscriminator(bool isDiscriminator = true)
  • public PropertyMappingBuilder<T> IsExpression<TR>(Expression<Func<T, TR>> expression, bool isColumn = false, string alias = null)
  • public PropertyMappingBuilder<T> IsIdentity()
  • public PropertyMappingBuilder<T> IsNotColumn()
  • public PropertyMappingBuilder<T> IsNullable(bool isNullable = true)
  • public PropertyMappingBuilder<T> IsPrimaryKey(int order = -1)
  • public PropertyMappingBuilder<T> Member(Expression<Func<T, object>> func)
  • public PropertyMappingBuilder<T> Property(Expression<Func<T, object>> func)
• public enum Relationship
  • ManyToOne = 2
  • OneToMany = 1
  • OneToOne = 0
• public class ResultSetIndexAttribute : Attribute
  • public int Index { get; }
  • public ResultSetIndexAttribute(int index)
• public class ScalarTypeAttribute : Attribute
  • public string Configuration { get; set; }
  • public bool IsScalar { get; set; }
  • public ScalarTypeAttribute()
  • public ScalarTypeAttribute(bool isScalar)
  • public ScalarTypeAttribute(string configuration)
  • public ScalarTypeAttribute(string configuration, bool isScalar)
• public class SequenceNameAttribute : Attribute
  • public string Configuration { get; set; }
  • public string Schema { get; set; }
  • public string SequenceName { get; set; }
  • public SequenceNameAttribute(string configuration, string sequenceName)
  • public SequenceNameAttribute(string sequenceName)
• public abstract class SkipBaseAttribute : Attribute
  • public abstract SkipModification Affects { get; }
  • public string Configuration { get; set; }
  • protected SkipBaseAttribute()
  • public abstract bool ShouldSkip(object obj, EntityDescriptor entityDescriptor, ColumnDescriptor columnDescriptor)
• public enum SkipModification
  • Insert = 1
  • None = 0
  • Update = 2
• public abstract class SkipValuesByListAttribute : SkipBaseAttribute
  • protected HashSet<object> Values { get; protected set; }
  • protected SkipValuesByListAttribute(IEnumerable<object> values)
• public class SkipValuesOnInsertAttribute : SkipValuesByListAttribute
  • public SkipValuesOnInsertAttribute(object[] values)
• public class SkipValuesOnUpdateAttribute : SkipValuesByListAttribute
  • public SkipValuesOnUpdateAttribute(object[] values)
• public class StoredProcedure : Attribute
  • public string Database { get; set; }
  • public string Name { get; set; }
  • public string Schema { get; set; }
  • public StoredProcedure()
  • public StoredProcedure(string name)
• public class TableAttribute : Attribute
  • public string Configuration { get; set; }
  • public string Database { get; set; }
  • public bool IsColumnAttributeRequired { get; set; }
  • public bool IsView { get; set; }
  • public string Name { get; set; }
  • public string Schema { get; set; }
  • public TableAttribute()
  • public TableAttribute(string tableName)

LinqToDB.Metadata

• public class AttributeReader : IMetadataReader
  • public AttributeReader()
  • public T[] GetAttributes<T>(Type type, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)
• public class FluentMetadataReader : IMetadataReader
  • public FluentMetadataReader()
  • public void AddAttribute(Type type, Attribute attribute)
  • public void AddAttribute(MemberInfo memberInfo, Attribute attribute)
  • public T[] GetAttributes<T>(Type type, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)
  • public Type[] GetRegisteredTypes()
• public interface IMetadataReader
  • T[] GetAttributes<T>(Type type, bool inherit = true) where T : Attribute
  • T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • MemberInfo[] GetDynamicColumns(Type type)
• public class MetadataException : Exception
  • public MetadataException()
  • public MetadataException(string message)
  • public MetadataException(string message, Exception innerException)
  • public MetadataException(Exception innerException)
  • protected MetadataException(SerializationInfo info, StreamingContext context)
• public class MetadataReader : IMetadataReader
  • public static MetadataReader Default
  • public MetadataReader(IMetadataReader[] readers)
  • public T[] GetAttributes<T>(Type type, bool inherit) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)
• public class SystemComponentModelDataAnnotationsSchemaAttributeReader : IMetadataReader
  • public SystemComponentModelDataAnnotationsSchemaAttributeReader()
  • public T[] GetAttributes<T>(Type type, bool inherit) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)
• public class SystemDataSqlServerAttributeReader : IMetadataReader
  • public SystemDataSqlServerAttributeReader()
  • public T[] GetAttributes<T>(Type type, bool inherit) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)
• public class XmlAttributeReader : IMetadataReader
  • public XmlAttributeReader(string xmlFile)
  • public XmlAttributeReader(string xmlFile, Assembly assembly)
  • public XmlAttributeReader(Stream xmlDocStream)
  • public T[] GetAttributes<T>(Type type, bool inherit = true) where T : Attribute
  • public T[] GetAttributes<T>(Type type, MemberInfo memberInfo, bool inherit = true) where T : Attribute
  • public MemberInfo[] GetDynamicColumns(Type type)

LinqToDB.Reflection

• public interface IObjectFactory
  • object CreateInstance(TypeAccessor typeAccessor)
• public class MemberAccessor
  • public Func<object, object> Getter { get; }
  • public LambdaExpression GetterExpression { get; }
  • public bool HasGetter { get; }
  • public bool HasSetter { get; }
  • public bool IsComplex { get; }
  • public MemberInfo MemberInfo { get; }
  • public string Name { get; }
  • public Action<object, object> Setter { get; }
  • public LambdaExpression SetterExpression { get; }
  • public Type Type { get; }
  • public TypeAccessor TypeAccessor { get; }
  • public MemberAccessor(TypeAccessor typeAccessor, MemberInfo memberInfo, EntityDescriptor ed)
  • public T GetAttribute<T>() where T : Attribute
  • public T[] GetAttributes<T>() where T : Attribute
  • public object[] GetAttributes()
  • public T[] GetTypeAttributes<T>() where T : Attribute
  • public virtual object GetValue(object o)
  • public virtual void SetValue(object o, object value)
• public class ObjectFactoryAttribute : Attribute
  • public IObjectFactory ObjectFactory { get; }
  • public ObjectFactoryAttribute(Type type)
• public abstract class TypeAccessor
  • public MemberAccessor this[string memberName] { get; }
  • public MemberAccessor this[int index] { get; }
  • public List<MemberAccessor> Members { get; }
  • public IObjectFactory ObjectFactory { get; set; }
  • public abstract Type Type { get; }
  • protected TypeAccessor()
  • public static TypeAccessor GetAccessor(Type type)
  • public static TypeAccessor<T> GetAccessor<T>()
  • protected void AddMember(MemberAccessor member)
  • public virtual object CreateInstance()
  • public object CreateInstanceEx()
• public class TypeAccessor<T> : TypeAccessor
  • public T Create()

LinqToDB.SchemaProvider

• public enum AssociationType
  • Auto = 0
  • ManyToOne = 3
  • OneToMany = 2
  • OneToOne = 1
• public class ColumnInfo
  • public string ColumnType
  • public string DataType
  • public string Description
  • public bool IsIdentity
  • public bool IsNullable
  • public long? Length
  • public string Name
  • public int Ordinal
  • public int? Precision
  • public int? Scale
  • public bool SkipOnInsert
  • public bool SkipOnUpdate
  • public string TableID
  • public ColumnInfo()
• public class ColumnSchema
  • public TableSchema Table
  • public string ColumnName { get; set; }
  • public string ColumnType { get; set; }
  • public DataType DataType { get; set; }
  • public string Description { get; set; }
  • public bool IsIdentity { get; set; }
  • public bool IsNullable { get; set; }
  • public bool IsPrimaryKey { get; set; }
  • public long? Length { get; set; }
  • public string MemberName { get; set; }
  • public string MemberType { get; set; }
  • public int? Precision { get; set; }
  • public int PrimaryKeyOrder { get; set; }
  • public string ProviderSpecificType { get; set; }
  • public int? Scale { get; set; }
  • public bool SkipOnInsert { get; set; }
  • public bool SkipOnUpdate { get; set; }
  • public Type SystemType { get; set; }
  • public ColumnSchema()
• public class DatabaseSchema
  • public string Database { get; set; }
  • public string DataSource { get; set; }
  • public DataTable DataTypesSchema { get; set; }
  • public List<ProcedureSchema> Procedures { get; set; }
  • public string ProviderSpecificTypeNamespace { get; set; }
  • public string ServerVersion { get; set; }
  • public List<TableSchema> Tables { get; set; }
  • public DatabaseSchema()
• public class DataTypeInfo
  • public string CreateFormat
  • public string CreateParameters
  • public string DataType
  • public int ProviderDbType
  • public string TypeName
  • public DataTypeInfo()
• public class ForeignKeyInfo
  • public string Name
  • public int Ordinal
  • public string OtherColumn
  • public string OtherTableID
  • public string ThisColumn
  • public string ThisTableID
  • public ForeignKeyInfo()
• public class ForeignKeySchema
  • public AssociationType AssociationType { get; set; }
  • public ForeignKeySchema BackReference { get; set; }
  • public bool CanBeNull { get; set; }
  • public string KeyName { get; set; }
  • public string MemberName { get; set; }
  • public List<ColumnSchema> OtherColumns { get; set; }
  • public TableSchema OtherTable { get; set; }
  • public List<ColumnSchema> ThisColumns { get; set; }
  • public TableSchema ThisTable { get; set; }
  • public ForeignKeySchema()
• public class GetSchemaOptions
  • public string[] ExcludedCatalogs
  • public string[] ExcludedSchemas
  • public bool GenerateChar1AsString
  • public Func<ForeignKeySchema, string> GetAssociationMemberName
  • public bool GetForeignKeys
  • public bool GetProcedures
  • public bool GetTables
  • public string[] IncludedCatalogs
  • public string[] IncludedSchemas
  • public Func<ProcedureSchema, bool> LoadProcedure
  • public Func<LoadTableData, bool> LoadTable
  • public Action<int, int> ProcedureLoadingProgress
  • public StringComparer StringComparer
  • public GetSchemaOptions()
• public interface ISchemaProvider
  • DatabaseSchema GetSchema(DataConnection dataConnection, GetSchemaOptions options = null)
• public struct LoadTableData
  • public string Database { get; }
  • public bool IsDefaultSchema { get; }
  • public bool IsSystem { get; }
  • public bool IsView { get; }
  • public string Name { get; }
  • public string Schema { get; }
• public class ParameterSchema
  • public DataType DataType { get; set; }
  • public bool IsIn { get; set; }
  • public bool IsNullable { get; set; }
  • public bool IsOut { get; set; }
  • public bool IsResult { get; set; }
  • public string ParameterName { get; set; }
  • public string ParameterType { get; set; }
  • public string ProviderSpecificType { get; set; }
  • public string SchemaName { get; set; }
  • public string SchemaType { get; set; }
  • public long? Size { get; set; }
  • public Type SystemType { get; set; }
  • public ParameterSchema()
• public class PrimaryKeyInfo
  • public string ColumnName
  • public int Ordinal
  • public string PrimaryKeyName
  • public string TableID
  • public PrimaryKeyInfo()
• public class ProcedureInfo
  • public string CatalogName
  • public bool IsAggregateFunction
  • public bool IsDefaultSchema
  • public bool IsFunction
  • public bool IsResultDynamic
  • public bool IsTableFunction
  • public bool IsWindowFunction
  • public string ProcedureDefinition
  • public string ProcedureID
  • public string ProcedureName
  • public string SchemaName
  • public ProcedureInfo()
• public class ProcedureParameterInfo
  • public string DataType
  • public bool IsIn
  • public bool IsNullable
  • public bool IsOut
  • public bool IsResult
  • public long? Length
  • public int Ordinal
  • public string ParameterName
  • public int? Precision
  • public string ProcedureID
  • public int? Scale
  • public string UDTCatalog
  • public string UDTName
  • public string UDTSchema
  • public ProcedureParameterInfo()
• public class ProcedureSchema
  • public string CatalogName { get; set; }
  • public bool IsAggregateFunction { get; set; }
  • public bool IsDefaultSchema { get; set; }
  • public bool IsFunction { get; set; }
  • public bool IsLoaded { get; set; }
  • public bool IsResultDynamic { get; set; }
  • public bool IsTableFunction { get; set; }
  • public string MemberName { get; set; }
  • public List<ParameterSchema> Parameters { get; set; }
  • public string ProcedureName { get; set; }
  • public Exception ResultException { get; set; }
  • public TableSchema ResultTable { get; set; }
  • public string SchemaName { get; set; }
  • public List<TableSchema> SimilarTables { get; set; }
  • public ProcedureSchema()
• public abstract class SchemaProviderBase : ISchemaProvider
  • protected List<DataTypeInfo> DataTypes
  • protected Dictionary<string, DataTypeInfo> DataTypesDic
  • protected DataTable DataTypesSchema
  • protected HashSet<string> ExcludedCatalogs
  • protected HashSet<string> ExcludedSchemas
  • protected bool GenerateChar1AsString
  • protected HashSet<string> IncludedCatalogs
  • protected HashSet<string> IncludedSchemas
  • protected virtual bool GetProcedureSchemaExecutesProcedure { get; }
  • protected SchemaProviderBase()
  • protected static HashSet<string> GetHashSet(string[] data, IEqualityComparer<string> comparer)
  • public static string ToTypeName(Type type, bool isNullable)
  • public static string ToValidName(string name)
  • protected virtual DataParameter BuildProcedureParameter(ParameterSchema p)
  • protected virtual string BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema procedure, string commandText)
  • protected virtual StringComparison ForeignKeyColumnComparison(string column)
  • protected abstract List<ColumnInfo> GetColumns(DataConnection dataConnection)
  • protected virtual string GetDatabaseName(DbConnection dbConnection)
  • protected virtual string GetDataSourceName(DbConnection dbConnection)
  • protected abstract DataType GetDataType(string dataType, string columnType, long? length, int? prec, int? scale)
  • protected DataTypeInfo GetDataType(string typeName)
  • protected virtual List<DataTypeInfo> GetDataTypes(DataConnection dataConnection)
  • protected virtual string GetDbType(string columnType, DataTypeInfo dataType, long? length, int? prec, int? scale, string udtCatalog, string udtSchema, string udtName)
  • protected abstract List<ForeignKeyInfo> GetForeignKeys(DataConnection dataConnection)
  • protected abstract List<PrimaryKeyInfo> GetPrimaryKeys(DataConnection dataConnection)
  • protected virtual List<ProcedureParameterInfo> GetProcedureParameters(DataConnection dataConnection)
  • protected virtual List<ColumnSchema> GetProcedureResultColumns(DataTable resultTable)
  • protected virtual List<ProcedureInfo> GetProcedures(DataConnection dataConnection)
  • protected virtual DataTable GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters)
  • protected virtual List<ProcedureSchema> GetProviderSpecificProcedures(DataConnection dataConnection)
  • protected virtual List<TableSchema> GetProviderSpecificTables(DataConnection dataConnection)
  • protected virtual string GetProviderSpecificType(string dataType)
  • protected abstract string GetProviderSpecificTypeNamespace()
  • public virtual DatabaseSchema GetSchema(DataConnection dataConnection, GetSchemaOptions options = null)
  • protected virtual Type GetSystemType(string dataType, string columnType, DataTypeInfo dataTypeInfo, long? length, int? precision, int? scale)
  • protected abstract List<TableInfo> GetTables(DataConnection dataConnection)
  • protected virtual void InitProvider(DataConnection dataConnection)
  • protected virtual void LoadProcedureTableSchema(DataConnection dataConnection, ProcedureSchema procedure, string commandText, List<TableSchema> tables)
  • protected virtual DatabaseSchema ProcessSchema(DatabaseSchema databaseSchema, GetSchemaOptions schemaOptions)
• public class TableInfo
  • public string CatalogName
  • public string Description
  • public bool IsDefaultSchema
  • public bool IsProviderSpecific
  • public bool IsView
  • public string SchemaName
  • public string TableID
  • public string TableName
  • public TableInfo()
• public class TableSchema
  • public string CatalogName { get; set; }
  • public List<ColumnSchema> Columns { get; set; }
  • public string Description { get; set; }
  • public List<ForeignKeySchema> ForeignKeys { get; set; }
  • public string ID { get; set; }
  • public bool IsDefaultSchema { get; set; }
  • public bool IsProcedureResult { get; set; }
  • public bool IsProviderSpecific { get; set; }
  • public bool IsView { get; set; }
  • public string SchemaName { get; set; }
  • public string TableName { get; set; }
  • public string TypeName { get; set; }
  • public TableSchema()

LinqToDB.SqlProvider

• public abstract class BasicSqlBuilder : ISqlBuilder
  • protected sealed delegate ColumnSelector : MulticastDelegate
  • protected enum Step
  • protected static readonly char[] EndLine
  • protected Step BuildStep
  • protected int Indent
  • protected bool SkipAlias
  • protected ISqlOptimizer SqlOptimizer
  • protected SqlProviderFlags SqlProviderFlags
  • protected SqlStatement Statement
  • protected StringBuilder StringBuilder
  • protected ValueToSqlConverter ValueToSqlConverter
  • public virtual bool IsNestedJoinParenthesisRequired { get; }
  • public virtual bool IsNestedJoinSupported { get; }
  • protected virtual bool IsRecursiveCteKeywordRequired { get; }
  • public virtual string Name { get; }
  • protected virtual bool OffsetFirst { get; }
  • protected virtual bool SkipFirst { get; }
  • protected virtual string SkipFormat { get; }
  • protected virtual string TakePercent { get; }
  • protected virtual string TakeTies { get; }
  • public virtual bool WrapJoinCondition { get; }
  • protected BasicSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
  • protected static int GetPrecedence(ISqlPredicate predicate)
  • protected static string GetTableAlias(ISqlTableSource table)
  • protected static bool IsDateDataType(ISqlExpression expr, string dateName)
  • protected static bool IsTimeDataType(ISqlExpression expr)
  • protected ISqlExpression Add<T>(ISqlExpression expr1, ISqlExpression expr2)
  • protected void AlternativeBuildSql(bool implementOrderBy, Action buildSql, string emptyOrderByValue)
  • protected void AlternativeBuildSql2(Action buildSql)
  • protected IEnumerable<SqlColumn> AlternativeGetSelectedColumns(SelectQuery selectQuery, ColumnSelector columnSelector)
  • protected StringBuilder AppendIndent()
  • public string ApplyQueryHints(string sql, List<string> queryHints)
  • protected virtual void BuildBinaryExpression(SqlBinaryExpression expr)
  • protected virtual void BuildColumnExpression(SelectQuery selectQuery, ISqlExpression expr, string alias, ref bool addAlias)
  • protected virtual void BuildColumns(SelectQuery selectQuery)
  • protected virtual void BuildCommand(SqlStatement statement, int commandNumber)
  • protected virtual void BuildCreateTableFieldType(SqlField field)
  • protected virtual void BuildCreateTableIdentityAttribute1(SqlField field)
  • protected virtual void BuildCreateTableIdentityAttribute2(SqlField field)
  • protected virtual void BuildCreateTableNullAttribute(SqlField field, DefaultNullable defaultNullable)
  • protected virtual void BuildCreateTablePrimaryKey(SqlCreateTableStatement createTable, string pkName, IEnumerable<string> fieldNames)
  • protected virtual void BuildCreateTableStatement(SqlCreateTableStatement createTable)
  • protected virtual void BuildCteBody(SelectQuery selectQuery)
  • protected virtual void BuildDataType(SqlDataType type, bool createDbType)
  • protected virtual void BuildDeleteClause(SqlDeleteStatement deleteStatement)
  • protected virtual void BuildDeleteQuery(SqlDeleteStatement deleteStatement)
  • protected void BuildDeleteQuery2(SqlDeleteStatement deleteStatement)
  • protected virtual void BuildDropTableStatement(SqlDropTableStatement dropTable)
  • protected void BuildDropTableStatementIfExists(SqlDropTableStatement dropTable)
  • protected virtual void BuildEmptyInsert(SqlInsertClause insertClause)
  • protected virtual void BuildEndCreateTableStatement(SqlCreateTableStatement createTable)
  • protected virtual StringBuilder BuildExpression(ISqlExpression expr, bool buildTableName, bool checkParentheses, string alias, ref bool addAlias, bool throwExceptionIfTableNotFound = true)
  • protected StringBuilder BuildExpression(ISqlExpression expr)
  • protected void BuildExpression(ISqlExpression expr, bool buildTableName, bool checkParentheses, bool throwExceptionIfTableNotFound = true)
  • protected void BuildExpression(int precedence, ISqlExpression expr)
  • protected virtual void BuildFromClause(SqlStatement statement, SelectQuery selectQuery)
  • protected virtual void BuildFunction(SqlFunction func)
  • protected virtual void BuildGetIdentity(SqlInsertClause insertClause)
  • protected virtual void BuildGroupByClause(SelectQuery selectQuery)
  • protected virtual void BuildHavingClause(SelectQuery selectQuery)
  • protected void BuildInsertClause(SqlStatement statement, SqlInsertClause insertClause, bool addAlias)
  • protected virtual void BuildInsertClause(SqlStatement statement, SqlInsertClause insertClause, string insertText, bool appendTableName, bool addAlias)
  • protected virtual void BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement insertOrUpdate)
  • protected virtual void BuildInsertOrUpdateQueryAsMerge(SqlInsertOrUpdateStatement insertOrUpdate, string fromDummyTable)
  • protected void BuildInsertOrUpdateQueryAsUpdateInsert(SqlInsertOrUpdateStatement insertOrUpdate)
  • protected virtual void BuildInsertQuery(SqlStatement statement, SqlInsertClause insertClause, bool addAlias)
  • protected void BuildInsertQuery2(SqlStatement statement, SqlInsertClause insertClause, bool addAlias)
  • protected virtual bool BuildJoinType(SqlJoinedTable join)
  • protected virtual void BuildLikePredicate(Like predicate)
  • protected virtual void BuildOffsetLimit(SelectQuery selectQuery)
  • protected virtual void BuildOrderByClause(SelectQuery selectQuery)
  • protected virtual void BuildOutputSubclause(SqlStatement statement, SqlInsertClause insertClause)
  • protected void BuildPhysicalTable(ISqlTableSource table, string alias)
  • protected virtual void BuildPredicate(ISqlPredicate predicate)
  • protected void BuildPredicate(int parentPrecedence, ISqlPredicate predicate)
  • protected void BuildPredicate(int parentPrecedence, int precedence, ISqlPredicate predicate)
  • protected virtual void BuildSearchCondition(SqlSearchCondition condition)
  • protected virtual void BuildSearchCondition(int parentPrecedence, SqlSearchCondition condition)
  • protected virtual void BuildSelectClause(SelectQuery selectQuery)
  • protected virtual void BuildSelectQuery(SqlSelectStatement selectStatement)
  • protected virtual void BuildSetOperation(SetOperation operation, StringBuilder sb)
  • protected virtual void BuildSkipFirst(SelectQuery selectQuery)
  • public void BuildSql(int commandNumber, SqlStatement statement, StringBuilder sb, int startIndent = 0)
  • protected virtual void BuildSql(int commandNumber, SqlStatement statement, StringBuilder sb, int indent, bool skipAlias)
  • protected virtual void BuildSql()
  • protected virtual void BuildSqlBuilder(SelectQuery selectQuery, int indent, bool skipAlias)
  • protected virtual void BuildStartCreateTableStatement(SqlCreateTableStatement createTable)
  • public virtual StringBuilder BuildTableName(StringBuilder sb, string database, string schema, string table)
  • protected void BuildTableName(SqlTableSource ts, bool buildName, bool buildAlias)
  • protected virtual void BuildTakeHints(SelectQuery selectQuery)
  • protected virtual void BuildTruncateTable(SqlTruncateTableStatement truncateTable)
  • protected virtual void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable)
  • protected virtual void BuildUnknownQuery()
  • protected virtual void BuildUpdateClause(SqlStatement statement, SelectQuery selectQuery, SqlUpdateClause updateClause)
  • protected virtual void BuildUpdateQuery(SqlStatement statement, SelectQuery selectQuery, SqlUpdateClause updateClause)
  • protected virtual void BuildUpdateSet(SelectQuery selectQuery, SqlUpdateClause updateClause)
  • protected virtual void BuildUpdateTable(SelectQuery selectQuery, SqlUpdateClause updateClause)
  • protected virtual void BuildUpdateTableName(SelectQuery selectQuery, SqlUpdateClause updateClause)
  • protected void BuildValue(SqlDataType dataType, object value)
  • protected virtual bool BuildWhere(SelectQuery selectQuery)
  • protected virtual void BuildWhereClause(SelectQuery selectQuery)
  • protected virtual void BuildWhereSearchCondition(SelectQuery selectQuery, SqlSearchCondition condition)
  • protected virtual void BuildWithClause(SqlWithClause with)
  • protected virtual bool CanSkipRootAliases(SqlStatement statement)
  • public virtual int CommandCount(SqlStatement statement)
  • public virtual object Convert(object value, ConvertType convertType)
  • protected SqlFunction ConvertFunctionParameters(SqlFunction func)
  • public virtual StringBuilder ConvertTableName(StringBuilder sb, string database, string schema, string table)
  • protected abstract ISqlBuilder CreateSqlBuilder()
  • protected void ExtractMergeParametersIfCannotCombine(SqlInsertOrUpdateStatement insertOrUpdate, List<SqlSetExpression> keys)
  • protected virtual string FirstFormat(SelectQuery selectQuery)
  • public virtual ISqlExpression GetIdentityExpression(SqlTable table)
  • public virtual string GetMaxValueSql(EntityDescriptor entity, ColumnDescriptor column)
  • protected virtual string GetProviderTypeName(IDbDataParameter parameter)
  • public virtual string GetReserveSequenceValuesSql(int count, string sequenceName)
  • protected virtual IEnumerable<SqlColumn> GetSelectedColumns(SelectQuery selectQuery)
  • protected SequenceNameAttribute GetSequenceNameAttribute(SqlTable table, bool throwException)
  • protected virtual string GetTableDatabaseName(SqlTable table)
  • protected virtual string GetTableOwnerName(SqlTable table)
  • protected virtual string GetTablePhysicalName(SqlTable table)
  • protected virtual string GetTableSchemaName(SqlTable table)
  • protected string[] GetTempAliases(int n, string defaultAlias)
  • protected virtual string GetTypeName(IDbDataParameter parameter)
  • protected virtual string GetUdtTypeName(IDbDataParameter parameter)
  • protected virtual bool IsReserved(string word)
  • protected virtual string LimitFormat(SelectQuery selectQuery)
  • protected bool NeedSkip(SelectQuery selectQuery)
  • protected bool NeedTake(SelectQuery selectQuery)
  • protected virtual string OffsetFormat(SelectQuery selectQuery)
  • protected virtual bool ParenthesizeJoin(List<SqlJoinedTable> joins)
  • protected virtual void PrintParameterName(StringBuilder sb, IDbDataParameter parameter)
  • public virtual StringBuilder PrintParameters(StringBuilder sb, IDbDataParameter[] parameters)
  • protected virtual void PrintParameterType(StringBuilder sb, IDbDataParameter parameter)
  • protected virtual void PrintParameterValue(StringBuilder sb, IDbDataParameter parameter)
  • protected T WithStringBuilder<T>(StringBuilder sb, Func<T> func)
• public class BasicSqlOptimizer : ISqlOptimizer
  • public SqlProviderFlags SqlProviderFlags { get; }
  • protected BasicSqlOptimizer(SqlProviderFlags sqlProviderFlags)
  • protected static bool IsDateDataType(ISqlExpression expr, string dateName)
  • protected static bool IsTimeDataType(ISqlExpression expr)
  • public ISqlExpression Add(ISqlExpression expr1, ISqlExpression expr2, Type type)
  • public ISqlExpression Add<T>(ISqlExpression expr1, ISqlExpression expr2)
  • public ISqlExpression Add(ISqlExpression expr1, int value)
  • protected ISqlExpression AlternativeConvertToBoolean(SqlFunction func, int paramNumber)
  • protected void CheckAliases(SqlStatement statement, int maxLen)
  • protected virtual ISqlExpression ConvertConvertion(SqlFunction func)
  • public virtual bool ConvertCountSubQuery(SelectQuery subQuery)
  • protected ISqlPredicate ConvertEqualPredicate(ExprExpr expr)
  • public virtual ISqlExpression ConvertExpression(ISqlExpression expression)
  • public virtual ISqlPredicate ConvertPredicate(SelectQuery selectQuery, ISqlPredicate predicate)
  • public ISqlExpression Dec(ISqlExpression expr1)
  • public ISqlExpression Div(ISqlExpression expr1, ISqlExpression expr2, Type type)
  • public ISqlExpression Div<T>(ISqlExpression expr1, ISqlExpression expr2)
  • public ISqlExpression Div(ISqlExpression expr1, int value)
  • public virtual SqlStatement Finalize(SqlStatement statement)
  • protected ISqlExpression FloorBeforeConvert(SqlFunction func)
  • protected SqlDeleteStatement GetAlternativeDelete(SqlDeleteStatement deleteStatement)
  • protected SqlStatement GetAlternativeUpdate(SqlUpdateStatement updateStatement)
  • protected virtual int GetMaxDisplaySize(SqlDataType type)
  • protected virtual int GetMaxLength(SqlDataType type)
  • protected virtual int GetMaxPrecision(SqlDataType type)
  • protected virtual int GetMaxScale(SqlDataType type)
  • public ISqlExpression Inc(ISqlExpression expr1)
  • public ISqlExpression Mul(ISqlExpression expr1, ISqlExpression expr2, Type type)
  • public ISqlExpression Mul<T>(ISqlExpression expr1, ISqlExpression expr2)
  • public ISqlExpression Mul(ISqlExpression expr1, int value)
  • public void OptimizeJoins(SqlStatement statement)
  • public virtual SqlStatement OptimizeStatement(SqlStatement statement)
  • public ISqlExpression Sub(ISqlExpression expr1, ISqlExpression expr2, Type type)
  • public ISqlExpression Sub<T>(ISqlExpression expr1, ISqlExpression expr2)
  • public ISqlExpression Sub(ISqlExpression expr1, int value)
• public enum ConvertType
  • ExceptionToErrorMessage = 11
  • ExceptionToErrorNumber = 10
  • NameToCommandParameter = 1
  • NameToDatabase = 5
  • NameToOwner = 6
  • NameToQueryField = 3
  • NameToQueryFieldAlias = 4
  • NameToQueryParameter = 0
  • NameToQueryTable = 7
  • NameToQueryTableAlias = 8
  • NameToSchema = 6
  • NameToSprocParameter = 2
  • SprocParameterToName = 9
• public interface ISqlBuilder
  • string Name { get; }
  • string ApplyQueryHints(string sqlText, List<string> queryHints)
  • void BuildSql(int commandNumber, SqlStatement statement, StringBuilder sb, int startIndent = 0)
  • StringBuilder BuildTableName(StringBuilder sb, string database, string schema, string table)
  • int CommandCount(SqlStatement statement)
  • object Convert(object value, ConvertType convertType)
  • StringBuilder ConvertTableName(StringBuilder sb, string database, string schema, string table)
  • ISqlExpression GetIdentityExpression(SqlTable table)
  • string GetMaxValueSql(EntityDescriptor entity, ColumnDescriptor column)
  • string GetReserveSequenceValuesSql(int count, string sequenceName)
  • StringBuilder PrintParameters(StringBuilder sb, IDbDataParameter[] parameters)
• public interface ISqlOptimizer
  • ISqlExpression ConvertExpression(ISqlExpression expression)
  • ISqlPredicate ConvertPredicate(SelectQuery selectQuery, ISqlPredicate predicate)
  • SqlStatement Finalize(SqlStatement statement)
  • SqlStatement OptimizeStatement(SqlStatement statement)
• public class SqlProviderFlags
  • public bool AcceptsTakeAsParameter { get; set; }
  • public bool AcceptsTakeAsParameterIfSkip { get; set; }
  • public bool CanCombineParameters { get; set; }
  • public List<string> CustomFlags { get; }
  • public bool IsAllSetOperationsSupported { get; set; }
  • public bool IsApplyJoinSupported { get; set; }
  • public bool IsCommonTableExpressionsSupported { get; set; }
  • public bool IsCountSubQuerySupported { get; set; }
  • public bool IsCrossJoinSupported { get; set; }
  • public bool IsDistinctOrderBySupported { get; set; }
  • public bool IsDistinctSetOperationsSupported { get; set; }
  • public bool IsGroupByExpressionSupported { get; set; }
  • public bool IsIdentityParameterRequired { get; set; }
  • public bool IsInnerJoinAsCrossSupported { get; set; }
  • public bool IsInsertOrUpdateSupported { get; set; }
  • public bool IsOrderByAggregateFunctionsSupported { get; set; }
  • public bool IsParameterOrderDependent { get; set; }
  • public bool IsSkipSupported { get; set; }
  • public bool IsSkipSupportedIfTake { get; set; }
  • public bool IsSubQueryColumnSupported { get; set; }
  • public bool IsSubQueryOrderBySupported { get; set; }
  • public bool IsSubQueryTakeSupported { get; set; }
  • public bool IsSybaseBuggyGroupBy { get; set; }
  • public bool IsTakeSupported { get; set; }
  • public bool IsUpdateSetTableAliasSupported { get; set; }
  • public int MaxInListValuesCount { get; set; }
  • public TakeHints? TakeHintsSupported { get; set; }
  • public SqlProviderFlags()
  • public bool GetAcceptsTakeAsParameterFlag(SelectQuery selectQuery)
  • public bool GetIsSkipSupportedFlag(SelectQuery selectQuery)
  • public bool GetIsTakeHintsSupported(TakeHints hints)
• public class ValueToSqlConverter
  • public ValueToSqlConverter(ValueToSqlConverter[] converters)
  • public bool CanConvert(Type type)
  • public StringBuilder Convert(StringBuilder stringBuilder, object value)
  • public StringBuilder Convert(StringBuilder stringBuilder, SqlDataType dataType, object value)
  • public void SetConverter(Type type, Action<StringBuilder, SqlDataType, object> converter)
  • public bool TryConvert(StringBuilder stringBuilder, object value)
  • public bool TryConvert(StringBuilder stringBuilder, SqlDataType dataType, object value)

LinqToDB.SqlQuery

• public abstract class ClauseBase
  • public SqlFromClause From { get; }
  • public SqlGroupByClause GroupBy { get; }
  • public SqlWhereClause Having { get; }
  • public SqlOrderByClause OrderBy { get; }
  • public SqlSelectClause Select { get; }
  • public SqlWhereClause Where { get; }
  • protected ClauseBase(SelectQuery selectQuery)
  • public SelectQuery End()
• public abstract class ClauseBase<T1, T2> : ConditionBase<T1, T2> where T1 : ClauseBase<T1, T2>
  • public SqlFromClause From { get; }
  • public SqlGroupByClause GroupBy { get; }
  • public SqlWhereClause Having { get; }
  • public SqlOrderByClause OrderBy { get; }
  • public SqlSelectClause Select { get; }
  • protected ClauseBase(SelectQuery selectQuery)
  • public SelectQuery End()
• public abstract class ConditionBase<T1, T2> : IConditionExpr<Expr_<T1, T2>> where T1 : ConditionBase<T1, T2>
  • public class Expr_<T1, T2> where T1 : ConditionBase<T1, T2>
  • public class Not_<T1, T2> : IConditionExpr<Expr_<T1, T2>> where T1 : ConditionBase<T1, T2>
  • public Not_<T1, T2> Not { get; }
  • protected abstract SqlSearchCondition Search { get; }
  • protected ConditionBase()
  • public T2 Exists(SelectQuery subQuery)
  • public Expr_<T1, T2> Expr(ISqlExpression expr)
  • public Expr_<T1, T2> Field(SqlField field)
  • protected abstract T2 GetNext()
  • protected T1 SetOr(bool value)
  • public Expr_<T1, T2> SubQuery(SelectQuery selectQuery)
  • public Expr_<T1, T2> Value(object value)
• public class CteClause : IQueryElement, ICloneableElement, ISqlExpressionWalkable
  • public static int CteIDCounter
  • public SelectQuery Body { get; set; }
  • public int CteID { get; }
  • public QueryElementType ElementType { get; }
  • public SqlField[] Fields { get; }
  • public bool IsRecursive { get; set; }
  • public string Name { get; set; }
  • public Type ObjectType { get; set; }
  • public CteClause(SelectQuery body, Type objectType, bool isRecursive, string name)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public SqlField RegisterFieldMapping(ISqlExpression baseExpression, ISqlExpression expression, int index, Func<SqlField> fieldFactory)
  • public StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public enum DefaultNullable
  • None = 0
  • NotNull = 2
  • Null = 1
• public static class Extensions
  • public static Join CrossApply(this ISqlTableSource table, Join[] joins)
  • public static Join CrossApply(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join FullJoin(this ISqlTableSource table, Join[] joins)
  • public static Join FullJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join InnerJoin(this ISqlTableSource table, Join[] joins)
  • public static Join InnerJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join Join(this ISqlTableSource table, Join[] joins)
  • public static Join Join(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join LeftJoin(this ISqlTableSource table, Join[] joins)
  • public static Join LeftJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join OuterApply(this ISqlTableSource table, Join[] joins)
  • public static Join OuterApply(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join RightJoin(this ISqlTableSource table, Join[] joins)
  • public static Join RightJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join WeakInnerJoin(this ISqlTableSource table, Join[] joins)
  • public static Join WeakInnerJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join WeakJoin(this ISqlTableSource table, Join[] joins)
  • public static Join WeakJoin(this ISqlTableSource table, string alias, Join[] joins)
  • public static Join WeakLeftJoin(this ISqlTableSource table, Join[] joins)
  • public static Join WeakLeftJoin(this ISqlTableSource table, string alias, Join[] joins)
• public interface ICloneableElement
  • ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public interface IQueryElement
  • QueryElementType ElementType { get; }
  • StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
• public interface ISqlExpression : IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • bool CanBeNull { get; }
  • int Precedence { get; }
  • Type SystemType { get; }
  • bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public interface ISqlExpressionWalkable
  • ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public interface ISqlPredicate : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • bool CanBeNull { get; }
  • int Precedence { get; }
• public interface ISqlTableSource : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • SqlField All { get; }
  • int SourceID { get; }
  • SqlTableType SqlTableType { get; }
  • IList<ISqlExpression> GetKeys(bool allIfEmpty)
• public interface IValueContainer
  • object Value { get; }
• public enum JoinType
  • Auto = 0
  • CrossApply = 3
  • Full = 6
  • Inner = 1
  • Left = 2
  • OuterApply = 4
  • Right = 5
• public class ObjectSqlExpression : SqlExpression
  • public ObjectSqlExpression(MappingSchema mappingSchema, SqlInfo[] parameters)
  • public object GetValue(object obj, int index)
• public class Precedence
  • public const int Additive = 60
  • public const int Bitwise = 40
  • public const int Comparison = 50
  • public const int Concatenate = 85
  • public const int LogicalConjunction = 20
  • public const int LogicalDisjunction = 10
  • public const int LogicalNegation = 30
  • public const int Multiplicative = 80
  • public const int Primary = 100
  • public const int Subtraction = 70
  • public const int Unary = 90
  • public const int Unknown = 0
  • public Precedence()
• public enum QueryElementType
  • BetweenPredicate = 12
  • Column = 18
  • Condition = 20
  • CreateTableStatement = 42
  • CteClause = 34
  • DeleteStatement = 41
  • DropTableStatement = 43
  • ExprExprPredicate = 10
  • ExprPredicate = 8
  • FromClause = 27
  • FuncLikePredicate = 16
  • GroupByClause = 29
  • InListPredicate = 15
  • InsertClause = 24
  • InsertOrUpdateStatement = 39
  • InsertStatement = 38
  • InSubQueryPredicate = 14
  • IsNullPredicate = 13
  • JoinedTable = 22
  • LikePredicate = 11
  • NotExprPredicate = 9
  • OrderByClause = 30
  • OrderByItem = 31
  • SearchCondition = 19
  • SelectClause = 23
  • SelectStatement = 37
  • SetExpression = 26
  • SetOperator = 32
  • SqlBinaryExpression = 4
  • SqlCteTable = 35
  • SqlDataType = 6
  • SqlExpression = 3
  • SqlField = 0
  • SqlFunction = 1
  • SqlParameter = 2
  • SqlQuery = 17
  • SqlRawSqlTable = 36
  • SqlTable = 7
  • SqlValue = 5
  • TableSource = 21
  • TruncateTableStatement = 44
  • UpdateClause = 25
  • UpdateStatement = 40
  • WhereClause = 28
  • WithClause = 33
• public static class QueryHelper
  • public static bool CanRemoveOrderBy(SelectQuery selectQuery, SqlProviderFlags flags, QueryInformation information)
  • public static void CollectDependencies(IQueryElement root, IEnumerable<ISqlTableSource> sources, HashSet<ISqlExpression> found, IEnumerable<IQueryElement> ignore = null)
  • public static void ConcatSearchCondition(this SqlWhereClause where, SqlSearchCondition search)
  • public static void CorrectSearchConditionNesting(SelectQuery selectQuery, SqlSearchCondition searchCondition)
  • public static IEnumerable<ISqlTableSource> EnumerateLevelSources(SqlTableSource tableSource)
  • public static IEnumerable<ISqlTableSource> EnumerateLevelSources(SelectQuery selectQuery)
  • public static SqlJoinedTable FindJoin(this SelectQuery query, Func<SqlJoinedTable, bool> match)
  • public static SqlField GetUnderlyingField(ISqlExpression expression)
  • public static bool IsEqualTables(SqlTable table1, SqlTable table2)
  • public static ISqlExpression NeedColumnForExpression(SelectQuery selectQuery, ISqlExpression forExpression, bool inProjection)
  • public static SelectQuery RootQuery(this SelectQuery query)
  • public static bool TryConvertOrderedDistinctToGroupBy(SelectQuery select, SqlProviderFlags flags)
  • public static bool TryRemoveDistinct(SelectQuery selectQuery, QueryInformation information)
• public class QueryInformation
  • public class HierarchyInfo
  • public enum HierarchyType
  • public QueryInformation(SelectQuery rootQuery)
  • public HierarchyInfo GetHierarchyInfo(SelectQuery selectQuery)
  • public SelectQuery GetParentQuery(SelectQuery selectQuery)
  • public IEnumerable<SelectQuery> GetQueriesParentFirst()
  • public IEnumerable<SelectQuery> GetQueriesParentFirst(SelectQuery root)
  • public void Resync()
• public enum QueryType
  • CreateTable = 5
  • Delete = 1
  • DropTable = 6
  • Insert = 3
  • InsertOrUpdate = 4
  • Select = 0
  • TruncateTable = 7
  • Update = 2
• public class QueryVisitor
  • public IQueryElement ParentElement { get; }
  • public List<IQueryElement> Stack { get; }
  • public Dictionary<IQueryElement, IQueryElement> VisitedElements { get; }
  • public QueryVisitor()
  • public static IQueryElement Find(IQueryElement element, Func<IQueryElement, bool> find)
  • public T Convert<T>(T element, Func<IQueryElement, IQueryElement> action) where T : IQueryElement
  • public T ConvertImmutable<T>(T element, Func<IQueryElement, IQueryElement> action) where T : IQueryElement
  • public void Visit(IQueryElement element, Action<IQueryElement> action)
  • public void VisitAll(IQueryElement element, Action<IQueryElement> action)
  • public void VisitParentFirst(IQueryElement element, Func<IQueryElement, bool> action)
• public static class ReservedWords
  • public static void Add(string word, string providerName = null)
  • public static bool IsReserved(string word, string providerName = null)
• public class SelectQuery : ISqlTableSource, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public static int SourceIDCounter
  • public SqlField All { get; }
  • public bool CanBeNull { get; }
  • public bool DoNotRemove { get; set; }
  • public QueryElementType ElementType { get; }
  • public SqlFromClause From { get; }
  • public SqlGroupByClause GroupBy { get; }
  • public bool HasSetOperators { get; }
  • public bool HasUniqueKeys { get; }
  • public SqlWhereClause Having { get; }
  • public bool IsParameterDependent { get; set; }
  • public bool IsSimple { get; }
  • public SqlOrderByClause OrderBy { get; }
  • public SelectQuery ParentSelect { get; set; }
  • public int Precedence { get; }
  • public List<object> Properties { get; }
  • public SqlSelectClause Select { get; }
  • public List<SqlSetOperator> SetOperators { get; }
  • public int SourceID { get; }
  • public SqlTableType SqlTableType { get; }
  • public string SqlText { get; }
  • public Type SystemType { get; }
  • public List<ISqlExpression[]> UniqueKeys { get; }
  • public SqlWhereClause Where { get; }
  • public SelectQuery()
  • public void AddUnion(SelectQuery union, bool isAll)
  • public SelectQuery Clone()
  • public SelectQuery Clone(Predicate<ICloneableElement> doClone)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
  • public void ForEachTable(Action<SqlTableSource> action, HashSet<SelectQuery> visitedQueries)
  • public IList<ISqlExpression> GetKeys(bool allIfEmpty)
  • public ISqlTableSource GetTableSource(ISqlTableSource table)
  • public StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public enum SetOperation
  • Except = 3
  • ExceptAll = 4
  • Intersect = 8
  • IntersectAll = 10
  • Union = 1
  • UnionAll = 2
• public class SqlBinaryExpression : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public bool CanBeNull { get; }
  • public QueryElementType ElementType { get; }
  • public ISqlExpression Expr1 { get; }
  • public ISqlExpression Expr2 { get; }
  • public string Operation { get; }
  • public int Precedence { get; }
  • public string SqlText { get; }
  • public Type SystemType { get; }
  • public SqlBinaryExpression(Type systemType, ISqlExpression expr1, string operation, ISqlExpression expr2, int precedence)
  • public SqlBinaryExpression(Type systemType, ISqlExpression expr1, string operation, ISqlExpression expr2)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlColumn : IEquatable<SqlColumn>, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public string Alias { get; set; }
  • public bool CanBeNull { get; }
  • public QueryElementType ElementType { get; }
  • public ISqlExpression Expression { get; set; }
  • public SelectQuery Parent { get; set; }
  • public int Precedence { get; }
  • public Type SystemType { get; }
  • public SqlColumn UnderlyingColumn { get; }
  • public SqlColumn(SelectQuery parent, ISqlExpression expression, string alias)
  • public SqlColumn(SelectQuery builder, ISqlExpression expression)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(SqlColumn other)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public class SqlCondition : IQueryElement, ICloneableElement
  • public bool CanBeNull { get; }
  • public QueryElementType ElementType { get; }
  • public bool IsNot { get; set; }
  • public bool IsOr { get; set; }
  • public int Precedence { get; }
  • public ISqlPredicate Predicate { get; set; }
  • public SqlCondition(bool isNot, ISqlPredicate predicate)
  • public SqlCondition(bool isNot, ISqlPredicate predicate, bool isOr)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlCreateTableStatement : SqlStatement
  • public DefaultNullable DefaultNullable { get; set; }
  • public string StatementFooter { get; set; }
  • public string StatementHeader { get; set; }
  • public SqlTable Table { get; set; }
  • public SqlCreateTableStatement()
• public class SqlCteTable : SqlTable
  • public CteClause Cte { get; }
  • public string SqlText { get; }
  • public SqlCteTable(MappingSchema mappingSchema, CteClause cte)
  • public SqlCteTable(SqlCteTable table, IEnumerable<SqlField> fields, CteClause cte)
  • public StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
• public class SqlDataType : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public static readonly SqlDataType Boolean
  • public static readonly SqlDataType Byte
  • public static readonly SqlDataType ByteArray
  • public static readonly SqlDataType Char
  • public static readonly SqlDataType CharArray
  • public static readonly SqlDataType DateTime
  • public static readonly SqlDataType DateTimeOffset
  • public static readonly SqlDataType DbBinary
  • public static readonly SqlDataType DbBinaryJson
  • public static readonly SqlDataType DbBitArray
  • public static readonly SqlDataType DbBoolean
  • public static readonly SqlDataType DbByte
  • public static readonly SqlDataType DbChar
  • public static readonly SqlDataType DbDate
  • public static readonly SqlDataType DbDateTime
  • public static readonly SqlDataType DbDateTime2
  • public static readonly SqlDataType DbDateTimeOffset
  • public static readonly SqlDataType DbDecimal
  • public static readonly SqlDataType DbDictionary
  • public static readonly SqlDataType DbDouble
  • public static readonly SqlDataType DbGuid
  • public static readonly SqlDataType DbImage
  • public static readonly SqlDataType DbInt16
  • public static readonly SqlDataType DbInt32
  • public static readonly SqlDataType DbInt64
  • public static readonly SqlDataType DbJson
  • public static readonly SqlDataType DbMoney
  • public static readonly SqlDataType DbNChar
  • public static readonly SqlDataType DbNText
  • public static readonly SqlDataType DbNVarChar
  • public static readonly SqlDataType DbSByte
  • public static readonly SqlDataType DbSingle
  • public static readonly SqlDataType DbSmallDateTime
  • public static readonly SqlDataType DbSmallMoney
  • public static readonly SqlDataType DbText
  • public static readonly SqlDataType DbTime
  • public static readonly SqlDataType DbTimestamp
  • public static readonly SqlDataType DbUdt
  • public static readonly SqlDataType DbUInt16
  • public static readonly SqlDataType DbUInt32
  • public static readonly SqlDataType DbUInt64
  • public static readonly SqlDataType DbVarBinary
  • public static readonly SqlDataType DbVarChar
  • public static readonly SqlDataType DbVariant
  • public static readonly SqlDataType DbXml
  • public static readonly SqlDataType Decimal
  • public static readonly SqlDataType Double
  • public static readonly SqlDataType Guid
  • public static readonly SqlDataType Int16
  • public static readonly SqlDataType Int32
  • public static readonly SqlDataType LinqBinary
  • public static readonly SqlDataType SByte
  • public static readonly SqlDataType Single
  • public static readonly SqlDataType SqlBinary
  • public static readonly SqlDataType SqlBoolean
  • public static readonly SqlDataType SqlByte
  • public static readonly SqlDataType SqlBytes
  • public static readonly SqlDataType SqlChars
  • public static readonly SqlDataType SqlDateTime
  • public static readonly SqlDataType SqlDecimal
  • public static readonly SqlDataType SqlDouble
  • public static readonly SqlDataType SqlGuid
  • public static readonly SqlDataType SqlInt16
  • public static readonly SqlDataType SqlInt32
  • public static readonly SqlDataType SqlInt64
  • public static readonly SqlDataType SqlMoney
  • public static readonly SqlDataType SqlSingle
  • public static readonly SqlDataType SqlString
  • public static readonly SqlDataType SqlXml
  • public static readonly SqlDataType String
  • public static readonly SqlDataType TimeSpan
  • public static readonly SqlDataType UInt16
  • public static readonly SqlDataType UInt32
  • public static readonly SqlDataType UInt64
  • public static readonly SqlDataType Undefined
  • public bool CanBeNull { get; }
  • public DataType DataType { get; }
  • public string DbType { get; }
  • public QueryElementType ElementType { get; }
  • public bool IsCharDataType { get; }
  • public int? Length { get; }
  • public int Precedence { get; }
  • public int? Precision { get; }
  • public int? Scale { get; }
  • public Type SystemType { get; }
  • public Type Type { get; }
  • public SqlDataType(DataType dataType)
  • public SqlDataType(DbDataType dataType)
  • public SqlDataType(DataType dataType, int? length)
  • public SqlDataType(DataType dataType, int? precision, int? scale)
  • public SqlDataType(Type type)
  • public SqlDataType(Type type, int length)
  • public SqlDataType(Type type, int precision, int scale)
  • public SqlDataType(DataType dataType, Type type)
  • public SqlDataType(DataType dataType, Type type, int length)
  • public SqlDataType(DataType dataType, Type type, int precision, int scale)
  • public static SqlDataType GetDataType(Type type)
  • public static SqlDataType GetDataType(DataType type)
  • public static int GetMaxDisplaySize(DataType dbType)
  • public static int GetMaxLength(DataType dbType)
  • public static int GetMaxPrecision(DataType dbType)
  • public static int GetMaxScale(DataType dbType)
  • public static bool TypeCanBeNull(Type type)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlDeleteClause2 : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public QueryElementType ElementType { get; }
  • public SqlTable Table { get; set; }
  • public SqlDeleteClause2()
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlDeleteStatement : SqlStatementWithQueryBase
  • public SqlTable Table { get; set; }
  • public ISqlExpression Top { get; set; }
  • public SqlDeleteStatement(SelectQuery selectQuery)
  • public SqlDeleteStatement()
• public class SqlDropTableStatement : SqlStatement
  • public bool IfExists { get; }
  • public SqlTable Table { get; set; }
  • public SqlDropTableStatement(bool ifExists)
• public class SqlException : Exception
  • public SqlException()
  • public SqlException(string message)
  • public SqlException(string message, object[] args)
  • public SqlException(string message, Exception innerException)
  • public SqlException(Exception innerException)
  • protected SqlException(SerializationInfo info, StreamingContext context)
• public class SqlExpression : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public bool CanBeNull { get; set; }
  • public QueryElementType ElementType { get; }
  • public string Expr { get; }
  • public bool IsAggregate { get; }
  • public ISqlExpression[] Parameters { get; }
  • public int Precedence { get; }
  • public Type SystemType { get; }
  • public SqlExpression(Type systemType, string expr, int precedence, bool isAggregate, ISqlExpression[] parameters)
  • public SqlExpression(Type systemType, string expr, int precedence, ISqlExpression[] parameters)
  • public SqlExpression(string expr, int precedence, ISqlExpression[] parameters)
  • public SqlExpression(Type systemType, string expr, ISqlExpression[] parameters)
  • public SqlExpression(string expr, ISqlExpression[] parameters)
  • public static bool NeedsEqual(IQueryElement ex)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public static class SqlExtensions
  • public static T Clone<T>(this T cloneable) where T : ICloneableElement
  • public static T Clone<T>(this T cloneable, Predicate<ICloneableElement> doClone) where T : ICloneableElement
  • public static SelectQuery EnsureQuery(this SqlStatement statement)
  • public static SqlField GetIdentityField(this SqlStatement statement)
  • public static SqlInsertClause GetInsertClause(this SqlStatement statement)
  • public static SqlUpdateClause GetUpdateClause(this SqlStatement statement)
  • public static SqlWithClause GetWithClause(this SqlStatement statement)
  • public static bool IsInsert(this SqlStatement statement)
  • public static bool IsUpdate(this SqlStatement statement)
  • public static bool NeedsIdentity(this SqlStatement statement)
  • public static SqlInsertClause RequireInsertClause(this SqlStatement statement)
  • public static SqlUpdateClause RequireUpdateClause(this SqlStatement statement)
• public class SqlField : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public string Alias { get; set; }
  • public bool CanBeNull { get; set; }
  • public ColumnDescriptor ColumnDescriptor { get; set; }
  • public string CreateFormat { get; set; }
  • public int? CreateOrder { get; set; }
  • public DataType DataType { get; set; }
  • public string DbType { get; set; }
  • public QueryElementType ElementType { get; }
  • public bool IsDynamic { get; set; }
  • public bool IsIdentity { get; set; }
  • public bool IsInsertable { get; set; }
  • public bool IsPrimaryKey { get; set; }
  • public bool IsUpdatable { get; set; }
  • public int? Length { get; set; }
  • public string Name { get; set; }
  • public string PhysicalName { get; set; }
  • public int Precedence { get; }
  • public int? Precision { get; set; }
  • public int PrimaryKeyOrder { get; set; }
  • public int? Scale { get; set; }
  • public Type SystemType { get; set; }
  • public ISqlTableSource Table { get; set; }
  • public SqlField()
  • public SqlField(SqlField field)
  • public SqlField(ColumnDescriptor column)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlFromClause : ClauseBase, IQueryElement, ISqlExpressionWalkable
  • public class Join : ConditionBase<Join, Next>
  • public QueryElementType ElementType { get; }
  • public SqlTableSource this[ISqlTableSource table] { get; }
  • public SqlTableSource this[ISqlTableSource table, string alias] { get; }
  • public List<SqlTableSource> Tables { get; }
  • public ISqlTableSource FindTableSource(SqlTable table)
  • public bool IsChild(ISqlTableSource table)
  • public SqlFromClause Table(ISqlTableSource table, Join[] joins)
  • public SqlFromClause Table(ISqlTableSource table, string alias, Join[] joins)
• public class SqlFunction : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public bool CanBeNull { get; set; }
  • public QueryElementType ElementType { get; }
  • public bool IsAggregate { get; }
  • public string Name { get; }
  • public ISqlExpression[] Parameters { get; }
  • public int Precedence { get; }
  • public Type SystemType { get; }
  • public SqlFunction(Type systemType, string name, ISqlExpression[] parameters)
  • public SqlFunction(Type systemType, string name, bool isAggregate, ISqlExpression[] parameters)
  • public SqlFunction(Type systemType, string name, bool isAggregate, int precedence, ISqlExpression[] parameters)
  • public static SqlFunction CreateAll(SelectQuery subQuery)
  • public static SqlFunction CreateAny(SelectQuery subQuery)
  • public static SqlFunction CreateCount(Type type, ISqlTableSource table)
  • public static SqlFunction CreateExists(SelectQuery subQuery)
  • public static SqlFunction CreateSome(SelectQuery subQuery)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlGroupByClause : ClauseBase, IQueryElement, ISqlExpressionWalkable
  • public QueryElementType ElementType { get; }
  • public bool IsEmpty { get; }
  • public List<ISqlExpression> Items { get; }
  • public SqlGroupByClause Expr(ISqlExpression expr)
  • public SqlGroupByClause Field(SqlField field)
• public class SqlInsertClause : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public QueryElementType ElementType { get; }
  • public SqlTable Into { get; set; }
  • public List<SqlSetExpression> Items { get; }
  • public bool WithIdentity { get; set; }
  • public SqlInsertClause()
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlInsertOrUpdateStatement : SqlStatementWithQueryBase
  • public SqlInsertClause Insert { get; set; }
  • public SqlUpdateClause Update { get; set; }
  • public SqlInsertOrUpdateStatement(SelectQuery selectQuery)
• public class SqlInsertStatement : SqlStatementWithQueryBase
  • public SqlInsertClause Insert { get; set; }
  • public SqlInsertStatement()
  • public SqlInsertStatement(SelectQuery selectQuery)
• public class SqlInsertWithIdentity
  • public SqlInsertWithIdentity()
• public class SqlJoinedTable : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public bool CanConvertApply { get; set; }
  • public SqlSearchCondition Condition { get; }
  • public QueryElementType ElementType { get; }
  • public bool IsWeak { get; set; }
  • public JoinType JoinType { get; set; }
  • public SqlTableSource Table { get; set; }
  • public SqlJoinedTable(JoinType joinType, SqlTableSource table, bool isWeak, SqlSearchCondition searchCondition)
  • public SqlJoinedTable(JoinType joinType, SqlTableSource table, bool isWeak)
  • public SqlJoinedTable(JoinType joinType, ISqlTableSource table, string alias, bool isWeak)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> action)
• public class SqlOrderByClause : ClauseBase, IQueryElement, ISqlExpressionWalkable
  • public QueryElementType ElementType { get; }
  • public bool IsEmpty { get; }
  • public List<SqlOrderByItem> Items { get; }
  • public SqlOrderByClause Expr(ISqlExpression expr, bool isDescending)
  • public SqlOrderByClause Expr(ISqlExpression expr)
  • public SqlOrderByClause ExprAsc(ISqlExpression expr)
  • public SqlOrderByClause ExprDesc(ISqlExpression expr)
  • public SqlOrderByClause Field(SqlField field, bool isDescending)
  • public SqlOrderByClause Field(SqlField field)
  • public SqlOrderByClause FieldAsc(SqlField field)
  • public SqlOrderByClause FieldDesc(SqlField field)
• public class SqlOrderByItem : IQueryElement, ICloneableElement
  • public QueryElementType ElementType { get; }
  • public ISqlExpression Expression { get; }
  • public bool IsDescending { get; }
  • public SqlOrderByItem(ISqlExpression expression, bool isDescending)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlParameter : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement, IValueContainer
  • public bool CanBeNull { get; }
  • public DataType DataType { get; set; }
  • public int? DbSize { get; set; }
  • public string DbType { get; set; }
  • public QueryElementType ElementType { get; }
  • public bool IsQueryParameter { get; set; }
  • public string LikeEnd { get; set; }
  • public string LikeStart { get; set; }
  • public string Name { get; set; }
  • public int Precedence { get; }
  • public bool ReplaceLike { get; set; }
  • public Type SystemType { get; set; }
  • public object Value { get; set; }
  • public Func<object, object> ValueConverter { get; set; }
  • public SqlParameter(Type systemType, string name, object value)
  • public SqlParameter(Type systemType, string name, object value, Func<object, object> valueConverter)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public abstract class SqlPredicate : ISqlPredicate, IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public class Between : NotExpr
  • public class Expr : SqlPredicate
  • public class ExprExpr : Expr
  • public class FuncLike : SqlPredicate
  • public class InList : NotExpr
  • public class InSubQuery : NotExpr
  • public class IsNull : NotExpr
  • public class Like : NotExpr
  • public class NotExpr : Expr
  • public enum Operator
  • public abstract bool CanBeNull { get; }
  • public abstract QueryElementType ElementType { get; }
  • public int Precedence { get; }
  • protected SqlPredicate(int precedence)
  • protected abstract ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • protected abstract void ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
  • protected abstract void Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> action)
• public class SqlRawSqlTable : SqlTable, IQueryElement
  • public ISqlExpression[] Parameters { get; }
  • public string SQL { get; }
  • public string SqlText { get; }
  • public SqlRawSqlTable(MappingSchema mappingSchema, Type objectType, string sql, ISqlExpression[] parameters)
  • public SqlRawSqlTable(SqlRawSqlTable table, IEnumerable<SqlField> fields, ISqlExpression[] parameters)
• public class SqlSearchCondition : ConditionBase<SqlSearchCondition, Next>, ISqlPredicate, IQueryElement, ISqlExpressionWalkable, ICloneableElement, ISqlExpression, IEquatable<ISqlExpression>
  • public class Next
  • public bool CanBeNull { get; }
  • public List<SqlCondition> Conditions { get; }
  • public QueryElementType ElementType { get; }
  • public int Precedence { get; }
  • public Type SystemType { get; }
  • public SqlSearchCondition()
  • public SqlSearchCondition(IEnumerable<SqlCondition> list)
  • public SqlSearchCondition(SqlCondition[] list)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlSelectClause : ClauseBase, IQueryElement, ISqlExpressionWalkable
  • public List<SqlColumn> Columns { get; }
  • public QueryElementType ElementType { get; }
  • public bool HasModifier { get; }
  • public bool IsDistinct { get; set; }
  • public ISqlExpression SkipValue { get; set; }
  • public TakeHints? TakeHints { get; }
  • public ISqlExpression TakeValue { get; }
  • public int Add(ISqlExpression expr)
  • public int Add(ISqlExpression expr, string alias)
  • public int AddNew(ISqlExpression expr)
  • public SqlColumn AddNewColumn(ISqlExpression expr)
  • public SqlSelectClause Expr(ISqlExpression expr)
  • public SqlSelectClause Expr(ISqlExpression expr, string alias)
  • public SqlSelectClause Expr(string expr, ISqlExpression[] values)
  • public SqlSelectClause Expr(Type systemType, string expr, ISqlExpression[] values)
  • public SqlSelectClause Expr(string expr, int priority, ISqlExpression[] values)
  • public SqlSelectClause Expr(Type systemType, string expr, int priority, ISqlExpression[] values)
  • public SqlSelectClause Expr(string alias, string expr, int priority, ISqlExpression[] values)
  • public SqlSelectClause Expr(Type systemType, string alias, string expr, int priority, ISqlExpression[] values)
  • public SqlSelectClause Expr<T>(ISqlExpression expr1, string operation, ISqlExpression expr2)
  • public SqlSelectClause Expr<T>(ISqlExpression expr1, string operation, ISqlExpression expr2, int priority)
  • public SqlSelectClause Expr<T>(string alias, ISqlExpression expr1, string operation, ISqlExpression expr2, int priority)
  • public SqlSelectClause ExprNew(ISqlExpression expr)
  • public SqlSelectClause Field(SqlField field)
  • public SqlSelectClause Field(SqlField field, string alias)
  • public SqlSelectClause Skip(int value)
  • public SqlSelectClause Skip(ISqlExpression value)
  • public SqlSelectClause SubQuery(SelectQuery subQuery)
  • public SqlSelectClause SubQuery(SelectQuery selectQuery, string alias)
  • public SqlSelectClause Take(int value, TakeHints? hints)
  • public SqlSelectClause Take(ISqlExpression value, TakeHints? hints)
• public class SqlSelectStatement : SqlStatementWithQueryBase
  • public SqlSelectStatement(SelectQuery selectQuery)
  • public SqlSelectStatement()
• public class SqlSetExpression : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public ISqlExpression Column { get; set; }
  • public QueryElementType ElementType { get; }
  • public ISqlExpression Expression { get; set; }
  • public SqlSetExpression(ISqlExpression column, ISqlExpression expression)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlSetOperator : IQueryElement
  • public QueryElementType ElementType { get; }
  • public SetOperation Operation { get; }
  • public SelectQuery SelectQuery { get; }
  • public SqlSetOperator()
  • public SqlSetOperator(SelectQuery selectQuery, SetOperation operation)
• public abstract class SqlStatement : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public abstract QueryElementType ElementType { get; }
  • public abstract bool IsParameterDependent { get; set; }
  • public List<SqlParameter> Parameters { get; }
  • public abstract QueryType QueryType { get; }
  • public abstract SelectQuery SelectQuery { get; set; }
  • public string SqlText { get; }
  • protected SqlStatement()
  • public abstract ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public void CollectParameters()
  • public virtual IEnumerable<IQueryElement> EnumClauses()
  • public string GetAlias(string desiredAlias, string defaultAlias)
  • public abstract ISqlTableSource GetTableSource(ISqlTableSource table)
  • public string[] GetTempAliases(int n, string defaultAlias)
  • public SqlStatement ProcessParameters(MappingSchema mappingSchema)
  • public void RemoveAlias(string alias)
  • public abstract StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
  • public abstract ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
  • public abstract void WalkQueries(Func<SelectQuery, SelectQuery> func)
• public abstract class SqlStatementWithQueryBase : SqlStatement
  • public SqlWithClause With { get; set; }
  • protected SqlStatementWithQueryBase(SelectQuery selectQuery)
• public class SqlTable : ISqlTableSource, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public string Alias { get; set; }
  • public SqlField All { get; }
  • public string Database { get; set; }
  • public virtual QueryElementType ElementType { get; }
  • public Dictionary<string, SqlField> Fields { get; }
  • public SqlField this[string fieldName] { get; }
  • public virtual string Name { get; set; }
  • public Type ObjectType { get; set; }
  • public virtual string PhysicalName { get; set; }
  • public string Schema { get; set; }
  • public SequenceNameAttribute[] SequenceAttributes { get; protected set; }
  • public int SourceID { get; protected set; }
  • public virtual SqlTableType SqlTableType { get; set; }
  • public ISqlExpression[] TableArguments { get; set; }
  • public SqlTable()
  • public SqlTable(MappingSchema mappingSchema, Type objectType, string physicalName = null)
  • public SqlTable(Type objectType)
  • public SqlTable(SqlTable table)
  • public SqlTable(SqlTable table, IEnumerable<SqlField> fields, ISqlExpression[] tableArguments)
  • public void Add(SqlField field)
  • public void AddRange(IEnumerable<SqlField> collection)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
  • public SqlField GetIdentityField()
  • public IList<ISqlExpression> GetKeys(bool allIfEmpty)
  • public virtual ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public class SqlTable<T> : SqlTable
  • public SqlTable()
  • public SqlTable(MappingSchema mappingSchema)
• public class SqlTableSource : ISqlTableSource, ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement
  • public string Alias { get; set; }
  • public SqlField All { get; }
  • public bool CanBeNull { get; }
  • public QueryElementType ElementType { get; }
  • public bool HasUniqueKeys { get; }
  • public SqlTableSource this[ISqlTableSource table] { get; }
  • public SqlTableSource this[ISqlTableSource table, string alias] { get; }
  • public List<SqlJoinedTable> Joins { get; }
  • public int Precedence { get; }
  • public ISqlTableSource Source { get; set; }
  • public int SourceID { get; }
  • public SqlTableType SqlTableType { get; }
  • public Type SystemType { get; }
  • public List<ISqlExpression[]> UniqueKeys { get; }
  • public SqlTableSource(ISqlTableSource source, string alias)
  • public SqlTableSource(ISqlTableSource source, string alias, SqlJoinedTable[] joins)
  • public SqlTableSource(ISqlTableSource source, string alias, IEnumerable<SqlJoinedTable> joins, IEnumerable<ISqlExpression[]> uniqueKeys)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
  • public void ForEach(Action<SqlTableSource> action, HashSet<SelectQuery> visitedQueries)
  • public int GetJoinNumber()
  • public IEnumerable<ISqlTableSource> GetTables()
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
• public enum SqlTableType
  • Cte = 3
  • Expression = 2
  • Function = 1
  • RawSql = 4
  • Table = 0
• public class SqlTruncateTableStatement : SqlStatement
  • public bool ResetIdentity { get; set; }
  • public SqlTable Table { get; set; }
  • public SqlTruncateTableStatement()
• public class SqlUpdateClause : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public QueryElementType ElementType { get; }
  • public List<SqlSetExpression> Items { get; }
  • public List<SqlSetExpression> Keys { get; }
  • public SqlTable Table { get; set; }
  • public SqlUpdateClause()
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
• public class SqlUpdateStatement : SqlStatementWithQueryBase
  • public SqlUpdateClause Update { get; set; }
  • public SqlUpdateStatement(SelectQuery selectQuery)
• public class SqlValue : ISqlExpression, IQueryElement, IEquatable<ISqlExpression>, ISqlExpressionWalkable, ICloneableElement, IValueContainer
  • public bool CanBeNull { get; }
  • public QueryElementType ElementType { get; }
  • public int Precedence { get; }
  • public Type SystemType { get; }
  • public object Value { get; }
  • public DbDataType ValueType { get; set; }
  • public SqlValue(Type systemType, object value)
  • public SqlValue(DbDataType valueType, object value)
  • public SqlValue(object value)
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
• public class SqlWhereClause : ClauseBase<SqlWhereClause, Next>, IQueryElement, ISqlExpressionWalkable
  • public class Next : ClauseBase
  • public QueryElementType ElementType { get; }
  • public bool IsEmpty { get; }
  • public SqlSearchCondition SearchCondition { get; }
• public class SqlWithClause : IQueryElement, ISqlExpressionWalkable, ICloneableElement
  • public List<CteClause> Clauses { get; set; }
  • public QueryElementType ElementType { get; }
  • public SqlWithClause()
  • public ICloneableElement Clone(Dictionary<ICloneableElement, ICloneableElement> objectTree, Predicate<ICloneableElement> doClone)
  • public ISqlTableSource GetTableSource(ISqlTableSource table)
  • public StringBuilder ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
  • public ISqlExpression Walk(WalkOptions options, Func<ISqlExpression, ISqlExpression> func)
  • public void WalkQueries(Func<SelectQuery, SelectQuery> func)
• public class WalkOptions
  • public bool ProcessParent
  • public bool SkipColumns
  • public WalkOptions()
  • public WalkOptions(bool skipColumns)

LinqToDB.Tools

• public static class DataExtensions
  • public static IEnumerable<T> RetrieveIdentity<T>(this IEnumerable<T> source, DataConnection context, bool useSequenceName = true)
• public static class SqlExtensions
  • public static bool In<T>(this T value, IEnumerable<T> sequence)
  • public static bool In<T>(this T value, IQueryable<T> sequence)
  • public static bool In<T>(this T value, T[] sequence)
  • public static bool In<T>(this T value, T cmp1, T cmp2)
  • public static bool In<T>(this T value, T cmp1, T cmp2, T cmp3)
  • public static bool NotIn<T>(this T value, IEnumerable<T> sequence)
  • public static bool NotIn<T>(this T value, IQueryable<T> sequence)
  • public static bool NotIn<T>(this T value, T[] sequence)
  • public static bool NotIn<T>(this T value, T cmp1, T cmp2)
  • public static bool NotIn<T>(this T value, T cmp1, T cmp2, T cmp3)

System.Data.Linq

• public sealed class Binary : IEquatable<Binary>
  • public int Length { get; }
  • public Binary(byte[] value)
  • public static bool op_Equality(Binary binary1, Binary binary2)
  • public static Binary op_Implicit(byte[] value)
  • public static bool op_Inequality(Binary binary1, Binary binary2)
  • public bool Equals(Binary other)
  • public byte[] ToArray()