About this Blog
As a dot net programmer, we should know few important statistics of the application we are working on. This ensures that application is consistent in nature. In application with fewer projects it is earlier to get these statistics manually but in larger projects it become un productive task however still important. As an example multiple team member may add new projects with varying .Net framework version, programming language version etc.. The initial version of this utility can help you generate these statistics in a second and in a consistent form.
Below blog will cover
Prerequisite for this utility
How to use this utility
Prerequisite for this utility
- You need .Net framework version minimum 4.0.0 to run this utility.
- You also need ‘command prompt’ window to view the result.
- Dotnet solution file which has multiple projects in it.
How to use this utility
Open the command prompt and go to the path where this utility exe is kept and type Dotnetversion.exe
Press ‘Enter’ key.
About the application is displayed:
Press any key to continue…
Enter the Dotnet solution file path. If Solution file path is same as path where this utilty Dotnetversion.exe file is kept simply press Enter ELSE type the accurate path where dotnetsolution file is kept, like D:\ABC\XYZ\ etc..
Once solution file path is specified, next option is to enter the Solution file name. Again, if only 1 file exist at Selected folder path simply Press ‘Enter’ key ELSE specify the solution file name. No need to specify the file name extension.
Once both the solution file path and solution file name is given stats collection processing will start.
- The stats will show how many projects current solution had.
- Programming language of the project like CSharp/VB.Net.
- Programming language version. For CSharp projects it can be like 4 or 5 or 6 etc. For Vb.net projects it can be 11 or 12 or 13 etc.
- Dotnet framework version of the project
Project File name
As an example, I executed it on sample solution on my machine an both projects are .net framework 4.0 based.
Attached the exe file in this blog Download Link. Feel free to ask for questions.
I had written this utility last year on:
Further worked on the nuget package of this utility and v0.0.0.8 is now available at link: Nuget Typehierarchy package link
Oreilly is giving free access to manybooks related to programming languages like Java, Python, reactive etc. and topics like software architecture, software engg, Microservices, Cloud, Swift, Rx, RUST etc..
Free EBooks for Oreilly
Do not miss this chance!
Portable class library(PCL) concept is quite popular in Xamarin world. However in .Net 4.6.1 and onward this has been deprecated.
The way going forward is .Net standard libraries. So now when you create new Project in Xamarin suggested to use .Net Standard Library instead.
Sometimes we require PC camera to be captured from within a WPF application. Achieving this is not a daunting task. Few open source and commercial library are available in the market that help us achieve this.
AForge is one such library. Attached is a sample WPF application using AForge.
Sample WPF application zip
Those who have worked with Microsoft Azure Data lake know the use U-SQL. For others you can read a good definition here:
What is U-SQL
It is possible to create U-SQL project in Visual studio. For that you must have Azure SDK already installed on your machine. Once there you need tool Microsoft.Azure.DataLakeAndStreamAnalyticsToolsForVS2015.msi from location:
Microsoft Azure Data Lake and Stream Analytics Tools for Visual Studio
After success install of this tool you can open Visual studio and you will find new entry for the corresponding project and template.
As of Aug 2017, googled the link to download the latest version 5.1 and found below:
Powershell 5.1 on microsoft site. Refer figure below
Click on download button to move to next page and select the appropriate .msi to download.
“W2K12-KB3191565-x64.msu” may be the file you choose for download and run. So i did
the same and found the error that this may not be the correct setup to run.
Read on article to choose the correct file on
Powershell on Win server 2012 R
Went back to download page and this time downloaded the file as per below snapshot:
and executed it. It ran successfully.
To build always-on, scalable, distributed applications in azure from your development machine, you need to ensure right tools are already installed.
This blog is to install tools for VS 2017.
While installing or modifying VS 2017 on your development machine ensure option ‘Azure development’ is checked on.
Apart from this you need Microsoft Azure Service Fabric SDK on your machine. The SDK gets installed using Web installer 5.0. The link for SDK is:
Visual studio is now ready to allow you create service fabric applications.
Choose the service you want to create:
The purpose of this blog is to get the dev aware of how the PowerShell can be used to connect to MySQL db and insert a sample record.
With the increase of automation in industry, powershell is made responsible for doing many more things including inserting a new record in MySQL database.
The script flow start at line 28 by setting bthe username/ password/ database name, server name of the MYSQL database. By Default the port to connect db is 3306.
$query parameter of powershell need to be set for correct insert DML statement.
Next is Powershell function call which takes username, password, server, database, query as parameter. Line 1 to 26 is PowerShell function which handles this.
For this function to work perfectly it necessary for[reflection.assembly]::LoadFrom(“C:\abc\MySql.Data.dll”)
Statement to execute with success. What this statement do is load MySQL.data.dll assembly in script.
Its >net and MySQL connector Dll. You can get this dll by creating a new project in .Net Visual studio and add a new package by searching ‘MySQL’. Make sure you correctly set this DLL path in script.
This function takes care of establishing the connection with MySQL, Open the connection, execute the SQL DML query and return the response.
I tested this script in Windows 10, Powershell 4 and MySQL 8.4.5 and works fine.