Wednesday, March 29, 2017

New Features–Out Variables in C# 7.0

Prior to C# 7.0,  For out keyword, we need to define that variable earlier and then we were able to pass that variable as out reference arguments. But now with C# 7.0, You don’t need to declare the variable but you can use the variable which you have used in arguments.

Following is a code showing both ways passing out variables.

In the above code, You can see that I have created get employee static method which put some values in this out variables. First I have shown the old way of doing this. Where I explicitly defined the variables and then passed it to function while in the new way of doing you don’t need to explicitly define variable. You can write this as an argument and then, later on, you can use the same variable in next statements.  Now when you run the application, the new and old way both produce the same output.


You can find complete source code of this examples at following location on Github at-

Visual Studio 2017 New Features Series

Visual Studio 2017 is recently launched by Microsoft and it is one of great IDE I have ever seen. It contains lots of features and this blog post contains the link to all features post that I have written for Visual Studio 2017.

A new start page for Visual Studio 2017
Code Navigation features in Visual Studio 2017 


Code Navigation features in Visual Studio 2017

This blog post is a part of Visual Studio 2017 New feature Series


With Visual Studio 2017 there are lots of new Code Navigation features introduced. We are going to look all the options available in Visual Studio 2017.

Navigation your code with Visual studio 2017:

Visual Studio 2017 have newly refreshed code navigation features which help you moving from point A to B easily and fewer distractions. There are mainly four new features available.

Go to Implementation(Ctrl+F12):

It helps you navigate from any base type to implementation of the concrete type.


Go To Line(Ctrl+G):

It helps moves cursor from current line to specified line number.


Go To All(Ctrl+T):

It helps you navigate directly to any file/type/symbol/member. You can move from any files to anywhere with this feature easily.


Go To File(Ctrl+ 1, Ctrl + F):

You can easily navigate between files with this feature.


Go To Type(Ctrl+1, Ctrl + F):

You can move to any type with this feature. It searches classes/interfaces/enums and delegates and moves your current cursor selected type.


Go To Member(Ctrl+ 1, Ctrl + M):

You can move between members for a particular class. It searches Global Variables and Global Functions, Class Member variables and member functions, Constants, Enum items, Properties, and events.


Go to Symbol(Ctrl + 1, Ctrl + S):

You can move to any symbols, search result includes Go to Type and Go to Member.


Find All References(Shift + F12):

In the earlier version of Visual Studio Find All References was the plain list without any syntax highlighting and coloring. Now with Visual Studio 2017 it has got coloring and splits all the information into their respective columns. This column can be also customized so you will only see what you want to see in Find All References Window.


So Visual Studio 2017 now got lots of features and that will make code navigation very easy. It will definitely increase developer productivity and made life easy.
Tuesday, March 28, 2017

A new start page for Visual Studio 2017

This blog post is a part of Visual Studio 2017 New feature Series
Recently Microsoft has released a new version of Visual Studio 2017 and as usual, there are tons of features available with Visual Studio 2017. Visual Studio has always been one of my favorite IDE. We are going to look into all the features one by one. The first thing when you launch a New instance of the Visual studio will launch a start page. So in this blog post, we are going to explore what’s new in start page of Visual Studio 2017.

A new start page for visual studio 2017

The first thing once you load visual studio 2017 will have a start page. It has been divided into three columns. The first column contains Get Started and Recent sections. The second column contains Open Project and New Project section and the third column contains Developer new section. By default when you load Visual Studio it looks like following.


Get Started and Recent Section of Start Page:
Get Started section of Visual Studio 2017 contains how you can get started with Visual Studio. It contains a variety of links including how to get started with Visual studio to how to extend visual studio.


The recent section contains recently open projects. It is divided into two part Today and Last week. Today section contains the link to the project that is opened today in Visual Studio.  Last week section contains projects that are used during last week.

