SqlServer2000Dialect class

namespace: Serenity.Data   assemblySerenity.Net.Data

SqlServer 2000 dialect.

public class SqlServer2000Dialect : ISqlDialect

Public Members

name description
SqlServer2000Dialect() The default constructor.
virtual CanUseOffsetFetch { get; } Gets a value indicating whether the server supports OFFSET FETCH.
virtual CanUseRowNumber { get; } Gets a value indicating whether the server supports ROWNUMBER.
virtual CanUseSkipKeyword { get; } Gets a value indicating whether the server supports SKIP keyword (or a variation of it).
virtual CloseQuote { get; } Gets the close quote character for quoting identifiers.
virtual ConcatOperator { get; } Gets the CONCAT operator keyword.
virtual DateFormat { get; } Gets the date format.
virtual DateTimeFormat { get; } Gets the date time format.
virtual IsLikeCaseSensitive { get; } Gets a value indicating whether the LIKE operator is case sensitive.
virtual MultipleResultsets { get; } Gets a value indicating whether the server supports multiple resultsets.
virtual NeedsBoolWorkaround { get; } Gets a value indicating whether the server needs a workaround to handle Boolean values false/true.
virtual NeedsExecuteBlockStatement { get; } Gets a value indicating whether the server needs EXECUTE BLOCK statement.
virtual OffsetFetchFormat { get; } Gets the format for OFFSET FETCH statements.
virtual OffsetFormat { get; } Gets the format for OFFSET only statements.
virtual OpenQuote { get; } Gets the open quote character for quoting identifiers.
virtual ParameterPrefix { get; } Gets the parameter prefix character.
virtual RequiresBoolConversion { get; } Gets a value indicating whether [requires bool conversion].
virtual ScopeIdentityExpression { get; } Gets the SCOPE IDENTITY expression.
virtual ServerType { get; } Gets the type of the server.
virtual SkipKeyword { get; } Gets the skip keyword.
virtual TakeKeyword { get; } Gets the take keyword.
virtual TimeFormat { get; } Gets the time format.
virtual UseDateTime2 { get; } Gets a value indicating whether use datetime2 type.
virtual UseReturningIdentity { get; } Gets a value indicating whether to use returning identity.
virtual UseReturningIntoVar { get; } Gets a value indicating whether use returning into variable.
virtual UseRowNum { get; } Gets a value indicating whether ROWNUM.
virtual UseScopeIdentity { get; } Gets a value indicating whether to use scope identity.
virtual UseTakeAtEnd { get; } Gets a value indicating whether to use TAKE at end.
virtual QuoteColumnAlias(…) Quotes the column alias. This usually calls QuoteIdentifier except for Oracle.
virtual QuoteIdentifier(…) Quotes the identifier.
virtual QuoteUnicodeString(…) Quotes the unicode string.
UnionKeyword(…) Gets the union keyword for specified union type.
static readonly Instance The shared instance of SqlServer2000 dialect.

See Also