Demo SQL Provider Code

Hi,


Attached is the code we used today in the Web cast for the SQL demo provider. Please note this is not a SQL management provider. It simply allows you to query data from a SQL server directly from the cmd line.


Install the Snapin: 


PS>$env:Windir\Microsoft.NET\Framework\v2.0\.50727\InstallUtil.exe SQLProvider.dll


Add the snapin to your session:


PS>Add-PsSnapin SqlPrototypeProvider


You can use it as follows:


PS>cd SQL:


SQL:>cd MySQLServer


SQL:>dir


master
tempdb
model
msdb
pubs
Northwind


SQL:>cd Northwind


SQL:>dir


name
—-
Categories
CustomerCustomerDemo
CustomerDemographics
Customers
dtproperties
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories


SQL:>cd Employees


SQL:>Dir -filter {where EmployeeId=8}


EmployeeID      : 8
LastName        : Callahan
FirstName       : Laura
Title           : Inside Sales Coordinator
TitleOfCourtesy : Ms.
BirthDate       : 1/9/1958 12:00:00 AM
HireDate        : 3/5/1994 12:00:00 AM
Address         : 4726 – 11th Ave. N.E.
City            : Seattle
Region          : WA
PostalCode      : 98105
Country         : USA
HomePhone       : (206) 555-1189
Extension       : 2344
Photo           : {21, 28, 47, 0…}
Notes           : Laura received a BA in psychology from the University of Washington.  She has also completed a course
                   in business French.  She reads and writes French.
ReportsTo       : 2
PhotoPath       : http://accweb/emmployees/davolio.bmp


 Wassim [MSFT]


 


 

SQLProvider.zip