public bool UpdateTableOnlyChanged(string[] sColNames, string[] sValues)
{
Dictionary <string, string> SetPairs = new Dictionary <string, string>();
int nCounter = 0;
foreach (var colName in sColNames)
{
SetPairs.Add(colName, sValues[nCounter]);
nCounter++;
}
UpdateTables update = new UpdateTables(_dbConn, SetPairs);
return(update.PerformUpdate());
}
public bool UpdateTable(string sAndWhere = null)
{
Dictionary <string, string> SetPairs = new Dictionary <string, string>();
foreach (var colName in _ColumnNames)
{
SetPairs.Add(colName, GetValue(colName));
}
UpdateTables update = new UpdateTables(_dbConn, SetPairs);
if (!string.IsNullOrEmpty(sAndWhere))
{
update.AddAndWhere(sAndWhere);
}
return(update.PerformUpdate());
}
public bool UpdateTable(Dictionary <string, string> SetPairs)
{
UpdateTables update = new UpdateTables(_dbConn, SetPairs);
return(update.PerformUpdate());
}