Beispiel #1
0
        protected override string[] GetStatements(Values <string> _)
        {
            if (entries.Count > 0)
            {
                if (entries.Count == 1)
                {
                    var ek = entries.Keys.ToArray();
                    var ev = entries.Values.ToArray();

                    var entry = new SqlUpdateEntry(Database, Table);

                    entry.WhereCondition = (SqlColumn)WhereColumn == ek[0];

                    foreach ((string evk, object evo) in ev[0].Update.Sets)
                    {
                        entry.Set(evk, evo);
                    }

                    return(Database.Connection.Update(entry.Array(), OutputResult));
                }
                else
                {
                    return(Database.Connection.UpdateTable(Table, WhereColumn, entries.Keys.ToArray(), entries.Values.ToArray(), OutputResult));
                }
            }
            else
            {
                return(null);
            }
        }
Beispiel #2
0
 public SqlUpdateEntry Update(string table)
 {
     if (table != null)
     {
         var entry = new SqlUpdateEntry(Database, table);
         entries.Add(entry);
         return(entry);
     }
     else
     {
         throw new ArgumentNullException();
     }
 }