Posts

Workflow Engine - A Robust Capability to Provide Dynamic Workflow in the Application

Image
Workflow Engine is a component that adds workflow functionality to your application. It can be fully integrated with the application, or be implemented as a specific stand-alone service (such as a web service). The benefits of using Workflow Engine: - Code-free process scheme design in a web-browser (HTML5). - High performance. - Add a custom workflow to your project. As easy as a pie. - Auto-generate incoming list. - Change the scheme process in real-time. - Database providers: MS SQL Server, MongoDB, RavenDB, Oracle, MySQL, PostgreSQL, Redis, Apache Ignite/GridGain. Workflow Engine is perfect for: - Document approval system. - Adding workflow to your application with minimal changes to the code. - The process of challenging and / or frequent requirement changes. - In case some modules or applications need to change the documents' status. Workflow Engine comes with two flavors. 1. Workflow Engine.NET - 2.Workflow Server 1.WorkflowEngine.NET

The serve command requires to be run in an Angular project, but a project definition could not be found.

Error Message "The serve command requires to be run in an Angular project, but a project definition could not be found" Prompt in nodejs command prompt when we try to execute the C:\>ng serve on non Angular project directory. It means that you need to go inside the Angular project directory and once you are inside the Angular Project directory then type this command. C:\AngularProject>ng serve.

Why Generated SQL Scripts from SQL SERVER 2017 is not compatible with SQL SERVER 2014

Image
There are couple of cases might be possible for this issue.One of the approach to overcome from this issue is ,Too generate script using SQL SERVER >Task>Generate Script... Wizard and selection of correct target database. If you are generating script from SQL SERVER 2017 which to be compatible with SQL SERVER 2014 then make sure that in Advanced Scripting Options for Script for Server Version SQL SERVER 2014 by default it sets SQL SERVER 2017. Images of Script for Server Version in SQL SERVER 2014 and 2017 Script file generated for Script for Server Version 2014 and Script for Server Version 2017

Benefits of keeping all SQL Server database objects inside Visual Studio Solution

Image
Benefits:- # Easy stored procedure debugging. # Each database object (table,view,function,type,stored procedure) treat as an individual file. # On Single click get change history of any database object. # This approach is considered best practice for database development and distribution using CI/CD as it generates *.dll,*.dacpac,*.sql). # Direct deployment of updated objects on any SQL SERVER target platform including Azure. # Single IDE(Integrated development environment) database application development using .NET and SQL Server. # Version control of each database object(table,view,function,type,stored procedure).

Transform your hand-drawn wireframes into digital design files and front-end code(HTML,CSS,XAML) – automatically by using UIZARD

Transform your hand-drawn wireframes into digital design files and front-end code(HTML,CSS,XAML) – automatically by using UIZARD Youtube :- https://youtu.be/05uu4fppjmU Source :- https://uizard.io/

DMA - A safe way to migrate SQL Server database objects

Image
SQL Server database objects migration was not so easy earlier as of now with the help of DMA(Data Migration Assistant). The Data Migration Assistant (DMA) which is a free tool from Microsoft. DMA helps us to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. The DMA assessment workflow detects Migration blocking issues,Partially supported or unsupported features,compatibility issues (Breaking changes,Behavior changes,Deprecated features) and suggests feature recommendations(Performance,Security,Storage). References :- https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017 https://channel9.msdn.com/Shows/Data-Exposed/First-Look-at-the-new-SQ

Silent Installation Implementation in ClickOnce Application

Image
What is Silent Installation? A silent install is the installation of a software program that requires no user interaction. It is a convenient way to streamline the installation process of a desktop application. In a non-silent or "attended installation," the user is prompted to select or confirm these options during the installation process. In a silent install, these items are selected automatically and the installer runs from start to finish without requiring any user input. How to create a custom installer that silently installs a ClickOnce application In your ClickOnce application, add references to System.Deployment and System.Windows.Forms.  Add a new class to your application and specify any name. This walkthrough uses the name MyInstaller.  Add the following Imports or using statements to the top of your new class.  Add the following(see the attached images of MyInstaller.cs) methods to your class. MyInstaller -1 MyInstaller -2 EventVi