Author Archives: Obi Oberoi

About Obi Oberoi

I am Technology Aficionado who has a passion for learning, speaking, blogging and hanging out with geeks and like minded people!

How to pass delimited list to a Stored Procedure

Let’s write a Table-valued function below. This can be created by navigating to Functions – Table-Valued Functions inside SQL Management Studio. Just an FYI, I am using the AdventureWorks database, but thisΒ  sample can be used in any situation. CREATE … Continue reading

Posted in SQL Server | Comments Off on How to pass delimited list to a Stored Procedure

Global Query Filters in EF Core 2.0

Global Query Filters are a new addition to the arsenal of features in EF Core 2.0. This also implies that EF core team spearheaded by Diego Vega who are working diligently to bring EF Core at par with its Entity … Continue reading

Posted in ORM | Comments Off on Global Query Filters in EF Core 2.0

Difference between Varchar and Nvarchar. When to use what?

This post was replaced by an erroneous content by an intruder…I will have re-write it. The inconvenience is regretted my dear lovely readers!

Posted in SQL Server | Leave a comment

EF Core 2.1 Roadmap

EF Core has had a makeover and continues to add new features to its arsenal. If you have already skipped EF Core 1.0, you might want to take a look at EF Core 2.0 and see what it has to … Continue reading

Posted in ORM | Comments Off on EF Core 2.1 Roadmap

Write a program that prints an average temperatue that is close to Zero

The idea is to get the lowest number that is close to the value zero (irrespective of the negative or positive value) from an array of average temperatures that are supplied like so: { 7, 7.9, 10.5, -4, 3, -6, … Continue reading

Posted in Algorithms & Data Structures | Comments Off on Write a program that prints an average temperatue that is close to Zero

How to check if nested brackets are in the correct logical order

I am starting a series of blog posts on algorithms and data structures with the first one being the easiest! Q. Write a method that checks if the nested brackets are in the correct logical order. The input string is … Continue reading

Posted in Algorithms & Data Structures | Comments Off on How to check if nested brackets are in the correct logical order

What package(s) do I need for EF Core 2.x?

First off, it is important to note that there are a couple of ways to download package(s). 1. You can use NuGet right from inside Visual Studio IDE 2. You can also use CLI (Command Line Interface) Here, I’ll demonstrate … Continue reading

Posted in ORM | Comments Off on What package(s) do I need for EF Core 2.x?

Mongo DB and .NET

This is my last blog post of the year 2017 where I am going to showcase how you can make the .NET application talk to a Mongo DB. Just a quick recap…MongoDB is a document database that stores data in … Continue reading

Posted in NoSQL | Comments Off on Mongo DB and .NET

What is the difference between Delete and Truncate

To order essay on an author of the essay not only that but safely. Our exchange provides a number of obligations, which guarantee customers that they will receive a high quality and decent work: each essay is checked by the … Continue reading

Posted in ORM | Comments Off on What is the difference between Delete and Truncate

What are Nested Transactions in SQL Server?

As the name suggests, nested transaction is one that is nested within a transaction. Let’s illustrate this with an example. Let’s create a table: CREATE TABLE PERSON ( ID INT IDENTITY(1,1), FirstName VARCHAR(25), LastName VARCHAR(25), Gender CHAR(1) ) SELECT * … Continue reading

Posted in SQL Server | Comments Off on What are Nested Transactions in SQL Server?