Run Large(eg: 10gb) script file in MS SQL database

Import/Run large(eg: 10gb) script file in MS SQL database using below command:

1. Open command prompt with Administrator mode
2.  sqlcmd -S ServerName -U UserID -P Password -d DataBaseName -i C:\Users\gprao\Downloads\ProjectTrac\ProjectTrac.sql

DI (Dependency Injection) and IOC (Inversion of control)

1. DI (Dependency Injection) or IOC (Inversion of control) basically used to manage dependency in our application.

2. DI and IOC, used for creating dependency and inject whenever it is required.

3. This is very helpful when we are going to make thing tightly coupled to loosely coupled.

4. There are many IOC containers available but Unity, Ninject and Autofac are the three most common and popular containers are used in .Net

For more:

https://www.codeproject.com/Articles/1061457/IOC-Container-For-Net-Unity-Ninject-Autofac-at-a-g

Web Farm and Web Garden - Better performance of website

Web Farm:

When you are hosting your single web site on multiple web servers over load balancer is called “Web Farm”

In a single statement, when we host a web application over multiple web servers to distribute the load among them, it is called Web Farm.

Web Garden:

Now, by default, each and every Application pool contains a single worker process. Application which contains the multiple worker process is called “Web Garden”.


For Read more:
https://www.codeproject.com/Articles/114910/What-is-the-difference-between-Web-Farm-and-Web-Ga

Multi Tenancy

Multitenancy:
                      Multitenancy is an architecture in which a single instance of software runs on a server and serves multiple tenants. A tenant is a group of customers who share a common access with specific privileges to the software instance.

Each customer shares the same application and also shares a single database or load single database  based on logged in customers.

Strongly typed binding to a DropDownListFor In MVC

Bind dropdown in MVC.

Using Strong Type:

Step1: Prepare Your model Like below

The code in your controller will look like this:

In the view you can use it like this:

MVC Contents

1. Getting Started with ASP.NET MVC
2. Working with Database
3. Working with Validation
4. DB First Approach - Entity Framework
5. Code First Approach - Entity Framework
6. ASP.NET SignalR