Here’s a list to help you get started with cross-platform mobile app development using Xamarin Forms. Xamarin Visual Studio 2015 Android SDK Windows 10 OS While you can work with Windows 8 as well, you will need Windows 10 operating system if you are going to develop for Windows 10 Universal App. Mac with Xcode... » read more
Here’s a handy SQL function that allows to insert string(s) inside a larger string. This function is similar to String.Format() function in C#. Typical Usage: Have a string like below: “%s is a. %s and %s does %s ” with as many ” %s ” as required to dynamically insert values. Insert desired string objects... » read more
In the previous post we looked at what Cyclomatic Complexity is and why it is important to write programs with low Cyclomatic Complexity. Here I would like to show an example of reducing Cyclomatic Complexity with the use of Delegates. This post is going to be extremely code intensive so buckle up guys! Let’s start.... » read more
Cyclomatic Complexity is a software metric used to calculate the complexity of a program. It is a measure of number of possible use case flows for a given program’s source code and is directly dependent upon the number of control flow statements (if/else statements and switch cases) within the code. For example, a method with... » read more
Web Scraping Data For Hollywood Actors/Actresses Info A friend of mine and I were discussing about the divorce rate/trends of Hollywood actors. Basically she was claiming that most of the actors have multiple wives and have gone through divorce in Hollywood. I was not so much in agreement and so came this project. I created... » read more
Wellington, the capital of New Zealand is welcoming 100 of the best people from around the world to work in their tech companies. The capital is a hot spot for innovative and leading tech companies and now they are creating a wonderful platform for employers to hire people from around the world. It’s a great... » read more
A SQL Developer is responsible for managing data in a relational database. Database Providers like Microsoft, Oracle and MySql have their own IDE for managing data. For example Microsoft has SQL Server Management Studio for this purpose and Oracle has Oracle Developer Studio. A SQL Developer makes use of these IDEs for managing data. Today... » read more
In this short article, we will look at how Dependency Injection for Data Access Objects can be implemented using Spring.NET. “Data Access support in Spring is aimed at making it easy to work with data access technologies like ADO.NET and Nhibernate in a standardized way.”- Spring.NET First an interface that exposes the methods that can... » read more
RODBC is a useful package for making SQL queries to SQL Server database for R users. To start using this package, first we need to make sure it is loaded into R studio. is.installed <- function(mypkg) is.element(mypkg, installed.packages()[,1]) if(!is.installed('RODBC')) { install.packages("RODBC") } library(RODBC) Now that the package is installed/loaded into our environment, let’s start making... » read more
Introduction Usually it is expected from client side to upload only structured Excel sheets (sheet with defined Column Names and data types for Rows) to load to server. But sometimes you might also require to dump whatever is in the Excel directly to your database. While there is a tool that is provided by SQL... » read more