public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!method.Equals(MethodInfo)) { return(null); } var patternExpression = _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]); var endsWithExpression = _fbSqlExpressionFactory.Equal( _fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.Function( "RIGHT", new[] { instance, _fbSqlExpressionFactory.Function( "CHAR_LENGTH", new[] { patternExpression }, true, new[] { true }, typeof(int)) }, true, new[] { true, true }, instance.Type)), patternExpression); return(patternExpression is SqlConstantExpression sqlConstantExpression ? (string)sqlConstantExpression.Value == string.Empty ? (SqlExpression)_fbSqlExpressionFactory.Constant(true) : endsWithExpression : _fbSqlExpressionFactory.OrElse( endsWithExpression, _fbSqlExpressionFactory.Equal( patternExpression, _fbSqlExpressionFactory.Constant(string.Empty)))); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (SupportedMethodTranslations.TryGetValue(method, out var sqlFunctionName)) { return(_fbSqlExpressionFactory.Function(sqlFunctionName, arguments, true, arguments.Select(_ => true), method.ReturnType)); } if (TruncateMethodInfos.Contains(method)) { return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.Function( "TRUNC", new[] { _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.Constant(0) }, true, new[] { true, false }, method.ReturnType))); } if (RoundMethodInfos.Contains(method)) { var roundArguments = arguments.Count == 1 ? new[] { _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.Constant(0) } : new[] { _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[1]) }; var nullability = arguments.Count == 1 ? new[] { true, false } : new[] { true, true }; return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.Function( "ROUND", roundArguments, true, nullability, method.ReturnType))); } return(null); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!SupportedMethods.Contains(method)) { return(null); } return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping( _fbSqlExpressionFactory.Convert(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), method.ReturnType))); }
public SqlExpression Translate(SqlExpression instance, MemberInfo member, Type returnType, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (member.DeclaringType == typeof(DateTime) && member.Name == nameof(DateTime.Now)) { return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.NiladicFunction("LOCALTIMESTAMP", false, typeof(DateTime)))); } if (member.DeclaringType == typeof(DateTime) && member.Name == nameof(DateTime.Today)) { return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.NiladicFunction("CURRENT_DATE", false, typeof(DateTime)))); } return(null); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!method.Equals(MethodInfo)) { return(null); } var patternExpression = _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]); var positionExpression = _fbSqlExpressionFactory.GreaterThan( _fbSqlExpressionFactory.Function( "POSITION", new[] { patternExpression, instance }, true, new[] { true, true }, typeof(int)), _fbSqlExpressionFactory.Constant(0)); return(patternExpression is SqlConstantExpression sqlConstantExpression ? ((string)sqlConstantExpression.Value)?.Length == 0 ? (SqlExpression)_fbSqlExpressionFactory.Constant(true) : positionExpression : _fbSqlExpressionFactory.OrElse( positionExpression, _fbSqlExpressionFactory.Equal( patternExpression, _fbSqlExpressionFactory.Constant(string.Empty)))); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (method.DeclaringType == typeof(string) && method.Name == nameof(string.IndexOf)) { var args = new List <SqlExpression>(); args.Add(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0])); args.Add(instance); foreach (var a in arguments.Skip(1)) { args.Add(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(a)); } return(_fbSqlExpressionFactory.Subtract( _fbSqlExpressionFactory.Function("POSITION", args, true, Enumerable.Repeat(true, args.Count), typeof(int)), _fbSqlExpressionFactory.Constant(1))); } return(null); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!method.Equals(ReplaceMethod)) { return(null); } var args = new List <SqlExpression>(); args.Add(instance); foreach (var a in arguments) { args.Add(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(a)); } return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping( _fbSqlExpressionFactory.Function("REPLACE", args, true, Enumerable.Repeat(true, args.Count), instance.Type))); }
bool TryGetTrimDefinition(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, out IEnumerable <SqlExpression> trimArguments, out IEnumerable <bool> nullability) { if (method.Equals(TrimWithoutArgsMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("BOTH"), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, false, true }; return(true); } if (method.Equals(TrimWithCharArgMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("BOTH"), _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, true, false, true }; return(true); } if (method.Equals(TrimEndWithoutArgsMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("TRAILING"), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, false, true }; return(true); } if (method.Equals(TrimEndWithCharArgMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("TRAILING"), _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, true, false, true }; return(true); } if (method.Equals(TrimStartWithoutArgsMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("LEADING"), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, false, true }; return(true); } if (method.Equals(TrimStartWithCharArgMethod)) { trimArguments = new[] { _fbSqlExpressionFactory.Fragment("LEADING"), _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), _fbSqlExpressionFactory.Fragment("FROM"), instance }; nullability = new[] { false, true, false, true }; return(true); } trimArguments = default; nullability = default; return(false); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList<SqlExpression> arguments, IDiagnosticsLogger<DbLoggerCategory.Query> logger) { if (!method.Equals(MethodInfo)) return null; var argument = _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]); return _fbSqlExpressionFactory.Function( "RIGHT", new[] { argument, _fbSqlExpressionFactory.Constant(1) }, true, new[] { true, false }, typeof(string)); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!MethodInfoDatePartMapping.TryGetValue(method, out var part)) { return(null); } return(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.Function( "DATEADD", new[] { _fbSqlExpressionFactory.Fragment(part), _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]), instance }, true, new[] { false, true, true }, instance.Type))); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!(method.Equals(SubstringOnlyStartMethod) || method.Equals(SubstringStartAndLengthMethod))) { return(null); } var fromExpression = _fbSqlExpressionFactory.ApplyDefaultTypeMapping(_fbSqlExpressionFactory.Add(arguments[0], _fbSqlExpressionFactory.Constant(1))); var forExpression = arguments.Count == 2 ? _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[1]) : null; var substringArguments = forExpression != null ? new[] { instance, _fbSqlExpressionFactory.Fragment("FROM"), fromExpression, _fbSqlExpressionFactory.Fragment("FOR"), forExpression } : new[] { instance, _fbSqlExpressionFactory.Fragment("FROM"), fromExpression }; var nullability = forExpression != null ? new[] { true, false, true, false, true } : new[] { true, false, true }; return(_fbSqlExpressionFactory.SpacedFunction( "SUBSTRING", substringArguments, true, nullability, typeof(string))); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (!method.Equals(IsNullOrWhiteSpaceMethod)) { return(null); } var argument = _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]); return(_fbSqlExpressionFactory.OrElse( _fbSqlExpressionFactory.IsNull(argument), _fbSqlExpressionFactory.Equal( _fbSqlExpressionFactory.Function("TRIM", new[] { argument }, true, new[] { true }, typeof(string)), _fbSqlExpressionFactory.Constant(string.Empty)) )); }
public SqlExpression Translate(SqlExpression instance, MethodInfo method, IReadOnlyList <SqlExpression> arguments, IDiagnosticsLogger <DbLoggerCategory.Query> logger) { if (method.IsGenericMethod && method.GetGenericMethodDefinition().Equals(EnumerableMethods.Contains) && arguments[0].Type == typeof(byte[])) { var value = arguments[1] is SqlConstantExpression constantValue ? _fbSqlExpressionFactory.Function("ASCII_CHAR", new[] { _fbSqlExpressionFactory.Constant((byte)constantValue.Value) }, false, new[] { false }, typeof(string)) : _fbSqlExpressionFactory.Function("ASCII_CHAR", new[] { _fbSqlExpressionFactory.Convert(_fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[1]), typeof(byte)) }, true, new[] { true }, typeof(string)); return(_fbSqlExpressionFactory.GreaterThan( _fbSqlExpressionFactory.Function( "POSITION", new[] { value, _fbSqlExpressionFactory.ApplyDefaultTypeMapping(arguments[0]) }, true, new[] { true, true }, typeof(int)), _fbSqlExpressionFactory.Constant(0))); } return(null); }