public void Test()
{
Database db = DatabaseFactory.Create("LocalSQL");
DataSet dataset = db.ExecuteDataSet("SELECT * FROM Shippers");
DbTraceHelper.TraceData(dataset);
}
public void TestSQLReturnMultiDataTables()
{
string sql = "SELECT * FROM Region; SELECT * FROM Shippers";
string[] tableName = new string[] { "Region", "Shipper" };
DataSet result = SqlDbHelper.ExecuteDataSet(sql, tableName);
DbTraceHelper.TraceData(result);
}
public void TestParameterizedSQLReturnMultiDataTables()
{
string sql = "SELECT * FROM Region WHERE RegionID = @RegionID;";
sql += "SELECT * FROM Shippers WHERE ShipperID = @ShipperID;";
string[] tableName = new string[] { "Region", "Shipper" };
SqlParameter regionID = new SqlParameter("@RegionID", 1);
SqlParameter shipperID = new SqlParameter("@ShipperID", 2);
DataSet result = SqlDbHelper.ExecuteDataSet(sql, tableName, regionID, shipperID);
DbTraceHelper.TraceData(result);
}
public void Test()
{
DataSet result = DbHelper.ExecuteDataSet("LocalSQL", "SELECT * FROM Shippers");
DbTraceHelper.TraceData(result);
}
