MVC Add NewController using T4 Text Template..

When we click on AddNewController-

in background MVC uses T4 Text Templates 'Controller.tt' to create new controller.cs file. 

Location of .tt file is

C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\ItemTemplates\CSharp\Web\MVC 4\CodeTemplates\AddController\Controller.tt

SQL AZURE Database Backup

SQL AZURE Database Backup If We are using Azure SQL Database and in case you want to take back up of existing database for

 1] Before making new deployment or schema changes


 2] or to create a testing database with identical schema and data as existing source db then



 --Script #1 -

Creating a database copy CREATE DATABASE AdventureWorksCopy AS COPY OF AdventureWorks
GO

 --Script #2 - Package wise events

SELECT * FROM sys.dm_database_copies 

 This is an asynchronous operation so you can monitor progress using Script 2 or refresh Management Studio to see expected list of tables.