public bool TryBuild(ISqlTranslator translator, out string comparison) { comparison = ""; string val1 = _first(translator); string val2 = _second(translator); if (new[] { val1, val2, _operator }.Any(string.IsNullOrEmpty)) { return(false); } comparison = WrapWithParentheses($"{WrapWithParentheses(val1)} {_operator} {WrapWithParentheses(val2)}"); return(true); }
public bool TryBuild(ISqlTranslator translator, out string comparison) { comparison = string.Empty; if ( !_first(translator, out string str1) || !_second(translator, out string str2) || string.IsNullOrEmpty(_operator)) { return(false); } comparison = WrapWithParentheses($"{WrapWithParentheses(str1)} {_operator} {WrapWithParentheses(str2)}"); return(true); }
public bool TryBuild(ISqlTranslator translator, out string selectClause) { selectClause = ""; if (translator.HasError) { return(false); } selectClause = CreateClause(translator); if (string.IsNullOrEmpty(selectClause)) { return(false); } return(true); }
public bool TryBuild(ISqlTranslator translator, out string whereClause) { whereClause = string.Empty; if (translator.HasError) { return(false); } whereClause = _whereExpression(translator); if (string.IsNullOrEmpty(whereClause)) { return(false); } return(true); }
protected abstract string CreateClause(ISqlTranslator translator);
protected override string CreateClause(ISqlTranslator translator) => CreateClause(_selectExpression(translator));
public SelectQueryBuilder(ISqlTranslator translator, Func <IWhereBuilderFactory> createWhereBuilderFactory, Func <ICompare> compareFactory) { this._translator = translator; this._createWhereBuilderFactory = createWhereBuilderFactory; this._compareFactory = compareFactory; }
public InsertQueryBuilder(ISqlTranslator translator) { _translator = translator; }
public UpdateQueryBuilder(ISqlTranslator translator, Func <IWhereBuilderFactory> createWhereBuilderFactory, Func <ICompare> compareFactory) { _translator = translator; _createWhereBuilderFactory = createWhereBuilderFactory; _compareFactory = compareFactory; }
public SqlRepository(IConfiguration config, ISqlTranslator <TData> sqlTranslator, IMethodLookup methodLookup) { _connectionString = config.GetConnectionString("DefaultConnection"); _sqlTranslator = sqlTranslator; _sqlMethodLookup = methodLookup; }