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