Jaykumar Prajapati jayprajapati857

Installing SQL Server 2008 from command line

Download SQL Server 2008 Express
If you want to know all the available Options and Switches which you can make use of this Installation, Run this command SQLEXPR_x64_ENU.exe /? in command propmp running as Administrator mode and navigating it to the Downloaded path of SQL Server exe.
After getting all the Options and Switches use them as per your requirements
In this Gist we are going to install only SQL Server 2008 DB Engine. You can also install the other tools from command line, such as SSAS, SSRS, SSIS and Tools(like SSMS).
The parameters I am going to set are:

Instance Name: SQL2008

Installing MySQL 5.7 Server with EntityFramework in Visual Studio 2017

Install MySQL Server 5.7.25
Install Complete MySQL Connector.Net 6.9.10
Install Complete MySQL Visual Studio Plugin 1.2.8
If after installing MySQL Visual Studio Plugin it shows warning that failed to execute comamnd devenv /updateconfiguration, then manually execute that command in Developer Command Prompt for Visual Studio 20xx with run as administrator.
Right Click References > Add > Click Assemblies or Extensions > Search MySQL > Tick all
Comment the following kind of similar code from Web.config

Remotely connect to IIS Web Server.

Whenever you want to perform any tasks related to IIS on server you might be starting mstsc aka Remote Desktop Connection RDP for those tasks, but using the facility of remotely managing IIS from client IIS, no need of RDP now and then.

Follow the simple steps on IIS Server and client IIS machine.

Process on Server IIS

Run the following commands in powershell on the remote IIS Server
Install-WindowsFeature Web-Server

Installing MySQL 8.0 Server with EntityFramework in Visual Studio 2019

Install MySQL Server 8.0.16
Install Complete MySQL Connector.Net x86 8.0.16
Install this custom repacked VSIX MySQL Visual Studio
If after installing MySQL Visual Studio Plugin it shows warning that failed to execute comamnd devenv /updateconfiguration, then manually execute that command in Developer Command Prompt for Visual Studio 20xx with run as administrator.
Run this command Install-Package EntityFramework in Visual Studio Nuget package manager console
Manage Nuget Packages > Search Mysql > install Mysql.Data v8.0.16
Manage Nuget Packages > Search Mysql > install Mysql.Data.Entity v6.10.8
Manage Nuget Packages > Search Mysql.Data.EntityFramework > install Mysql.Data.EntityFramework v8.0.16

Visual Studio Must have Extensions

Hello World! Every programmer loves IDE and auto-complete inetllisense facilities in IDE's and editor tools. But, any of the program doesn't suit to everyone's need, and thier comes the existence of extensions. Here I am listing out some of the very usefull extensions, that every Visual Studio user must have.

Hit Star if you liked this.

Just search the title in extensions marketplace.

	import { BrowserModule } from '@angular/platform-browser';
	import { NgxUploaderDirectiveModule } from 'ngx-uploader-directive';

	@NgModule({
	declarations: [
	AppComponent
	],
	imports: [
	BrowserModule,
	NgxUploaderDirectiveModule

	import { BrowserModule } from '@angular/platform-browser';
	import { NgModule } from '@angular/core';
	import { FormsModule } from '@angular/forms';
	import { NgxUploaderDirectiveModule } from 'ngx-uploader-directive';

	import { AppRoutingModule } from './app-routing.module';
	import { AppComponent } from './app.component';

	@NgModule({
	declarations: [

	<div class="drop-container" ngxFileDrop [options]="options" (uploadOutput)="onUploadOutput($event)"
	[uploadInput]="uploadInput" [ngClass]="{ 'is-drop-over': dragOver }">
	<h1>Drag & Drop</h1>
	</div>

	<label class="upload-button">
	<input type="file" ngxFileSelect [options]="options" (uploadOutput)="onUploadOutput($event)"
	[uploadInput]="uploadInput" multiple>
	or choose file(s)
	</label>

	// tslint:disable: max-line-length
	import { Component, EventEmitter } from '@angular/core';
	import { IUploadOptions, ISelectedFile, IUploadInput, IUploadOutput } from 'ngx-uploader-directive';
	import { IUploadProgress } from 'projects/ngx-uploader-directive/src/public-api';

	@Component({
	selector: 'app-root',
	templateUrl: './app.component.html',
	styleUrls: ['./app.component.scss']
	})

	import { HttpResponse, HttpErrorResponse } from '@angular/common/http';

	/**
	* File Upload Options.
	*/
	export interface IUploadOptions {
	requestConcurrency: number; // Number of request can be made at a time.
	maxFilesToAddInSingleRequest: number; // Number of files uploaded in single.
	allowedFileTypes?: Array<string>; // Allowed file content types.
	maxFileUploads?: number; // Max number of files that user can upload