protected IDbCommand InsertarSqlBuildQuery(string tabla, Dictionary <string, object> myDic, OleDbCommand oleDbCommand) { var oSqlBuildQuery = SqlBuildQuery.InsertInto(tabla, oleDbCommand); foreach (KeyValuePair <string, object> item in myDic) { oSqlBuildQuery.Campo <Object>(item.Key, item.Value); } return(oSqlBuildQuery.ToDbCommand()); }
protected IDbCommand ActualizarSqlBuildQuery(string tabla, Dictionary <string, object> myDic, OleDbCommand oleDbCommand) { var oSqlBuildQuery = SqlBuildQuery.Update(tabla, oleDbCommand); foreach (KeyValuePair <string, object> item in myDic) { oSqlBuildQuery.Campo <Object>(item.Key, item.Value); } oSqlBuildQuery.Where <string>(this.ClavePrimaria, this.ValorClavePrimaria.ToString()); return(oSqlBuildQuery.ToDbCommand()); }