public static bool NeedsExecuteBlockStatement(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool IsCaseSensitive(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool CanUseRowNumber(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql) && dialect >= SqlDialect.MsSql2005);
}
public static bool CanUseOffsetFetch(this SqlDialect dialect)
{
return((dialect.HasFlag(SqlDialect.MsSql) && dialect >= SqlDialect.MsSql2012) ||
dialect.HasFlag(SqlDialect.Sqlite));
}
public static bool UseScopeIdentity(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql) || dialect.HasFlag(SqlDialect.Sqlite));
}
public static bool MultipleResultsets(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql));
}
public static string TimeFormat(this SqlDialect dialect)
{
return("\\'HH':'mm':'ss\\'");
}
public static bool UseReturningIdentity(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool PrefixUnicodeStringsWithN(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql));
}
public static bool CanUseSkipKeyword(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool UseTakeAtEnd(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Sqlite));
}
public QueryWithParams()
{
dialect = SqlSettings.CurrentDialect;
}
/// <summary>
/// Sets the dialect (SQL server type / version) for query.
/// </summary>
/// <remarks>TODO: SqlDialect system should be improved.</remarks>
public SqlQuery Dialect(SqlDialect dialect)
{
this.dialect = dialect;
return(this);
}
