public WhereClause(string oprator, IList <object> arguments, IODataOptions options)
: base(options)
{
Requires.NotNull(oprator, nameof(oprator));
Requires.NotNull(arguments, nameof(arguments));
this.oprator = oprator;
this.arguments = arguments;
}
/// <summary>
/// Builds a <c>WHERE</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="startWith">The operator to start with.</param>
/// <param name="arguments">The list where to store values of SQL arguments.</param>
/// <param name="options">The OData query options.</param>
/// <param name="resolveColumn">A function used to resolve column names.</param>
public static string Build(string startWith, IList <object> arguments, IODataOptions options, Func <PropertyInfo, string> resolveColumn)
{
var clause = new WhereClause(startWith, arguments, options);
if (resolveColumn != null)
{
clause.ResolveColumn = resolveColumn;
}
return(clause.Build());
}
/// <summary>
/// Builds a <c>SELECT</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="commandText">
/// The SQL command text containing a <c>SELECT</c> clause to modify.
/// </param>
/// <param name="options">The OData query options.</param>
/// <param name="resolveColumn">A function used to resolve column names.</param>
public static string Build(string commandText, IODataOptions options, Func <PropertyInfo, string> resolveColumn)
{
var clause = new SelectClause(commandText, options);
if (resolveColumn != null)
{
clause.ResolveColumn = resolveColumn;
}
return(clause.Build());
}
/// <summary>
/// Builds a <c>SELECT COUNT(Key)</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="commandText">
/// The SQL command text containing a <c>SELECT</c> clause to modify.
/// </param>
/// <param name="options">The OData query options.</param>
/// <param name="resolveKey">A function used to resolve primary key column name.</param>
public static string Build(string commandText, IODataOptions options, Func <Type, string> resolveKey)
{
var clause = new CountClause(commandText, options);
if (resolveKey != null)
{
clause.ResolveKey = resolveKey;
}
return(clause.Build());
}
/// <summary>
/// Builds a <c>ORDER BY</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="options">The OData query options.</param>
/// <param name="resolveColumn">A function used to resolve column names.</param>
public static string Build(IODataOptions options, Func <PropertyInfo, string> resolveColumn)
{
var clause = new OrderByClause(options);
if (resolveColumn != null)
{
clause.ResolveColumn = resolveColumn;
}
return(clause.Build());
}
public CountClause(string commandText, IODataOptions options)
: base(options)
{
Requires.NotNull(commandText, nameof(commandText));
this.commandText = commandText.Trim();
if (!SelectClause.Regex.IsMatch(commandText))
{
throw new NotSupportedException("The SQL command text does not contain any of supported SELECT clauses.");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="TopClause" /> class.
/// </summary>
/// <param name="options">The OData query options.</param>
public TopClause(IODataOptions options)
: base(options)
{
}
public SignalController(IAppUnitOfWork unitOfWork, IODataOptions oDataOptions) : base(unitOfWork, oDataOptions)
{
}
/// <summary>
/// Builds a <c>SELECT COUNT(Key)</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="commandText">
/// The SQL command text containing a <c>SELECT</c> clause to modify.
/// </param>
/// <param name="options">The OData query options.</param>
public static string Build(string commandText, IODataOptions options)
{
return(Build(commandText, options, null));
}
/// <summary>
/// Builds a <c>SELECT COUNT(Key)</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="options">The OData query options.</param>
public static string Build(IODataOptions options)
{
return(Build(options, null));
}
/// <summary>
/// Initializes a new instance of the <see cref="OrderByClause" /> class.
/// </summary>
/// <param name="options">The OData query options.</param>
public OrderByClause(IODataOptions options)
: base(options)
{
}
public InstallationController(IAppUnitOfWork unitOfWork, IODataOptions oDataOptions) : base(unitOfWork,
oDataOptions)
{
}
public static IQueryTimeSpan QueryTimeSpan(this IODataOptions oDataOptions) => oDataOptions?.QueryTimeSpan ?? ODataOptions.Default.QueryTimeSpan;
/// <summary> /// Builds a <c>SELECT</c> SQL clause using the given OData query options. /// </summary> /// <param name="commandText"> /// The SQL command text containing a <c>SELECT</c> clause to modify. /// </param> /// <param name="options">The OData query options.</param> public static string Build(string commandText, IODataOptions options) => Build(commandText, options, null);
/// <summary> /// Builds a <c>SELECT</c> SQL clause using the given OData query options. /// </summary> /// <param name="options">The OData query options.</param> public static string Build(IODataOptions options) => Build(options, null);
/// <summary>
/// Initializes a new instance of the <see cref="SelectClause" /> class.
/// </summary>
/// <param name="options">The OData query options.</param>
public SelectClause(IODataOptions options)
: this("SELECT FROM", options)
{
}
public OffsetClause(IODataOptions options)
: base(options)
{
}
/// <summary>
/// Builds an <c>OFFSET</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="options">The OData query options.</param>
public static string Build(IODataOptions options)
{
return(new OffsetClause(options).Build());
}
/// <summary> /// Builds a <c>TOP(n)</c> SQL clause using the given OData query options. /// </summary> /// <param name="options">The OData query options.</param> public static string Build(IODataOptions options) => new TopClause(options).Build();
protected SqlClauseBase(IODataOptions options)
{
Requires.NotNull(options, nameof(options));
Options = options;
}
/// <summary>
/// Builds a <c>WHERE</c> SQL clause using the given OData query options.
/// </summary>
/// <param name="startWith">The operator to start with.</param>
/// <param name="arguments">The list where to store values of SQL arguments.</param>
/// <param name="options">The OData query options.</param>
public static string Build(string startWith, IList <object> arguments, IODataOptions options)
{
return(Build(startWith, arguments, options, null));
}
public static ISchedulerProvider SchedulerProvider(this IODataOptions oDataOptions) => oDataOptions?.SchedulerProvider ?? ODataOptions.Default.SchedulerProvider;
protected DataUnitOfWorkControllerBase(IAppUnitOfWork unitOfWork, IODataOptions oDataOptions) : base(
unitOfWork)
{
ODataOptions = oDataOptions;
}
public static IOdataApplyOptions ApplyOptions(this IODataOptions oDataOptions) => oDataOptions?.ApplyOptions ?? ODataOptions.Default.ApplyOptions;
public CountClause(IODataOptions options)
: this("SELECT FROM", options)
{
}
