Nikhil Doomra

SQL : NULL comparison

In SQL there are times when we want to check whether one of the column value is NULL or is not Null. Some might think as I thought that the direct comparison like = or <> would work.

(more…)

SQL : Inserting metadata or values in master table

Usually when developing any SQL based system, we need some master tables which contains values and Ids which are consistent and same as enums in our code. But when you set an identity column in the table it would not let you insert the Id of your choice. So there is a flag which you can turn on and then insert the rows, and then turn the flag back off.

(more…)

The server principal ‘someuser’ is not able to access the database ‘somedbname’ under the current security context.

Recently I faced a issue where when you try to connect to a database in an environment using EntityFramework, it gives you the below error:-

The server principal ‘someuser’ is not able to access the database ‘somedbname’ under the current security context.

(more…)

Angular Command Line Interface aka Angular CLI

Angular CLI is used to generate code/files for various things used in Angular like Components, Services etc. We would be discussing these topics in more detail in upcoming posts.

If you have followed my previous post, then you would have already installed Angular CLI, if not then please go to the post and follow the steps there.

Now let’s use Angular…

In this series of posts I would like to go in depth of Angular 7+ versions. This page is the index/table of contents page and would be updated as I add more content to this series and all the articles would be linked from here. All the topics which are linked have content and others which are not linked are in progress. 

Some part of the tutorial would need Backend service, for which I would be…

Error in installing .NET Framework 4.7.2 – not supported on this operating system.

Problem:

If you are installing .NET Framework 4.7.2, you might see error message like

Blocking Issues:

The .NET Framework 4.7.2 is not supported on this operating system.

(more…)

GIT | Cheat Sheet

Many times we need to refer to Git help or search for Git commands online. To make the process easier, I am creating a cheatsheet for Git commands.

(more…)

npm – linking and unlinking

PROBLEM :

A lot of times when we code, we have to code in shared code or modules which would be used by lot of people and we definitely don’t want something like that to break and affect lot of people.

(more…)

Delete/uninstall all node modules in the directory

Sometimes when you are coding in VS Code and you want to clean up node_modules folder, you either delete the files directly or you can run the below command in VS Code’s PowerShell terminal which is pretty handy.

ls node_modules | ForEach-Object { npm uninstall $_.name}

Hope this might be useful to some people who want to automate things.

C# | Generic Converter

There are times when we need to dynamically convert/parse the object from its string value to its type.

Below is the generic converter code which we can use instead of creating method for each type.

SomeType temp; var strVal = "StringValueofObject"; var converter = TypeDescriptor.GetConverter(typeof(temp)); temp = (SomeType)converter.ConvertFromString(strVal);

It basically gets the…

ASP.NET WEB API | TypeConverter and ModelBinders

So its being a while working on WEB API and still it surprises with me everyday with the new way I can extend it. In this article I would like to share TypeConverters and ModelBinders, how they fit into everyday work and how they can make the API access easier for end clients.

(more…)

C# | Nullables and null-coalescing operator

Nullables are the special value types which can contain their range of values along with null as an additional value.

Nullables are very useful especially when we deal with database or external systems where there is a possibility of empty or null value for an expected value type.

Lets see how nullables can be created and used.

(more…)

C# – Custom Attributes

Attributes in C# is a way to declaratively add some metadata to the code which can then used to add some functionality using reflection.

Like in XML or HTML we have attributes to define some piece of functionality similarly in .NET we can add attributes to classes, properties, methods etc. All the places where the attributes can be declared or used can be found in AttributeTargets Enumeration.

So…

Error SQL70001: This statement is not recognized in this context

Today, I got this weird error on my SQL script in Visual Studio 2017, where in it was highlighting various SQL statements when I copied the SQL file and added it to the project. Below is the exact error in Visual Studio 2017.

Error SQL70001: This statement is not recognized in this context.

However, the solution is simple. Select the file in the solution explorer, click F4 and change the Build…