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
mastertempdbmodelmsdbpubsNorthwind
SQL:>cd Northwind
name----CategoriesCustomerCustomerDemoCustomerDemographicsCustomersdtpropertiesEmployeesEmployeeTerritoriesOrder DetailsOrdersProductsRegionShippersSuppliersTerritories
SQL:>cd Employees
SQL:>Dir -filter {where EmployeeId=8}
EmployeeID : 8LastName : CallahanFirstName : LauraTitle : Inside Sales CoordinatorTitleOfCourtesy : Ms.BirthDate : 1/9/1958 12:00:00 AMHireDate : 3/5/1994 12:00:00 AMAddress : 4726 - 11th Ave. N.E.City : SeattleRegion : WAPostalCode : 98105Country : USAHomePhone : (206) 555-1189Extension : 2344Photo : {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 : 2PhotoPath : http://accweb/emmployees/davolio.bmp
Wassim [MSFT]