public static string ScopeIdentityExpression(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.MsSql))
{
return("SCOPE_IDENTITY()");
}
if (dialect.HasFlag(SqlDialect.Sqlite))
{
return("last_insert_rowid()");
}
throw new NotImplementedException();
}
public static string DateTimeFormat(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Firebird))
{
return("\\'yyyy'-'MM'-'dd HH':'mm':'ss'.'fff\\'");
}
return("\\'yyyy'-'MM'-'ddTHH':'mm':'ss'.'fff\\'");
}
public static string DateFormat(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Firebird))
{
return("\\'yyyy'-'MM'-'dd\\'");
}
return("\\'yyyyMMdd\\'");
}
public static string SkipKeyword(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Firebird))
{
return("SKIP");
}
throw new InvalidOperationException();
}
public static string OffsetFetchFormat(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Sqlite))
{
return(" LIMIT {1} OFFSET {0}");
}
return(" OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY");
}
public static string OffsetFormat(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Sqlite))
{
return(" OFFSET {0}");
}
return(" OFFSET {0} ROWS");
}
public static string TakeKeyword(this SqlDialect dialect)
{
if (dialect.HasFlag(SqlDialect.Firebird))
{
return("FIRST");
}
if (dialect.HasFlag(SqlDialect.MsSql))
{
return("TOP");
}
if (dialect.HasFlag(SqlDialect.Sqlite))
{
return("LIMIT");
}
throw new InvalidOperationException();
}
public static bool UseTakeAtEnd(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Sqlite));
}
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 NeedsExecuteBlockStatement(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool IsCaseSensitive(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool CanUseOffsetFetch(this SqlDialect dialect)
{
return((dialect.HasFlag(SqlDialect.MsSql) && dialect >= SqlDialect.MsSql2012) ||
dialect.HasFlag(SqlDialect.Sqlite));
}
public static bool CanUseRowNumber(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql) && dialect >= SqlDialect.MsSql2005);
}
public static bool MultipleResultsets(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql));
}
public static bool CanUseSkipKeyword(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.Firebird));
}
public static bool UseScopeIdentity(this SqlDialect dialect)
{
return(dialect.HasFlag(SqlDialect.MsSql) || dialect.HasFlag(SqlDialect.Sqlite));
}
