public void GetDataTableTestWithCondition()
{
DataConfiguration dataConfiguration = new DataConfiguration();
dataConfiguration.ReadConfiguration();
string query = @"SELECT a.nib FROM so_pos a
WHERE a.pos_d > {5/11/14}";
string query2 = @"SELECT a.nib, a.pac_born, a.pacfam, a.pacname, a.pacsurname, a.pac_sex,
a.pos_kno, a.out_kno, a.citycount, a.m_kres,
a.pos_t, a.pos_d, a.out_d, a.out_t, a.withmother
FROM so_otd b, so_pos a
WHERE a.nib = b.nib AND a.pos_d >= {4/1/14} AND a.out_d <= {1/11/15}";
var queryTable = sqlDataHelper.DoQuery(dataConfiguration.Path, query2);
Assert.IsTrue(queryTable.Rows.Count > 0);
Console.WriteLine("Count = {0}", queryTable.Rows.Count);
/* foreach (DataRow dataRow in queryTable.Rows)
* {
* foreach (var item in dataRow.ItemArray)
* {
* Console.WriteLine(item);
* }
* } */
}