Open and New Project Section:
The open section contains four things.
  1. A link to connect Visual Studio team services from where you can directly connect to a team services project and open it from there.
  2. Open Project/Solution: - Open project or solution works in same as the earlier version of Visual Studio. It open project or solution available on your computer.
  3. Open Folder: - It will open a folder available on your computer and then display all the code files available in that particular folder.
  4. Open Web Site: This works same as earlier of Visual Studio. It opens an ASP.NET Web Sites available on your local computer.

New Project is brand new in Visual Studio 2017. By default, it shows the recent project's templates you recently used and also there is search box to search the templates available in Visual studio 2017.

Even you search templates via putting some text in the search box like following.

So now to create a new solution or project you don’t have go to file menu. You can directly create a new project from start page itself.

Developer News Section:
This developer new section contains new feeds from various sites.


Customize Start page in Visual Studio 2017:

Like earlier edition of Visual Studio, you can also customize the start page of Visual Studio 2017. There is an option available for the same under Tools-> Options menu. Select environment and Goto Startup following dialog will come.


Here you configure options like At startup what should be shown. You can also setup time to download the content of developer news. Also, you can also use customize start page.

That’s it. Hope you like it. Stay tuned for more!!.
Monday, March 27, 2017

New Blog theme- new technologies

This blog has been quite for the some time. I was busy doing some professional commitments but now I decided to write blog post regularly. As there are lots of interesting stuff happening in technology world. There are tons of new technologies coming up and lots of new things to learn.

New blogger theme:

Recently has launched few new theme and I also decided to have new blogger theme on my blog. I have used “Contempo” theme for my blog. This time I have done some experiments I have not changed anything except the background feature. Let’s see how it goes with SEO and other stuff.  Here is new look of my blog.


Hope you will like it.

New Technologies to blog :

There are lots of stuff happening in technology and I started learning those technologies and I’m going to share my learning experience with you guys for sure. So do except blog post on following topics.
  1. Visual Studio 2017
  2. ASP.NET Core 1.1
  3. C# 7.0
  4. Entity Framework Core
  5. .NET Core cross platform
  6. Docker
  7. Node.js
  8. Golang
  9. SQL Server 2016
  10. MongoDB
  11. Azure and Different Azure services
  12. Angular 2/4.
  13. React
  14. Vue.js
I outlines few of technologies there but still there are lots of happening so Please put your comments that what technologies I should learn and blog about.

As always, Again thank you very much for the your support and love. Without your support this blog would have not have been exist. Thanks all as always.

Happy blogging and journey continues.

A Review of Stellar Phoenix SQL Database Repair

SQL Server is a database server developed by Microsoft, the primary function of which is to store and retrieve data in the database MDF and NDF files. It retrieves data as requested by several software applications running on same or different computer across a network. Plus, it has a lot of concurrent users. Aimed at various enterprise segments, it caters to different workloads ranging from a small single-machine to large Internet-facing applications.

Although data on it is stored in a safe and secure manner, yet there are instances when it’s MDF and NDF files get damaged or turns inaccessible due to one or more reasons. Moreover, this happens irrespective of the SQL Server versions that can be 2016, 2014, 2012, 2008, etc. When they get damaged, they come up with several and unique error messages. Such a situation restricts you from accessing the stored data of the database. This creates the necessity for using a third-party software that can repair both these files and extract the complete data out of it. Here, Stellar Phoenix SQL Database Repair would serve the purpose. Let’s look at how.

Developed and marketed by Stellar Data Recovery, Stellar Phoenix SQL Database Repair is a software the purpose of which is to repair the damaged or corrupt MDF and NDF files of Microsoft SQL Server and save all the extracted data in multiple formats such as MS SQL, HTML, XLS and CSV. Here, we present to you a review on this product for you to get in-depth details about it. With this, you can check whether the software achieves your purpose of perfectly repairing the database files and recovering the entire data; and, that whether you can use it in case the primary MDF and secondary NDF files of the SQL Server database gets damaged or turns corrupt.

