public static void CreateNewTableSource(string tableName, string alias, string expected) { var name = ObjectName.Parse(tableName); var source = new SqlQueryExpressionSource(name, alias); Assert.True(source.IsTable); Assert.False(source.IsQuery); Assert.Equal(!String.IsNullOrWhiteSpace(alias), source.IsAliased); Assert.Equal(expected, source.ToString()); }
public static void CreateNewQuerySource() { var fromTable = ObjectName.Parse("table1"); var query = new SqlQueryExpression(); query.AllItems = true; query.From.Table(fromTable); var source = new SqlQueryExpressionSource(query, "a"); Assert.True(source.IsQuery); Assert.False(source.IsTable); Assert.True(source.IsAliased); Assert.Equal("a", source.Alias); Assert.True(source.Query.AllItems); var expected = new SqlStringBuilder(); expected.AppendLine("(SELECT *"); expected.Append(" FROM table1) AS a"); Assert.Equal(expected.ToString(), source.ToString()); }