sdmap test(LINQPad).linq

sdmap test.linq

<Query Kind="Statements">
  <Reference>&lt;RuntimeDirectory&gt;\System.Configuration.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Data.Services.Client.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Data.Services.Design.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Design.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Runtime.Serialization.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.ServiceModel.Activation.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.ServiceModel.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Web.ApplicationServices.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Web.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Web.Extensions.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Web.Services.dll</Reference>
  <Reference>&lt;RuntimeDirectory&gt;\System.Windows.Forms.dll</Reference>
  <NuGetReference>sdmap.ext</NuGetReference>
  <Namespace>LINQPad.Controls</Namespace>
  <Namespace>sdmap.ext</Namespace>
  <Namespace>sdmap.Functional</Namespace>
  <Namespace>System.Web.Script.Serialization</Namespace>
</Query>

var sdmapFolderTextbox = new TextBox(@"C:\Users\flysha.zhou\Desktop\sdmap-folder");
var confirmFolderButton = new Button("Confirm");
var statusContainer = new DumpContainer();
Util.HorizontalRun(true, sdmapFolderTextbox, confirmFolderButton, statusContainer).Dump("sdmap folder: ");

var sdmapIdTextbox = new TextBox("Chat.GetRecentSession");
var queryObjectBox = new TextArea("{QueryObject: 'here'}");
var idConfirmButton = new Button("Generate SQL") { Visible = false};
var sdmapIdContainer = new DumpContainer().Dump("sdmap Id: ");
sdmapIdContainer.Content = Util.HorizontalRun(true, sdmapIdTextbox, queryObjectBox, idConfirmButton);
var sqlContainer = new DumpContainer();
var queryObjectInfoBox = new DumpContainer();
Util.HorizontalRun(true, sqlContainer, queryObjectInfoBox).Dump("Generated SQL: ");
ISdmapEmiter emiter = null;

confirmFolderButton.Click += (o, e) => 
{
	var sw = Stopwatch.StartNew();
	emiter = FileSystemSqlEmiter.FromSqlDirectoryAndWatch(sdmapFolderTextbox.Text, true);
	statusContainer.Content = $"Compile successfully in {sw.Elapsed.TotalMilliseconds:F2}ms.";
	idConfirmButton.Visible = true;
};

idConfirmButton.Click += (o, e) => 
{
	if (emiter == null) statusContainer.Content = "Please compile the sdmap folder!";
	var queryObject = new JavaScriptSerializer().DeserializeObject(queryObjectBox.Text);

	try
	{
		queryObjectInfoBox.Content = queryObject;
		var sw = Stopwatch.StartNew();
		string sql = emiter.Emit(sdmapIdTextbox.Text, queryObject);
		sqlContainer.Content = sql;
		sw.Stop();
		statusContainer.Content = $"Generate successfully in {sw.Elapsed.TotalMilliseconds:F2}ms.";		
	}
	catch (ResultFailedException ex)
	{
		statusContainer.Content = ex;
	}	
};