Dotnet Project and solution statistics

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

Result

Prerequisite for this utility

  1. You need .Net framework version minimum 4.0.0 to run this utility.
  2. You also need ‘command prompt’ window to view the result.
  3. 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.

Result

  1. The stats will show how many projects current solution had.
  2. Programming language of the project like CSharp/VB.Net.
  3. 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.
  4. Dotnet framework version of the project
  5. 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.

Advertisements

SQL Server DB Statistics

About

In any application persistence of data is required. Database play very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables to manage the data for us. However apart from Tables many more entities exist in these databases.

The attached utility can help a developer or a DBA for get more insight into the database they are working on. There are many aspects related to database however this utility is first step towards knowing few general statistics about the database.

Prerequisite for the Utility

How to use

Results

What Next

Prerequisite for the Utility

  1. This utility has been created using .net version 4.0.0. The utility contains only so only need .net framework 4.0 or higher on your machine to run this utility
  2. This utility require connection to database so you need connection string something like “Data Source=.\SQLEXPRESS; Initial Catalog=DatabaseName; Integrated Security=True; MultipleActiveResultSets=True”. This is just a sample representation of a connection string make sure you have correct connection string for your database available with you. Since I used windows authentication so this string does not have username and password ang in your case this string can contain username and password also.
  3. You also need MSDB database connection string. Few of the statistics will be picked from this database. As part of any fresh installation of SQL server you always get MSDB database. Sample connection string would be like “Data Source=.\SQLEXPRESS; Initial Catalog=MSDB; Integrated Security=True; MultipleActiveResultSets=True”. Since I used windows authentication so this string does not have username and password ang in your case this string can contain username and password also.
  4. Since you are accessing 2 databases make sure you have appropriate access rights on these 2 databases

How to use

  1. Attached utility contains only single .exe file. Simply copy the attached zip to any folder in my machine say D:\DBstats\, unzip it, unlock it and you are ready to use the utility.
  2. Open command prompt and go to folder where this utility is kept say D:\DBstats\.

  3. Type DatabaseStatistics.exe to run this utility.

  1. README about this utility is displayed. Read it to understand what this utility will do for you. Press any key to continue…

  1. Enter connection string something like:

    Press Enter.

  2. Enter MSDB connection string:

    Press Enter and utility is ready to get all the statistics it need.

Results

Below are the statistics snapshot generated by this utility:

What Next

Working on next version on this utility to get more statistics.

 

 

exe download link: Download Exe

No PCL based Library in Xamarin going forward

Portable class library(PCL) concept is quite popular in Xamarin world. However in .Net 4.6.1 and onward this has been deprecated. PCL1

The way going forward is .Net standard libraries. So now when you create new Project in Xamarin suggested to use .Net Standard Library instead.

PC camera capture in WPF application

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

WPFWebCam1

U-SQL project template in Visual Studio

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

for blog

After success install of this tool you can open Visual studio and you will find new entry for the corresponding project and template.

Update PowerShell to 5.1 on Windows server 2012R2

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
2

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.

Azure: Cosmos DB vs Document DB

Azure Cosmos DB is the globally distributed, multi-model database service for building planet scale apps. You can easily build globally-distributed applications without the hassle of complex, multiple-datacenter configurations. Cosmos DB automatically replicates all of your data to any number of regions of your choice, for fast, responsive access. Cosmos DB guarantees 99.99% high availability.

Only Cosmos DB allows you to use key-value, graph, and document data in one service.

 

One of the APIs Azure Cosmos DB supports is the SQL (DocumentDB) API.

That means Document DB service is now part of Cosmos DB services. Cosmos DB also allows you to use your favorite API like JavaScriptGremlinMongoDB, and Azure Table storage to query your data.

https://azure.microsoft.com/en-in/blog/dear-documentdb-customers-welcome-to-azure-cosmos-db/ is a good link to read further.

 

Azure Fabric service

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.

Azure Components in VS 2017

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:

MicrosoftAzure-ServiceFabric-CoreSDK

 

Fabric SDK installation step

 

Fabric SDK installation step succeed

Visual studio is now ready to allow you create service fabric applications.

Goto File–>New–>Project–>Cloud

Visual studio 2017 Service Fabric template

Choose the service you want to create:

Visual studio 2017 Service Fabric template selection