First, it is imperative to acquaint with its salient features as well as benefits. Let us look at the features and benefits embedded in the software.

Features & Benefits:

· It can repair the damaged or corrupt MDF and NDF files of your SQL Server database.
· It can search for MDF files on the PC and repairs it successfully.
· It can retrieve almost all the database components ranging from Tables, Triggers, Views, Rules, Keys, Indexes, to Defaults.
Note - The Keys that can be recovered are Primary Keys, Unique Keys, Foreign Keys, and Identity, while the Indexes that can be recovered are both Clustered as well as Non-clustered indexes.
· It can recover both ROW and PAGE compressed data of the SQL Server database files.
· It has an exceedingly fast Scan feature with which you can scan the damaged MDF and NDF files.
Note - With this, you can identify and fix the issues quickly and recover all the data objects without fail.
· It allows you to preview the objects that can be retrieved and appear as a scan result after the end of the scanning process.
· It connects to the server automatically when interrupted for completing the repair process and restoring the data.
· It can even recover the Deleted records by using the remarkable feature embedded in the software.
· It offers you the option to move and save database files to Live SQL Database after the repair process gets over.
· It gives you the option to save the fixed database files in multiple formats such as CSV, XLS, and HTML in addition to MS SQL.
· It supports the latest released version i.e. MS SQL Server 2016 in addition to lower releases such as MS SQL Server 2014, 2012, 2008, and all others.

Now, to be able to execute these features and avail the benefits of this software when you have a damaged or corrupt MS SQL Server, your system must fulfil minimum system requirements, which are as follows

· The system must be embed with Pentium Class processor only.
· The supported operating system are Windows 10, 8, 8.1, 7, Vista, and XP as well as Windows Server 2008/2003.
· The system must possess a minimum of 1 GB memory; however, the recommended size is 2 GB.
Lastly, the free space in the system hard drive should be at least 50 MB to get the software installed correctly.

Note - These system specifications are easy to achieve and almost all Windows systems possess these minimum system specifications by default.


The working of the software is described here and takes you through the steps to repair the corrupted MDF & NDF files of MS SQL Server.

Select, Repair, and Save are the three most important steps that you need to carry out with this software to successfully repair the damaged SQL database files.

· Select – As displayed in the image below, with the ‘Select Database’ option that is present in the interface of the tool; you need to select the damaged database file from any location in your system. However, if you do not know the same, you must use the ‘Search in Folder’ and ‘Find’ tab to search and find all the database files. If you want to locate the file in subfolders as well, you must mark the option ‘Search in subfolders.’ Further, to scan for and recover the deleted records, you must check the ‘Include deleted record’ option.


· Repair – Once you have selected the database MDF file, you must click on the ‘Repair’ button to scan the MDF file. With this, you get a list of all the recoverable objects as shown in the image below. Further, you can select the ones for which you require a preview.


· Save – Finally, there is a message that the selected SQL database file has been successfully repaired, and the software prompts to click on the OK tab to save the file in a new database. This is the third and last step that you have to follow with the software. When you do this, you get options to save the file in MS SQL, HTML, CSV, and XLS that you can select as per your choice. Next, it gives you the option to save in ‘New database’ and ‘Live database’, and again you can choose as per your requirement. Finally, the retrieved objects of the SQL Server database file get saved. The images below display the ‘Saving’ step.

User have four options to save the database.


After selecting MSSQL, two options are there
· New Database
· Live Database



Choose any options from these two and save the database.



Now you know the features, system requirements, and working of the Stellar Phoenix SQL Database Repair software, you can analyze the tool and check whether it meets the purpose. A better way to try this utility is to download its demo version. You can then register the software if you find it satisfactory. Given its efficiency in repairing the SQL database file with precision and speed, I would give it an 8.5 on 10.

Support this blog-Buy me a coffee

Buy me a coffeeBuy me a coffee
Search This Blog
Subscribe to my blog


My Mvp Profile
Follow us on facebook
Blog Archive
Total Pageviews