-
Notifications
You must be signed in to change notification settings - Fork 795
/
SqlServer2012Dialect.cs
41 lines (36 loc) · 1.15 KB
/
SqlServer2012Dialect.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
namespace Serenity.Data;
/// <summary>
/// Sql Server 2012 dialect.
/// </summary>
/// <seealso cref="SqlServer2008Dialect" />
public class SqlServer2012Dialect : SqlServer2008Dialect
{
/// <summary>
/// The shared instance of SqlServer2012Dialect.
/// </summary>
public static new readonly ISqlDialect Instance = new SqlServer2012Dialect();
/// <inheritdoc/>
public override bool CanUseConcat => true;
/// <summary>
/// Gets a value indicating whether the server supports OFFSET FETCH.
/// </summary>
/// <value>
/// <c>true</c> if the server supports OFFSET FETCH; otherwise, <c>false</c>.
/// </value>
public override bool CanUseOffsetFetch => true;
/// <summary>
/// Gets the format for OFFSET only statements.
/// </summary>
/// <value>
/// The offset format.
/// </value>
public override string OffsetFormat => " OFFSET {0} ROWS";
/// <summary>
/// Gets the format for OFFSET FETCH statements.
/// </summary>
/// <value>
/// The offset fetch format.
/// </value>
public override string OffsetFetchFormat => " OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY";
}