C# (CSharp) Atom.Generation.Generators.Sql.Projections QuerySqlGenerator Examples

Example #1

File: CustomQueryStoredProcedureGenerator.cs Project: jakeswenson/Atom

        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

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