Esempio n. 1
0
        public ISetClauseSyntax Columns(params string[] names)
        {
            ISetClauseSyntax ret = null;

            foreach (var name in names)
            {
                if (ret == null)
                {
                    ret = new UpdateColumnSyntax(this, name, Delimiter.Comma);
                }
                else
                {
                    ret = new UpdateColumnSyntax(ret as SyntaxBase, name, Delimiter.Comma);
                }
            }
            return(ret);
        }
        public IValueExpressionSyntax KeyEqualToValue(Dictionary <string, object> columnValues)
        {
            IValueExpressionSyntax ret = null;

            foreach (var columnValue in columnValues)
            {
                if (ret == null)
                {
                    var column = new UpdateColumnSyntax(this, columnValue.Key, Delimiter.Comma);
                    ret = new SubstituteSyntax(column, columnValue.Value);
                }
                else
                {
                    var column = new UpdateColumnSyntax(ret as SyntaxBase, columnValue.Key, Delimiter.Comma);
                    ret = new SubstituteSyntax(column, columnValue.Value);
                }
            }
            return(ret);
        }
Esempio n. 3
0
        public IValueExpressionSyntax KeyEqualToValue(Dictionary <string, object> columnValues)
        {
            IValueExpressionSyntax ret = null;

            foreach (var columnValue in columnValues)
            {
                if (ret == null)
                {
                    var column  = new UpdateColumnSyntax(this, columnValue.Key, Delimiter.Comma);
                    var equalTo = new EqualToSyntax <IValueExpressionSyntax>(column);
                    ret = new ParameterizedValueExpressionSyntax(equalTo, columnValue.Value);
                }
                else
                {
                    var column  = new UpdateColumnSyntax(ret as SyntaxBase, columnValue.Key, Delimiter.Comma);
                    var equalTo = new EqualToSyntax <IValueExpressionSyntax>(column);
                    ret = new ParameterizedValueExpressionSyntax(equalTo, columnValue.Value);
                }
            }
            return(ret);
        }