Server-SqlBuilder

using Korzh.EasyQuery.Db;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace KorzhSqlBuilder
{
    public class SqlBuilder
    {
        public static string BuildSql()
        {
            var modelFile = "MyModel.json";
            var queryFile = "MyQuery.json";
            var path = @"C:\Sources\POC\EasyQueryRuleEditor\KorzhSqlBuilder\TestFiles\";

            var modelJson = File.ReadAllText(path + modelFile);
            var queryJson = File.ReadAllText(path + queryFile);

            var dataModel = new DbModel();
            dataModel.LoadFromJsonString(modelJson);
            var query = new DbQuery(dataModel);
            query.LoadFromJsonString(queryJson);
            SqlQueryBuilder builder = new SqlQueryBuilder(query);
            builder.Formats.SetDefaultFormats(FormatType.MsSqlServer);
            builder.BuildSQL();
            var sqlResult = builder.Result.SQL;
            return sqlResult;
        }
    }
}