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); }