private void GenerateDesignTimeCode()
{
try
{
var json = DatabaseSelectionController.GetQueryResultsAsJson(SqlQuery.Value);
DesignTimeDataCode.Value = DesignTimeDataCodeTemplate.CreateCode(ClassName.Value, json, GeneratedCSharpText.Value);
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
public void ConvertSqlResultsToDesignTimeData()
{
{
var className = "Item";
var sqlQuery = "SELECT TOP 2 * FROM ITEM";
var conn = SqlConnectionProviders.PbsiCopy;
var results = conn.GetSqlConnection().Query(sqlQuery).ToList();
var json = JsonConvert.SerializeObject(results);
var classDeclaration = CSharpClassGeneratorFromAdoDataReader.GenerateClass(conn, sqlQuery, className);
var designTimeCode = DesignTimeDataCodeTemplate.CreateCode("Item", json, classDeclaration);
Console.WriteLine(designTimeCode);
}
}
