Sample powershell scripts

ProjectDir - Project Folder
OutDir - either bin\debug or bin\release or whatever set as output directory

1. To Copy files from 'some folder' into output directory  - below copies everything from 'libs' folder which is at same level as that of our Project directory into Project directory's output.

    copy /Y $(ProjectDir)\..\libs\* $(ProjectDir)\$(OutDir)\

to be contd....

BadImageFormatException in Windows 2008 R2 Server

I successfully imported PowerShell Script written using C#, but it throws System.BadImageFormatException when i tried to execute it. After spending few hours, figured out my Powershell Script was compiled for x86, so i should have used “c:\Windows\SysWOW64\WindowsPowerShell\v1.0”.

Useful tips

1. How to load all the assemblies?

var loadedAssemblies = AppDomain.CurrentDomain.GetAssemblies();

2. Combine absolute & relative paths

var relativePath = "..\\bling.txt";

var baseDirectory = "C:\\blah\\";

var absolutePath = Path.GetFullPath(baseDirectory + relativePath);

3. Get x86 Program folder

    static string ProgramFilesx86()

    {

       if( 8 == IntPtr.Size

       || (!String.IsNullOrEmpty(Environment.GetEnvironmentVariable( 

                "PROCESSOR_ARCHITEW6432"))))

       {

            return Environment.GetEnvironmentVariable("ProgramFiles(x86)");

       }

        return Environment.GetEnvironmentVariable("ProgramFiles");

    }

4. Delete a windows server

   sc delete [servicename]

5. Sometimes Server.Databases[name].Drop() will fail with 'Currently in use' error 

   or FailedOperationException. These scenarios we have to 'Server.KillDatabase()).

6. Script to create User with server admin role

 USE [master];

 GO

 CREATE LOGIN SimpleUser

    WITH PASSWORD    = N'SimpleUser',

    CHECK_POLICY     = OFF,

    CHECK_EXPIRATION = OFF;

 GO

 EXEC sp_addsrvrolemember

    @loginame = N'SimpleUser',

    @rolename = N'sysadmin';

7. Sn -T [assembly] to get PublicKeyToken.

8. Remove database(s) based on name

DECLARE @Temp TABLE (Id INT IDENTITY(1, 1), name nvarchar(max));
DECLARE @RowCounter INT;
DECLARE @i INT;

INSERT INTO @Temp select name from sys.databases where name like N'GS_81%'

SELECT @RowCounter = MAX(Id) FROM @Temp

SET @i = 1

DECLARE @DBDeleteByName NVARCHAR(max);

WHILE @i <= @RowCounter
BEGIN
    SELECT @DBDeleteByName = 'DROP DATABASE [' + name + ']'  FROM @Temp WHERE Id = @i

    EXEC sp_executesql @DBDeleteByName;

    SET @i = @i + 1;
END

Unity and PolicyInjection

Good references

http://bardevblog.wordpress.com/2011/03/21/aop-policy-injection-with-unity/
http://msdn.microsoft.com/en-us/magazine/gg535676.aspx
http://msdn.microsoft.com/en-us/magazine/gg490353.aspx

Smartbear Code Collaborator GUI client not recognizing Subversion repository

Sometimes creating SCM configuration in Code Collaborator GUI client for a SVN server will not work and might get 'svn not found' or 'path not found' error. Please visit this link for fix

CmdLet in windows 7

http://blogs.technet.com/b/josebda/archive/2009/11/25/download-for-powershell-v2-for-windows-7-no-need-it-s-already-there.aspx

http://blogs.msdn.com/b/saveenr/archive/2010/03/08/how-to-create-a-powershell-2-0-module-and-cmdlet-with-visual-studio-2010-screencast-included.aspx

LINQ : IEnumerable and IQueryable

http://blogs.msdn.com/b/wriju/archive/2008/05/06/linq-ienumerable-t-and-iqueryable-t.aspx
http://forums.asp.net/t/1257200.aspx/1