public void BuildSelectTablesTest()
{
string sql = _provider.BuildSelectTables(null);
string expectSql = "SELECT NAME FROM SYSOBJECTS WHERE XTYPE='U'";
sql.ShouldBe(expectSql);
}
public void BuildSelectTablesTest()
{
string dbName = "userdb";
string sql = _provider.BuildSelectTables(dbName);
string expectSql = string.Format("SELECT `TABLE_NAME` FROM information_schema.`TABLES` WHERE `TABLE_SCHEMA`='{0}'", dbName);
sql.ShouldBe(expectSql);
}
public void BuildSelectTablesTest()
{
string dbName = "alluser";
string sql = _provider.BuildSelectTables(dbName);
string expectSql = string.Format("SELECT name FROM {0}..sysobjects WHERE type='U'", dbName);
sql.ShouldBe(expectSql);
}
