Table of Contents

Class SqlCeHints

Namespace
LinqToDB.DataProvider.SqlCe
Assembly
linq2db.dll
public static class SqlCeHints
Inheritance
SqlCeHints

Methods

TableHint<TSource>(ISqlCeSpecificTable<TSource>, string)

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificTable<TSource> TableHint<TSource>(this ISqlCeSpecificTable<TSource> table, string hint) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlCeSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TableHint<TSource, TParam>(ISqlCeSpecificTable<TSource>, string, TParam)

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TableHint, typeof(HintWithParameterExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificTable<TSource> TableHint<TSource, TParam>(this ISqlCeSpecificTable<TSource> table, string hint, TParam hintParameter) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameter TParam

Table hint parameter.

Returns

ISqlCeSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TableHint<TSource, TParam>(ISqlCeSpecificTable<TSource>, string, params TParam[])

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TableHint, typeof(HintWithParametersExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificTable<TSource> TableHint<TSource, TParam>(this ISqlCeSpecificTable<TSource> table, string hint, params TParam[] hintParameters) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameters TParam[]

Table hint parameters.

Returns

ISqlCeSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TablesInScopeHint<TSource>(ISqlCeSpecificQueryable<TSource>, string)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificQueryable<TSource> TablesInScopeHint<TSource>(this ISqlCeSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlCeSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlCeSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint<TSource>(ISqlCeSpecificQueryable<TSource>, string, params object[])

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintWithParametersExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificQueryable<TSource> TablesInScopeHint<TSource>(this ISqlCeSpecificQueryable<TSource> source, string hint, params object[] hintParameters) where TSource : notnull

Parameters

source ISqlCeSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameters object[]

Table hint parameters.

Returns

ISqlCeSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint<TSource, TParam>(ISqlCeSpecificQueryable<TSource>, string, TParam)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlCe", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintWithParameterExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlCeSpecificQueryable<TSource> TablesInScopeHint<TSource, TParam>(this ISqlCeSpecificQueryable<TSource> source, string hint, TParam hintParameter) where TSource : notnull

Parameters

source ISqlCeSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameter TParam

Table hint parameter.

Returns

ISqlCeSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

WithHoldLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithHoldLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithHoldLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithHoldLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithHoldLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithHoldLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithIndex<TSource>(ISqlCeSpecificTable<TSource>, string) 

[ExpressionMethod("WithIndexImpl")]
public static ISqlCeSpecificTable<TSource> WithIndex<TSource>(this ISqlCeSpecificTable<TSource> table, string indexName) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>
indexName string

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithIndex<TSource>(ISqlCeSpecificTable<TSource>, params string[]) 

[ExpressionMethod("WithIndex2Impl")]
public static ISqlCeSpecificTable<TSource> WithIndex<TSource>(this ISqlCeSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>
indexNames string[]

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithNoLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithNoLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithNoLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithNoLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithNoLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithNoLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithPagLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithPagLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithPagLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithPagLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithPagLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithPagLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithRowLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithRowLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithRowLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithRowLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithRowLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithRowLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithTabLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithTabLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithTabLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithTabLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithTabLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithTabLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithUpdLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithUpdLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithUpdLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithUpdLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithUpdLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithUpdLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource

WithXLockInScope<TSource>(ISqlCeSpecificQueryable<TSource>) 

[ExpressionMethod("SqlCe", "WithXLockQueryImpl")]
public static ISqlCeSpecificQueryable<TSource> WithXLockInScope<TSource>(this ISqlCeSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlCeSpecificQueryable<TSource>

Returns

ISqlCeSpecificQueryable<TSource>

Type Parameters

TSource

WithXLock<TSource>(ISqlCeSpecificTable<TSource>) 

[ExpressionMethod("SqlCe", "WithXLockTableImpl")]
public static ISqlCeSpecificTable<TSource> WithXLock<TSource>(this ISqlCeSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlCeSpecificTable<TSource>

Returns

ISqlCeSpecificTable<TSource>

Type Parameters

TSource