Konigi Inc - Data Automation and Migration Tools for Microsoft .Net, SQL Server and Cobol Environments

Site updated 2/18/2024

Konigi - Making IT Known

Skip Navigation Links

	DAL_GEN
	8/14/2022 A very HOT New England Summer Updated generator to include Url ReWrite to support extensionless Urls for Rest and Soap services Implemented generation of HTTP and/or HTTPS for Rest and Soap services Provide optional Address naming for Web Services opposed to nameless interfaces Streamlined the generation and cleanup of Web.Config to minimize orphan and stub references in Binding, Services, Behaviors
	8/15/2021 New England Summers Implemented exposing Foreign Keys via REST/SOAP to support selecting existing FK Records - Option to select the FK Column values or the FK Table row Updated the selection hierarchy to include subordinate elements for builds for Tables and Foreign Keys - ensures logical builds include parent-child elements
	8/12/2021 The Dog Days of Summer Updated MySQL, Oracle and SQL Server capability to support custom stored procedures - corrected data-types and return values Enahnced Bubble-up of class object errors via Web Service endpoints - added fields to all tables for error values Implemented automated selection loading of the last prior builds for Tables, Stored Procedures and Views Converted all utilization of XML_Document to XDocument for config file handling Improved target solution file updates and build functionality to enhance deployment performance Continuing to develop/migrate DAL_GEN to support .Net CORE
	2/4 The New Year first updates, Happy Valentines Day Enhanced MySQL, SQL Server, and Oracle scripts to Bubble-up Stored Procedure errors via Web Service endpoints Provided option to Bubble-up class object errors via Web Service endpoints Expanded returing RowCount for Insert, Update, Delete SP routines for MySQL, Oracle and SQL Server Expanded SP transaction control to MySQL and enhanced SQL and Oracle functionality Improved processing by streamlining and coalescing code generation and scripting routines Continuing to develop/migrate DAL_GEN to support .Net CORE
	12/26 The Holidays 2020 (New Features) Implemented MySQL as part of the core Databases Supported Finalizing testing of MySQL against Datatypes, objects, interfaces and services Enhanced processing to accomodate adding new projects to existing solutions Re-designing the architecture of DAL_GEN to support Solution and Project based implementations Planning for DAL_GEN to fully create, enhance and deploy VS Solutions with multiple sub-projects Planning for DAL_GEN to support .Net CORE
	10/15/2020 (New Features and Fixes) Enhancing to support multi project solutions to accomodate micro services, large database segmentation Updating the environment to implement OAuth for credential capabilities for SOAP and REST services Implementing BSON for REST services to handle Binary elements (images, video/audio, objects, etc) Analyzing generated coding framework to minimize repetitive code/calls for DB access and formatting of objects
	6/20/2020 (New Features and Fixes) Provided options for SQL & PL/SQL queries to use either EQUAL (=) or LIKE statements to support wildcard queries Updated Class Object code to consolidate functions Eliminated repetitve calls; improved performance on loading Projects Enhanced PL/SQL Stored Procedure generation and Class Object calls Updated Swagger4WCF to correct inconsistencies with REST Path and Query element definition
	5/2/2020 (New Features and Fixes) Automated updating Project ".proj" file for add/removing elements for Content and Compiling attributes Implemented removal of Project flies to eliminate orphan files based on option changes Improved load/build cycle times
	4/22/2020 (New Features and Fixes) Completed Oracle Testing for CRUD and Index RUD functionality; 100% Operational Tested DAL_GEN to Build/Deploy to Azure for IIS Web Site and Azure SQL DB; 100% Operational (Data as a Service....) Enhanced return of RowCounts for Oracle and SQL for Updates and Inserts (Optionally Selectable) Added KPIs for GEN runtimes Improved Cleanup of Projects (Projects, Configurations, Builds) Locked Projects to a Connection to prevent generation of orphan Builds
	4/10/2020 (New Features and Fixes) Initiated integration for Oracled 19c for DAL Code Generation Mapped Oracle DataTypes to .Net Framework Templated CRUD Stored Procedure Script Generation routines Enhanced Class and Web Service/Interface code generation for multi Database capability (1 per Project) Automated Project creation based on existing VS .Proj, and .Sln files
	3/28/2020 (New Features and Fixes) Updated Generation routine to optionally Build the Target Project and/or Publish to a DEV or TEST site Designed framework to support multiple site publishing to support large web farms and/or DR/BCP sites Initiated application level logging to support Trace and error logging to support issues Provided integration with MSBuild and Application Publishing Profiles using FTP, FileSystem, or WebDeploy Configured tracking of changes to allow for detailed build/configurations
	3/25/2020 (New Features and Fixes) Updated profiles to support DEV and TEST builds for Web URL's to minimize manual changes to Web.Config and SOAP/REST Interface code Enhanced builds for selective Overwrite/Comment of Services and ConnectionString uniquely for DEV/TEST builds Corrected SWAGGERWCF integration for Web.config and Global.asax to provide proper help pages Modified NUGET SWAGGER4WCF source to eliminate Duplicate Objects for YAML generation Streamlined updates to Web.Config elements via routines (Services, Behaviors, Connections, Bindings) Added SQL/VB datatype handling for smallmoney, datatime2, and byte()
	3/17/2020 (New Features and Fixes) Implemented validation for SQL and VB Reserved Keywords used in SQL Data Columns; Violations will prevent Table, View and Stored Procedure processing by DAL_GEN Generated Error Listing for Reserved Keywords by Table and Column Initiated tracking and validation for Customer Generated Stored Procedures that implement Reserved Keywords as Parameters or Results Initiated tracking and validation for Views that implemented Reserved Keywords Generated REST AND SOAP Web Services against Microsofts AdventureWorks 2016 database as a Demo of DAL_GEN's Capabilities Happy St. Patricks Day
	3/15/2020 (New Features and Fixes) Updated Global.asax elements for auto-restart Updated Web.Config for AppInitialization (re-publishing resets doappInitAfterReset to False; embedded into Web.Config to remain True Changed SOAP Service to only siginify OperationContract omitting the REST webget reference (no impact) Steamlined build and status processes to improve code generation efficiency Corrected Project/Build purge and deletion routines to ensure all build xml files and Application entries were removed; prevents orphan records Converted many of the Panels, Buttons, Groupboxes and TabControls to rounded format Improved Build handling for new projects to use Project Target Path opposed to querying for file locations for each generated element Reordered Table Grid columns to follow Stored Procedure (CRUD & Index), and VB (CRUD and Index) dependencies for selection
	2/28/2020 (New Features and Fixes) Implemented generation of IIS applicationInitialization elements for Web.Config and Global.asax; triggers App_Pool restart Provided generation of a Global.asax file (this is not added as part of default WCF solutions, useful for applicationInitialization) Generate an optional IIS Application Start HTML file for IIS applicationInitialization notification Changed code to implement XDocument opposed to XML_Document; Supports LINQ, IEnumerable, and improves performance Initiated Transaction Logging for builds to record user selections, control settings and configurations to aid in support issues
	2/24/2020 (New Features and Fixes) Provided user-selectable build for REST and/or SOAP Service/Interfaces by Table, View, or Stored Procedure Enhanced Build and Configuration Auto-Save to restore selections for Table, View and Custom Stored Procedures Updated Build Restore to include new Tables, Views and Stored Procedures (was previously overwriting the Gridviews) Included object Disposal and Garbage Collection functions for all routines to reduce overhead and improve performance Updated Class elements code generation to coincide with REST and SOAP selections (was previously building Interface and Services for all Tables, Views and Stored Procedures) Corrected generated code indentation and formatting
	2/13/2020 (New Features and Fixes) Updated configuration version control and build history generation to provide selecting/sorting configurations and prior builds Improved build performance Containerized database calls to minimize DB round-trip queries for updating grids, tables and lists; updates provided significant performance enhancements for selecting, querying, sorting, filtering and resetting grids Updated Options Panel to implement Tab Controls to reduce navigation issues and to segment options Enhanced Table, View and Stored Procedure filtering using SQL like text (uses %) and provided options to included or exclude filters Redesigned the web.config configuration to validate prior parameters & elements and overwrite or comment-out if they exist Initiated Help Text for controls to assist users with their functionality and to identify constraints or special considerations Expanded functionality for exposing SQL Varbinary, Geometry, Geography, and XML Data types Provided generation of YAML, supporting service description and mapping (particularly useful for REST as WSDL is available for SOAP) Added IIS App Pool Initialization for Services; Useful for projects with a large number of functions as initial startup can take minutes Extended configuration tracking for performance metrics (Build Time, Last Build Date, Last Configuration Change Date, etc.)
	10/10/2019 (New Features) Testing Key & Index Associations via Stored Procedure Joins using a Designer/Builder allowing users to Associate Tables and Views based on Keys and Indexes (Generates Stored Procedures, Class objects, and REST/SOAP web services to compliment Tables and existing Custom Stored Procedure exposure) Enhanced Logging capabilities to support Governance and Tracking of data Implementing OpenAuth to support advanced security controls (SAML, SSO)
	9/25/2019 Fully tested framework for DAL_GEN to expose Customer Developed Stored Procedures and Views (SOAP, REST, DataTables, DataSet, XML, JSON) Tested new Error Handling Capabilities for the DAL and SQL Server Generated Stored Procedures Updated JSON Response to remove backslashes (double quotes) due to duplicate serizlization events Adding features to expose Error Handling results beyond the DAL to the Web Endpoints (optional)

	9/23/2019 Completed framework for DAL_GEN to expose Customer Developed Stored Procedures and Views Extended Error Handling Capabilities for the DAL and SQL Server Generated Stored Procedures Initiating full regression testing for all capabilites including Tables, Custom Stored Procedures, and Views Adding features to expose Error Handling results beyond the DAL to the Web Endpoints (optional)
	9/19/2019 Developing framework for DAL_GEN to expose Customer Developed Stored Procedures and Views Extending Error Handling Capabilities for the DAL and SQL Server Generated Stored Procedures Provided filtering for Stored Procedures and Views by Prefix and Suffix to allow for simplified selection for large numbers of Store Procedures and Views Expanded capability to Filter Table Names using SQL like wildcards simplifying selection criteria of tables for large databases Provided features for saving and reselecting prior builds enabling faster re-gen of artifacts Added retention of selected Options for ease of management and re-gen of artifacts
	9/6/2019 Designing DAL_GEN web - Phase II of DAL_GEN; supporting Azure sites for DAL_GEN code creation and datatable mapping Testing for all DAL_GEN Features (REST, SOAP, Stored Procedures, Cleanup, Auto-Saving, etc.
	9/4/2019 Updated DAL_GEN to support auto-saving build selections; useful for large databases where the selection needs to be retained to expediate rebuilds Added faster redraw methods for the Data Grid when "Selecting/De-Selecting ALL" records and for sorting by tablename Added features to support updating the target web.Config for Bindings, Services, Endpoints, ConnectionString, and Behaviors (REST & SOAP) Added Overwrite/Comment for existing web.Config entries Displays Build and Target Status for Code line counts (Services, Interfaces, Class) Web.config selected/updated Namespace Application names Project path Field Counts Table Counts
	8/19/2019 Data Access Layer Generator (DAL_GEN) development completed for Version 1.5 Updating Konigi website with reference material and demonstration pages DAL_GEN enables complete generation of a Data Access Layer supporting REST & SOAP with XML, JSON, Datatable and DataSet Responses.
	If you have Legacy Code, Forms, or Reports that must be converted, Contact Konigi Inc. !!!