public void MsExecuteQueryTest() { var sqlhelper = new Initializer(); Connector databaseConnector = new MsSqlConnector(GetConnectionString("cnniLiumDatabaseTest")); var dt = (System.Data.DataTable)sqlhelper.ExecuteQuery("SELECT TOP 2 * FROM Users ", databaseConnector); Assert.IsNotNull(dt); Assert.AreEqual(2, dt.Rows.Count); }
public void MySqlExecuteQueryTest() { var sqlhelper = new Initializer(); Connector mySqlConnector = new MySqlConnector("Server=127.0.0.1;Database=dboptimove;Uid=astro;Pwd=1qazxc;Allow Zero Datetime=False;Convert Zero Datetime=True"); var dt = (System.Data.DataTable)sqlhelper.ExecuteQuery("SELECT * FROM promotions;", mySqlConnector); Assert.IsNotNull(dt); //Assert.AreEqual(2, dt.Rows.Count); }