Do you know, you can return JSON data from a SQL query? It is very useful in writing REST or GraphQL API on the top of a SQL Server Database. Let us say you have two tables as shown below, And an emp table as below, You can query employees with their departments as below, … Continue reading Return JSON from a SQL Query
Miscellaneous
General
Git command is taking wrong user? To solve – check CredentialManager
Yes, this was a strange scenario for me. I created Angular 2 project in Visual Studio Code and wanted to push the project into a GitHub Repository. Sounds a simple requirement right? So to publish the project to a GitHub Repository, I ran following 5 commands in the order given below: git init git add … Continue reading Git command is taking wrong user? To solve – check CredentialManager
Working with GitHub Repositories and Visual Studio 2015
Read full blog post on the Infragistics Blog GitHub is one of the most popular code sharing platforms, following the GIT algorithm for version control. In this blog post, we will learn how to work with a GitHub repository and Visual Studio 2015, and will answer the following questions: 1. How to sync or share … Continue reading Working with GitHub Repositories and Visual Studio 2015
How to Clone a Git repository in Visual Studio
In my trainings, often I get a question from junior developers that how to clone a Git repository in the visual studio? Perhaps it may be very simple for senior developers, however for the developers who struggle to get it right steps are discussed below, Step 1 Find the URL of the remote git repository. … Continue reading How to Clone a Git repository in Visual Studio
An error was raised by libgit Category =Ssh error: solved git for Visual Studio
Have you come across the error as shown in below image? You get the above shown error in Visual Studio while pulling changes from the git server. This error causes because you have local changes without the commit. In this scenario the visual Studio does not give very readable error message. Perhaps you may want … Continue reading An error was raised by libgit Category =Ssh error: solved git for Visual Studio
Video: Learn Software design – Open Closed Principle
Source Code on GitHub https://www.youtube.com/watch?v=Z_VuxB5guuA&feature=youtu.be Source Code on GitHub
How to use DebugView to Log Entity Framework
In this post I will show you to use DebugView to log the Entity Framework. For detail discussion on the same topic you may want to learn more here: Logging in Entity Framework on Steve Smith Blog Profiling Database Activity in the Entity Framework by Julie Lerman Download DebugView , unzip it and Run it … Continue reading How to use DebugView to Log Entity Framework
Unable to index file: Permission Denied error in git add command
Git permission Denied error
Getting Started with Git and GitHub
Read complete article on Falafel Blog Who is not talking about Git or GitHub? In one of our recent user group meetings, someone asked how many Pull Requests have you done so far in any of open source projects on GitHub. I realized many developers in the room were puzzled with the phrase … Continue reading Getting Started with Git and GitHub
Lenovo ThinkPad T440P: My next companion
A batsman grow with his bat, a writer grow with his pen and a programmer grow with his machine. I was my gifted my first desktop by my father back in year 2003. That was assembled desktop with following configurations, Processor: Pentium 3 1.7 GHz ||RAM: 128 MB || Hard Disk: 40 GB || 17 … Continue reading Lenovo ThinkPad T440P: My next companion
Dhananjay Kumar 