internal ProjectionResult Generate()
        {
            var result = new ProjectionResult
            {
            };

            QueryPlanBuilder builder = new QueryPlanBuilder(Projection, _allAtoms);
            var plan = builder.Build();
            QuerySqlGenerator query = new QuerySqlGenerator(plan);

            query.Generate();
        }
Example #2
0
        private string GenerateSql(string viewName, QueryPlan queryPlan)
        {
            string query = new QuerySqlGenerator(queryPlan, 1).Generate();

            return($@"
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW [dbo].[{viewName}]
AS
	{query}

GO
");
        }