public void TestSqlInsertCreater()
{
string expected = "INSERT INTO Test (field1,field2) VALUES (10,20)";
List <SqlFieldValuePair> fieldValuePairs = new List <SqlFieldValuePair>()
{
new SqlFieldValuePair(
new KeyValuePair <string, object>("field1", 10), SqlCompareOperator.Equal),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field2", 20), SqlCompareOperator.Equal),
};
string result = SqlCommandCreater.CreateInsertCommand("Test", fieldValuePairs);
Assert.AreEqual(expected, result);
}
private string CreateCommand()
{
var row = dataGridView_AddRow.Rows[0];
List <SqlFieldValuePair> pairs = new List <SqlFieldValuePair>();
foreach (DataGridViewColumn column in dataGridView_AddRow.Columns)
{
int index = column.Index;
if (row.Cells[index].Value != null)
{
pairs.Add(new SqlFieldValuePair(
new KeyValuePair <string, object>(column.Name, row.Cells[index]), SqlCompareOperator.Equal));
}
}
return(SqlCommandCreater.CreateInsertCommand(CurrentTable.Name, pairs));
}
