Discoholic 🪩
oozey mess
let's talk about Bridgerton tea, my ask is open
🪼
PUT YOUR BEARD IN MY MOUTH
shark vs the universe
RMH
d e v o n
@theartofmadeline
Andulka
祝日 / Permanent Vacation
❣ Chile in a Photography ❣
taylor price
"I'm Dorothy Gale from Kansas"
Origami Around
No title available
occasionally subtle
No title available
Monterey Bay Aquarium
Alisa U Zemlji Chuda
seen from United States
seen from Malaysia
seen from Germany
seen from United States
seen from Chile
seen from South Korea
seen from Singapore
seen from Germany
seen from Thailand
seen from Malaysia
seen from Türkiye
seen from Chile
seen from Japan
seen from Australia
seen from Croatia
seen from Vietnam
seen from Brazil
seen from United States
seen from United States
seen from Malaysia
@nikhildoomra
SQL : NULL comparison
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…)
View On WordPress
SQL : Inserting metadata or values in master table
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…)
View On WordPress
The server principal 'someuser' is not able to access the database 'somedbname' under the current security context.
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…)
View On WordPress
Angular Tutorial Series - Angular CLI Introduction
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…
View On WordPress
Angular Tutorial Series
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…
View On WordPress
Error in installing .NET Framework 4.7.2 - not supported on this operating system.
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…)
View On WordPress
GIT | Cheat Sheet
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…)
View On WordPress
npm - linking and unlinking
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…)
View On WordPress
Delete all node modules in the directory
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.
View On WordPress
C# | Generic Converter
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…
View On WordPress
ASP.NET WEB API | TypeConverter and ModelBinders
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…)
View On WordPress
C# | Nullables and null-coalescing operator
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…)
View On WordPress
C# - Custom Attributes
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…
View On WordPress
Error SQL70001: This statement is not recognized in this context
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…
View On WordPress