GetUpdateSql() public méthode

public GetUpdateSql ( string table, string columns, object values ) : string
table string
columns string
values object
Résultat string
Dialect Class Documentation
Exemple #1
0
        public virtual int UpdateSql(string table, string[] columns, object[] values, Filter filter)
        {
            if (values == null)
            {
                values = new object[columns.Length];
            }
            string sql = Dialect.GetUpdateSql(table, columns, values);

            In[] parameters = Dialect.ConvertToNamedParameters(values);
            if (filter != null)
            {
                string   whereSql         = Dialect.GetWhereSql(filter, parameters.Count());
                object[] pars             = filter.GetAllValueParameters();
                In[]     filterParameters = Dialect.ConvertToNamedParameters(parameters.Count(), pars);
                filterParameters = filterParameters.Where(x => x.Value != null && x.Value != DBNull.Value).ToArray();
                parameters       = parameters.Concat(filterParameters).ToArray();
                sql = sql + " " + whereSql;
            }

            return(Database.ExecuteSql(sql, parameters));
        }