Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Powershell for .NET and SQL developer

Posted on 2014-01-27
3
Medium Priority
?
341 Views
Last Modified: 2014-01-31
Though I'm working in .NET application for long time I never use powershell in my applicatinos. I would like to know answers for below questions. Please clarify me.


What is powershell?  Where practically I could use it?

 As a .NET and SQL developer what are the frequently used commands I should know of Powershell?
0
Comment
Question by:Easwaran Paramasivam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Jens Fiederer
ID: 39812732
Powershell is essentially a more powerful replacement for COMMAND.COM that plays nicely with the Windows architecture.

It would normally be used mostly by administrators -- I have VERY rarely used it as a developer -- but as a developer you might be asked to write "cmdlets" for Powershell (unlike regular executables, these can be loaded and executed in the actual Powershell process without starting up a new process).
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39814010
Thanks. Could you please share the basic commands for a .NET and SQL developers should be aware or know?
0
 
LVL 23

Accepted Solution

by:
Jens Fiederer earned 1500 total points
ID: 39814132
You can list all the commands with simply
    get-command

Pretty much all the real basics are what you would expect -- you could do "cd", "dir", "pwd" just like in the regular shell.   You can do variable assignments like
$a = 4
or
$b = dir
and then
write $b (to see the directory you stored)
or do logic like


if ( $a -eq 4) { write $b }

I'd recommend going through an introduction like
http://technet.microsoft.com/en-us/library/hh857337.aspx
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question